JotForm override modification done on Google spreadsheet sheet

  • Profile Image
    robert594
    Asked on June 04, 2017 at 06: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

  • Profile Image
    jonathan
    Answered on June 04, 2017 at 07: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.

     

  • Profile Image
    robert594
    Answered on June 04, 2017 at 07:43 PM
    Thank 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





    ...
  • Profile Image
    jonathan
    Answered on June 04, 2017 at 08: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 Usage

    IMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123abcd123", "sheet1!A1:C10")

    IMPORTRANGE(A2,"B2")

    Syntax

    IMPORTRANGE(spreadsheet_key, range_string)