- lamccrayAsked 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?
- CarinaAnswered on June 02, 2014 at 04:48 PM
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.
- lamccrayAnswered on June 03, 2014 at 08:01 AMI 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)
- BryanPauloAnswered on June 03, 2014 at 10:21 AM
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.