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

    New form field not passing to integrated google sheet

    Asked by dmandel on May 23, 2016 at 12:41 PM

    Hello JotForm support team,

    I added a new field to the form linked below. When I receive new submissions with a value in this required field, the values are not passed through to the Google sheet linked to the form. Can you please advise? Thanks very much. 

    Jotform: https://form.jotform.com/60824813389160

    New field that's not passing values to the Google sheet: Sfunster Email - please provide so that we can follow-up for more details on the opt out request if necessary. 

    Google sheet: https://docs.google.com/spreadsheets/d/1HZClpsrDVPBda1TNAUYRMNIe4aBUtl5MRloPGims0w4/edit#gid=1451734989

    Best,

    Daniel

    Page URL:
    https://form.jotform.com/60824813389160

    passing values google spreadsheet
  • Profile Image
    JotForm Support

    Answered by Mike on May 23, 2016 at 02:00 PM

    Thank you for contacting us.

    Please re-integrate your form with the Google Spreadsheet service to fix this issue.

    Also, please note that column names should be kept in default formats (it is not safe to re-name them). Otherwise, the data will not be sent to the corresponding column(s).

    If you need any further assistance on this, please let us know. We will be happy to help.

  • Profile Image

    Answered by dmandel on May 23, 2016 at 02:45 PM
    Thanks for the reply, Mike.
    Is the only way to re-integrate the JotForm & Google Sheet to remove the
    integration and then set it up again? Will I lose any of the historical
    data?
    Best,
    Daniel
    Daniel Mandel // Senior Manager - Marketing Automation
    O 510.740.2782
    C *216.780.8663 *
    E dmandel@sungevity.com
    Sungevity // Generate Positive // 66 Franklin Street, Oakland, CA 94607
    ...
  • Profile Image
    JotForm Support

    Answered by Mike on May 23, 2016 at 03:13 PM

    Yes, you will need to remove the integration to be able to set it up again. The current form data will be automatically imported to the new sheet. However, if you have any custom modifications on your current sheet, such modifications will not be added to the new sheet.