JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Integrating multiple forms into a single Google Spreadsheet.Asked by eyeconic on July 25, 2016 at 10:21 PM
Actually this can be achieved by using the import range, if you set the destination spreadsheet to update automatically in the settings.
Go to File > Spreadsheet Settings > Re-Calculate > "On Change and Every Minute/Hour"
This will cause it to constantly pull the new data from the other spreadsheets regardless if there is a change detected or not manually.
I hope this helps! It helped me in a similar situation importing a field that was using an auto date range calculation to determine number of days since a specified date.
Thank you for the suggestion @eyeconic. This will be very helpful for other users who might want to do the same. However, I would suggest to create a new spreadsheet where we will use the ImportRange function. This is to ensure that the integrated spreadsheet is kept intact, since any modifications done to the integrated spreadsheet may cause the integration to break. Cheers.
Of course. I did not mention that directly, but referred to the new spreadsheet as the destination spreadsheet. You definitely want it to be separate.