Issue with google spreadsheet integration.

  • Profile Image
    SNC
    Asked on February 20, 2014 at 09:39 AM

    There seems to be some issues with spreadsheet integration. When I set up the integration, all data is submitted just fine. When a new submittion is recived the data is incomplete and I think is because of the way the field names are being transfered.

    For example:

    Submission Date - when set up it sends data that looks like 02/20/2014 09:19:44 (contains leading 0)
    When it is newly added from form it looks like this: 2/20/2014 9:26:46

    I have three other fields that are having issue, the data is not being enterd at all. (See screen shot)

    Is there a way to correct this? Other than reintergrating the form every time that is..

     

    Thank you,

    Doug

  • Profile Image
    EliezerN
    Answered on February 20, 2014 at 10:48 AM

    Hi,

    We apologize for the inconveniences this may have cuased.

    I cloned your form and integrated it to do some tests. And I can confirm that I was able to reproduce the issue upon testing the integration, the data of the three fields with date as label  were missing:

    Then, I removed the integration, changed the label of the three checkbox questions, reintegrated the the form with the spreadsheet and finally sent some submissions and it worked perfectly at this time:

    So, all you need to do is to modify/change the labels so that they cannot be read as Date-time in the spread sheet, you can change them to something like this:

    Then you can reintegrate your form with the spreadsheet and it will work correctly.

    Please inform us if you need further assistance.

    Thanks

  • Profile Image
    SNC
    Answered on February 20, 2014 at 11:16 AM

    Thank you for the quick responce. I was also able to rename the columns in the spreadsheet to match the name of the fields on the form and that worked too.

  • Profile Image
    Welvin
    Answered on February 20, 2014 at 12:29 PM

    It's our pleasure! Am I right to assumed that the issue is resolved? Please do let us know if you need any further assistance.

    Thanks