Google intergration not working properly

  • Profile Image
    tonycrowther
    Asked on November 25, 2015 at 06:13 AM

    I created a survey form today "How did we do?" and set up Google integration to view the results of three trial runs via my website www.georgeatburpham.co.uk

    The first run (using my name) worked, but the next two ignored some data - 'Town' and the matrix rating section.

    It might not be relevant but I did delete a few unwanted columns in the Google spreadsheet!

    Any idea why?

     

    Tony Crowther

    tony-crowther@sky.com

  • Profile Image
    Kevin_G
    Answered on November 25, 2015 at 01:01 PM

    Hi,

    Thank you for contacting us.

    I cloned your form and have integrated with Google Spreadsheet, but I was not able to replicate your issue, I deleted some fields, Data of Visit and Time of Visit, could you tell us which fields have you deleted ? 

    I'm getting the correct data into my Google Spreadsheet.

    Let us know and we will be glad to assist you.

    Regards.

  • Profile Image
    tonycrowther
    Answered on November 25, 2015 at 01:46 PM
    It seems that if I edit the Google sheet in any way at all, it affects its ability to 'collect' all data (esp. for the fields whose titles I edited).
    I've just accepted that I shouldn't edit it in in any way.
    Sorry to bother you.
    Tony
    On Wednesday, 25 November 2015, 18:00, JotForm wrote:

    New response received A new response has been received: Answered by Kevin_G Hi,Thank you for contacting us.I cloned your form and have integrated with Google Spreadsheet, but I was not able to replicate your issue, I deleted some fields, Data of Visit and Time of Visit, could you tell us which fields have you deleted ? I'm getting the correct data into my Google Spreadsheet.Let us know and we will be glad to assist you.Regards. View this thread on browser » Unsubscribe Thread 1448474481

    ...
  • Profile Image
    Kevin_G
    Answered on November 25, 2015 at 02:59 PM

    Hi,

    Thank you for sharing us that.

    Sometimes the integrations is broken while editing the Spreadsheet.I would suggest you to copy the data into another Spreadsheet and make the changes there in order to avoid any issue.

    Let us know if you have more questions, we will be glad to assis you.

    Regards.