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

    Submission date not saved properly

    Asked by Zbulo on May 24, 2015 at 12:40 PM

    Heya JotForm team,

    my form submission go into a Google Spreadsheeet, this worked well so far but for some reason the submission date is now corrupted or saved in some strange string.

    What should be: 24/05/2015 16:15:xx Turned out: 42148.428506944

    Any clue how I can fix this? The date is used for some calculations so crucial to me. 

    Thanks,
    Ricardo

    Page URL:
    http://www.jotformeu.com/form/51122290160339

    saved Properly JotForm calculations thanks
  • Profile Image
    JotForm Support

    Answered by jonathan on May 24, 2015 at 05:33 PM

    Hi Ricardo,

    We apologize for any inconvenience caused.

    But usually, this issue can be fixed also by resetting the Google Spreadsheet integration to the form.

    To reset, just remove first the existing integration

     

    and then redo the integration again.

    user guide: -How-to-Integrate-Form-with-Google-Spreadsheet

     

    Please try the suggested process. Let us know if this still did not fix the submission date data issue on the spreadsheet.

    Thanks.

     

     

     

  • Profile Image

    Answered by Zbulo on May 24, 2015 at 06:16 PM

    Thanks, that fixed it. Any way to prevent this from happening / known cause?

    Cheers!

  • Profile Image
    JotForm Support

    Answered by jonathan on May 24, 2015 at 07:24 PM

    Actually, the issue could also be caused by updates on Google side.. so, there could be inconsistency on the timing when issue happens. But our devs are consistently monitoring them so that they can at least minimize or lessen any downtime if such conflict happen.

    But yes, to fix this issue the same issue, just try always first to refresh the integration.. and it should work most of the time.

    Please don't hesitate to contact us anytime for any assistance you need on jotform.

    Thanks.