Google Spreasheets column not being populated with form submission data

  • Profile Image
    RichMad
    Asked on August 16, 2017 at 09:00 AM

    I have a setup integration  see https://docs.google.com/spreadsheet/ccc?key=1xktWqvT1Ft7a-HzjN1RR6Lbtvo8g6Awtj44KQX7n2aQ

    But if you look at column D, E and F these are unfilled

    If you look at https://mail.google.com/mail/u/0/#inbox/15de73509e3dd66c

    Ref line 5, as you can see dates 28-07-2018 and 10-08-2018 is not shown on the spreadsheet.

    Problem 2

    Look at https://mail.google.com/mail/u/0/#inbox/15de72f9abb3a595

    This ref to line 4 on the spreadsheet

    As you can see column C shows Yes but no data for column D should read 08-09-1017

    Otherwise, everything seems to be ok, it is great addon so simple to look at the spreadsheet.

    Can you advise me how I can get the data to show?

    Richard Quick

     

     

  • Profile Image
    jonathan
    Answered on August 16, 2017 at 10:41 AM

    The issue is happening because you have modified the column header names of the Sheet used in the google integration.

    The column headers should match the field names in the form for the integration field mapping process to work properly.

    In form:

     

    In spreadsheet:

     

    To fix, remove the current integration and then redo it.

    The integration process should generate the spreadsheet column headers matching to those in the form. We recommend not altering or renaming the spreadsheet Sheet column header names to avoid disconnection in the form google integration.

    Let us know if this did not resolve the issue.