What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.


  • Profile Image

    JotForm override modification done on Google spreadsheet sheet

    Asked by robert594 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

    Page URL:
    https://www.jotform.com/build/71547023161246

  • Profile Image
    JotForm Support

    Answered by jonathan 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

    Answered by robert594 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
    JotForm Support

    Answered by jonathan 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)