- cmaimpactteenAsked 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.
- JotForm SupportJohn_BensonAnswered on June 11, 2017 at 02: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.
- cmaimpactteenAnswered on June 12, 2017 at 07:43 AMI 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
- JotForm SupportcandyAnswered on June 12, 2017 at 09:58 AM
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:
I hope this helps.