Why is Google Docs integration is overwriting submissions?

  • cmaimpactteen
    Asked on June 10, 2017 at 10:05 PM

    When new people submit a submission using our jot form it is overwriting the previous submission instead of adding the record to the  document. It worked until June and now as each person completes the form it adds the person to record number 2 and overwrites the previous person in the form as record 2.

    Please let me know how we can fix this issue.

  • John_Benson
    Replied on June 11, 2017 at 2:06 AM

    I checked the Google Spreadsheet integration and it is working properly on my end. Please try re-integrating the Google Spreadsheet again to your form. To do that, please follow this guide: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    Also, I have cleared your form cache from our server so it will be refreshed. 

    Please give it a try and let us know how it goes. Thank you.

  • cmaimpactteen
    Replied on June 12, 2017 at 7:43 AM
    I had tried to sort the document by last name and that is when it fell apart. It is working correctly now. Is there anyway to set it up so it will sort by last name instead of submission date?Thanks,Jennifer
    ...
  • candy
    Replied on June 12, 2017 at 9:58 AM

    Dear Jennifer, 

    The submissions will be sorted by the submission date, automatically. However, if you click on the arrow on the header, you will be able to sort them as you wish as you can see the screenshot of a spreadsheet below:

    Why is Google Docs integration is overwriting submissions? Image 1 Screenshot 20

    I hope this helps.

    Thanks.