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

    Need advice on Google Sheet integration BEFORE we set it up

    Asked by dohafamily on September 18, 2015 at 04:15 PM

    We moved to JotForm from AdobeFormsCentral (AFC). With that platform we could add columns or reorder the existing columns without affecting the data - LOVED that feature.

    From what I'm reading here in the JF Forum, though, if we do integrate a JotForm with GoogleSheets and then add a column or move them around it will "break the integration". This is a bit of a bummer but I think we can work around it with a bit of advice.

    (1) Can I somehow add fields to our form that are invisible to the user, but ultimately provide columns in GoogleSheets that we can populate as needed? 

    (2) Our form is already set up and we have 150+ responses. Once we add the extra fields from (1) will we be able to download all of the existing information into GoogleSheets and then set it so that future submissions automatically dump in there as well? 

    (3) Let's say the information has been dumped into GoogleSheets and I need to change the email address of one of the respondents. Will that "break" the integration?

    (4) Is there anything else I need to know - any useful tips, both "make sure you do this" and "don't do that" type of things?

     

    Thanks!

    sheet Submissions responses integrate edit submission google spreadsheet
  • Profile Image
    JotForm Support

    Answered by jonathan on September 19, 2015 at 01:34 AM

    Thank youj for providing us a detailed description of your inquiry. 

    Here are the answers to them

    #1. Yes.

    You can add the regular field (i.e Textbox field) on the form and then Hide it from end-user using its Hide property.

     

    The hidden field will be visible/available as column in the Form Submission View grid as well as on the integrated Google Spreadsheet.

     

    #2. Yes.

    When you re-integrate the form to Google Spreadsheet, which you should do after adding the hidden field, the integaration will generate again a new Submission spreadsheet in the Google Docs.

    Succeeding submissions of the forms will automatically include all the fields/column into the spreadsheet as well. 

    #3. Modifying anything on the Google Spreadsheet itself will most likely will 'break the integration'.  We always recommend to not do any modification on the integarted spreadsheet.

    How to apply update and reflect it to your Spreadsheet?

    Do it on the Submission Data of the form itself.

    user guide: http://www.jotform.com/help/325-How-to-Edit-Submissions-Made-on-Your-Forms

    Once you have updated the necessary data(answers), do the Google Spreadsheet re-integration proccss again. This will then result to an updated Google spreadsheet.

    #4. Ultimately, just do not do any modification on the integrated spreadsheet itself. And all will be fine. 

    Hope this help. Let us know if you need further assistance.