Getting Wrong Submission Timestamp

  • Rahusaini24
    Asked on July 3, 2021 at 5:17 AM

    Hi team,


    I am getting wrong submission time stamp for each jot form entry in the google sheet.


    Jot filled at 03-07-2021 12:00:00

    Submission timestamp in Google Sheet: 03-07-2021 16:00:00 (Difference of 4 hours)

  • Johann_A
    Replied on July 3, 2021 at 7:46 AM

    Greetings.

    Can you please check if the time zone is properly set from your account settings? If it is, does the problem occur in multiple forms or only in this one? Is every submission affected? Do you have any other time fields in your form and are they not displaying correctly as well?

    Also how your computer's time is configured? Are you by chance using a VPN?

    Thank you for your cooperation.

    Johann

  • Rahusaini24
    Replied on July 3, 2021 at 10:22 AM

    current timestamp is correct in my laptop , I am facing this issue in all jot form timestamp

  • VincentJay
    Replied on July 3, 2021 at 3:53 PM

    Hi,

    The time on your submission can be updated on the account setting page.

    1625341766 60e0bf46de1d8 af23ce2325 Screenshot 10

    After that, please try re-integrating the form to the Google Spreadsheet by following this guide: https://www.jotform.com/help/228-how-to-integrate-forms-with-google-sheets