What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How do I retrieve the submission dates on the spreadsheet?

    Asked by milanawithconvo on August 29, 2016 at 04:17 PM

    I am not sure what happened, but the dates suddenly won't be documented after my co-workers submitted the form. I have attached the screenshot for you to view... I hope you can help me with retrieving the date for future submissions.

    Thanks.

    Screenshot
    retrieve how how do i submission dates
  • Profile Image
    JotForm Support

    Answered by Kiran on August 29, 2016 at 06:20 PM

    Did you integrate Google Spreadsheet to your form and experiencing the issue in the sheet? If so, did you make any changes to the sheet? Could you try removing the existing Google spreadsheet integration and try integrating it again to see if that helps?

    I have tried downloading the submissions to an Excel sheet and see that the submissions are having submissions date properly. 

    Let us know if you are referring to something different. We will be happy to help. 

  • Profile Image

    Answered by milanawithconvo on August 29, 2016 at 07:45 PM
    that's correct, it's integrated to the Google spreadsheet since January with all important order submissions. the spreadsheet has few other tabs of copied sheets as well that I'm afraid of losing if I re-try to integrate it to the Google spreadsheet. Will it return to the sheet if I do that?
    ...
  • Profile Image
    JotForm Support

    Answered by Charlie on August 30, 2016 at 12:25 AM

    You can still re-integrate Google Spreadsheet to fix the issue, usually that resolves the problem.

    Now with regards to your concern, when you remove the integration and re-integrate it again, the old spreadsheet will NOT be deleted, instead a new one will be created and all the existing submission data of that form will be automatically loaded in the new spreadsheet. The old spreadsheet will remain in your Google Drive, however, it will no longer receive submissions and updates. The newly created spreadsheet will be the only one that will work on the integration. 

    Here's a sample re-integration I made, you can see that my old spreadsheet is still there and the new one has been created:

     

    May we know if you have changed the column headers on your spreadsheet, if you did, then that would explain why the specific column is not receiving the submission data specific to that field. You need to revert the column name to the original one that it has to make it work again. I strongly suggest re-integrating so that a fresh integration is made.

    If you are worried that you'll lose data, you can simply copy a version of that spreadsheet or download it on your local storage for backup purposes.

    Let us know if that helps.