Not all fields show up in google sheet

  • Profile Image
    DiscoveryCharterSchools
    Asked on July 19, 2019 at 01:28 AM

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

    1563514033Capture.PNG

  • Profile Image
    jherwin
    Answered on July 19, 2019 at 02: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.

  • Profile Image
    DiscoveryCharterSchools
    Answered on July 19, 2019 at 12:55 PM

    No it is not.

  • Profile Image
    jherwin
    Answered on July 19, 2019 at 01: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.png
    While the header name on your google spreadsheet is this:
    1563556149current.png
    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

  • Profile Image
    DiscoveryCharterSchools
    Answered on July 19, 2019 at 02: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.

  • Profile Image
    jherwin
    Answered on July 19, 2019 at 02: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.

  • Profile Image
    DiscoveryCharterSchools
    Answered on July 19, 2019 at 02:42 PM

    I have changed the name.

  • Profile Image
    Richie_P
    Answered on July 19, 2019 at 03: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