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.
Link multiple forms into single google spreadsheetAsked by elgabriello on February 14, 2015 at 09:24 PM
I am experiencing a similar issue. I am linking a 2nd gdoc sheet to the one that is receiving the jotform results through an importrange formula and it does not seems to update automatically.
Have you found a way to work around this issue ?
Moreover, importrange seems to work on manual update but not on new form filling.
I think that's because of the update timeframe of the ImportRange function in Google Spreadsheet. From the link that is provided by my colleague, you can improve the ImportRange update time by following the workaround in this link: https://productforums.google.com/forum/?nomobile=true#!topic/docs/BsOdrVdZYdI. I haven't tried this, but this is the closest workaround to update your spreadsheet almost instantly.
Or, use Zapier to connect multiple forms to a single spreadsheet: https://zapier.com/zapbook/jotform/google-docs/3379/add-jotform-submission-to-google-docs-row/. I have already tried this and I would say, this is a very good alternative.
Let us know if you have any further questions.
By the way, here are the links for my test using Zapier:
Note that the spreadsheet will be updated for every 5 minutes. Just test the forms to see the output.
Thank you so much for your answer !!!
So indeed it seems to be a lag of update of the importrange function.
My problem is that I have
1 a form
2 a submission sheet
3 a shared sheet with submission results that some other people have access to
My problem is the link between 2 & 3 that is important to me as I don't want too many people to access directly the submissions sheet.
Any ideas on how to increase the importrange function update timeframe ?
I have tried several work arounds (dynamicimportrange script, now function etc etc) maybe a macro ?
Unfortunately, I personally don't know much of the ImportRange function in Google Spreadsheet. I used this method before, but then again, the second spreadsheet will be updated only when you manually visit the original sheet. I've also searched the NOW function, but it looks like it's not supported anymore in the new google spreadsheet.
I've found this: http://stackoverflow.com/questions/24336011/force-importrange-to-update-at-certain-intervals. Maybe this will help. Can you try it? Will also review this one.
How about the integration in Zapier? You may consider using that as an alternative to ImportRange. You can use two spreadsheets for one form. Just create two zaps.