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.
Copy jotform submissions sheet into another sheetAsked by lamccray on June 02, 2014 at 02:36 PM
I would like to copy the sumbissions from a jotform generated google sheet but I am experiencing issues. I want to use the copy of the sheet to manage and assign the requests. The copied sheet does not auto copy the new submissions using the importrange function. To get it to update I have to manaually edit the function. Just to make sure this was an isolated issue I checked to see if importrange worked using two other spreadsheets and it worked fine. Does jotform prevent the copying of jotform generated sheets? Is there a work around to this issue?
I also could not import the Excel submission list into a Google Spreadsheet.
I believe the best way is to create a Google Spreadsheet Integration in your form and then merging both spreadsheets.
Let us know if the problem persists.
I have the jotform data going to a google sheet. I have copied that sheet
into another google sheet and I am having issues with the new sheet not
updating automatically when new form entries are received.
Business Systems Analyst | Information Technology
University of Michigan Athletic Department | Stephen M. Ross Athletic Campus
1000 South State Street | Ann Arbor, MI 48109-2201
MGoBlue.com | Phone: (734) 936-0963 | Fax: (734)
Have you used the IMPORTRANGE function? To fetch the data from the JotForm spreadsheet to the second sheet, kindly use the following syntax:
spreadsheet_key - The long sequence of characters in the "key=" attribute of the URL. In the new Google Sheets, use the entire URL.
You can read more about importrange function HERE.
Let us know if you need further help.