How to keep time zone of submissions correctly?

  • Profile Image
    zingiel
    Asked on November 26, 2017 at 06:11 AM

    More than 20 submissions have been sent (for the course).

    The form I have integrated with Google spreadsheets is where I process this data. I saw that the date 'Submission Date' is not in my time zone.

    I've now changed my time zone settings for my location. New entries have a valid date, but previous requests still have a bad time zone. Data records do not have information about which time zone is the date.

    Can I now know the time zone to which this date belongs?

  • Profile Image
    zingiel
    Answered on November 26, 2017 at 06:19 AM

    And what is the value of the 'Submission ID' field, is it somehow associated with date and time? If so how and with what time zone?

  • Profile Image
    Nik_C
    Answered on November 26, 2017 at 09:31 AM

    I'm not sure what was the time zone set, but if you have an issue with how the data showed in Google Spreadsheet, you can re-integrate with Google Spreadsheet so all data will be shown in new Google Sheet. https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    That should solve the issue with previous entries as well.

    Regarding the Submission ID, submission ID is a unique number that represents each submission. It is not related to date and time, just to submission itself.

    If you need any further assistance please get back to us.

    Thank you!

  • Profile Image
    Nik_C
    Answered on November 26, 2017 at 11:20 AM

    1. I checked your form but there are only 4 submissions. I don't have a way to check the time zone of your submissions, but I see that the time is correct now since you changed the time zone (I did a test submission):

    1511712972Screen Shot 2017-11-26 at 5.20

    So submissions from this point will be correct, but I'm not sure for the previous ones since they are not showing on the submissions page.

    You could share the Google Spreadsheet so we can try to do some additional checking.

    2. I'm sorry, but we don't have that information, ID is, anyhow, used only for submission uniqueness.

    Let us know if you have any further questions.

    Thank you!

  • Profile Image
    zingiel
    Answered on November 26, 2017 at 12:21 PM

    1511715367arkusz1.png

    Rows 2 and 3 belong to the first version of the form, I'm referring to rows 4 and 5 (6 is yours), row 4 arrived before the time zone change in my account settings, row 5 is after.

    The problem is in my wife's (where I help) form, where there are already more than 20 lines in two days, and when I change its settings it will be difficult in the future to know the real date and time of sending data from the form.

    There would be no problem if one of three solutions were used:

     - 'Submission Date' would always be GMT (UTC + 0), then I could add my time offset;

     - in addition to 'Submission Date', there could also be information about the timezone of this datetime;

     - changing the time zone in my account settings would modify the date in 'Submission Date' in all records: what are already and what will be.

    2. Does the developer of your server software know how to build 'Submission ID', maybe it is not a secret, maybe I know it too, I assume that this value also includes the exact datetime of sending data from the form :)

  • Profile Image
    John_Benson
    Answered on November 26, 2017 at 01:41 PM

    You can try using the Date Picker field and set it as current/custom or let the user choose.

    15117216082saaz.png

    After that, you can hide the default submission date and show the Date Picker field on the Submission page. 

    1511721589datespioc.gif

    Here's the clone/demo form that you can check: https://form.jotform.com/73295214128960

    You can also clone it by following this guide.


  • Profile Image
    John_Benson
    Answered on November 26, 2017 at 01:48 PM

    2. Does the developer of your server software know how to build 'Submission ID', maybe it is not a secret, maybe I know it too, I assume that this value also includes the exact datetime of sending data from the form

    I believe the submission IDs are generated randomly. You can try using the Unique ID widget if you need an ID like on your submissions. Here's a guide: https://www.jotform.com/help/79-How-to-Add-Custom-Unique-IDs-to-your-Form-Submissions


  • Profile Image
    John_Benson
    Answered on November 26, 2017 at 02:36 PM

    1.1. It's a misunderstanding. Date submission should be the date of the submission and not the date the user fills!

    You can set the Date Picker field to Current and enable the Read-only option in the Properties page.

    1.2 I will have to remember when I have a changed time zone in my account settings and thus I will interpret 'Submission Date' in two ways.

    If you do not want to use the Date Picker field, the best way to do this is via Account Settings and change the Time Zone.

    2. No answer?

    The submission IDs are generated randomly. You can try using the Unique ID widget if you need an ID like on your submissions. Here's a guide: https://www.jotform.com/help/79-How-to-Add-Custom-Unique-IDs-to-your-Form-Submissions

    I hope this helps. Contact us again if you have questions.

  • Profile Image
    John_Benson
    Answered on November 27, 2017 at 08:28 PM

    1. Unfortunately, we do not have an option for 1 second or millisecond. However, I can forward this to our developers for a feature request if you want.

    2. For the submission ID, each submission is unique. For example, if multiple users submit the form at the same exact date/time/seconds, it will not be the same ID. You're also correct that the submission IDs are increasing. As far as I know, it is also related to the total submission made here in JotForm. (I hope this help on your investigation)

    If you need more clarification or have questions, feel free to contact us again. Thank you.