-
robert594Asked on June 4, 2017 at 6:13 PM
Hi there,
I am trying to use the third party integration with Google Sheets.
It appears that whenever a new submission is received, JotForm overrides any changes I previously made to the Google Sheet. Is there a way around this?
Also, I have tried using Zapier to take a JotForm submission and add it to Google Sheets. The problem is I am using an input table on my JotForm. When I go to set-up the Zap, I only have the option to select the entire Input Table, and not the individual rows. How can I fix this? I have contacted the Zapier support, and they have not been very helpful.
Thanks so much!
Robert -
jonathanReplied on June 4, 2017 at 7:28 PM
It appears that whenever a new submission is received, JotForm overrides any changes I previously made to the Google Sheet. Is there a way around this?
This is by design. Unfortunately there is no workaround to override this behavior in the google spreadsheet integration. We also recommend not modifying the Submission Sheet in Google spreadsheet to avoid disconnection issue and breaking the integration.
If you want a customize sheet in the Google spreadsheet that have the submission, you can do it using a separate Sheet. You can import the data from the Submission Sheet to your custom Sheet using the Import Range function of Google spreadsheet.
Also, I have tried using Zapier to take a JotForm submission and add it to Google Sheets. The problem is I am using an input table on my JotForm. When I go to set-up the Zap, I only have the option to select the entire Input Table, and not the individual rows. How can I fix this?
This is by design as well. Even using the direct Google spreadsheet integration, will also not allow you to pre-select which fields will be included in the integration. It will map the entire table of the form submissions.
I hope this help. Let us know if you need further assistance.
-
robert594Replied on June 4, 2017 at 7:43 PMThank you. If I use the IMPORTRANGE function on a new sheet, will it remain constantly updated? (i.e. when a new submission to JotForm is made, the new spreadsheet will update?)
Thanks!
R
Robert Barkin
Assistant Director (Administration)
robert@camparrowhead.ca
Camp Arrowhead
4936 Yonge Street, Suite 111
Toronto, ON M2N 6S3
www.camparrowhead.ca
... -
jonathanReplied on June 4, 2017 at 8:01 PM
Hi Robert,
Yes. The custom sheet which import the data from the Submission Sheet will be updated every time new submissions from the form is created.
As far as I know this should work because the spreadsheet key will not change in the Submission Sheet every time it is updated with new submission data from the form.
Ex:
Sample UsageIMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123abcd123", "sheet1!A1:C10")
IMPORTRANGE(A2,"B2")
SyntaxIMPORTRANGE(spreadsheet_key, range_string)