Not all fields show up in google sheet

  • DiscoveryCharterSchools
    Asked on July 19, 2019 at 1:28 AM

    I have a form integrated with google sheet but the field Current Parent Email data does not show up in Google.

    1563514033Capture Screenshot 10

  • jherwin
    Replied on July 19, 2019 at 2:42 AM

    I have pushed the data to your integrated Google Sheet from our end. Please check to confirm whether the data is now visible on the integrated Google Sheet.

  • DiscoveryCharterSchools
    Replied on July 19, 2019 at 12:55 PM

    No it is not.

  • jherwin
    Replied on July 19, 2019 at 1:16 PM

    I reviewed your submission page and found that the header name in your submission for that field is different from the header in the spreadsheet.

    The field name in your submission page is:
    1563556106parent current email Screenshot 10
    While the header name on your google spreadsheet is this:
    1563556149current Screenshot 21
    Please note that changing the header/field name in the spreadsheet itself can break the integration. To fix this and to send the value from your submissions page to the spreadsheet, you need to re-integrate your form to sheets again.

    Guide: How-to-Integrate-Forms-with-Google-Sheets

  • DiscoveryCharterSchools
    Replied on July 19, 2019 at 2:12 PM

    Thanks!  Can't I just change the name on the current sheet?  I have things integrated to that particular url so I didn't want to change the sheet url.

  • jherwin
    Replied on July 19, 2019 at 2:27 PM

    I'm not sure if that will work because the integration is already broken. We can try this if you like, match the header name first and we'll try to push submissions again to your spreadsheet.

    Do get back to us once you're done so we can continue to make your request.

  • DiscoveryCharterSchools
    Replied on July 19, 2019 at 2:42 PM

    I have changed the name.

  • Richie JotForm Support
    Replied on July 19, 2019 at 3:14 PM

    To clarify, you have updated your column header in your Google Sheet?

    I have manually pushed the form submission to your Google Sheet.

    If the submissions are still missing for that particular column, you would need to re-integrate your form with Google Sheet.

    How-to-Integrate-Forms-with-Google-Sheets