- zingielAsked 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?
- zingielAnswered 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?
- JotForm SupportNik_CAnswered 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.
- JotForm SupportNik_CAnswered 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):
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.
- zingielAnswered on November 26, 2017 at 12:21 PM
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 :)
- JotForm SupportJohn_BensonAnswered 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.
After that, you can hide the default submission date and show the Date Picker field on the Submission page.
Here's the clone/demo form that you can check: https://form.jotform.com/73295214128960
You can also clone it by following this guide.
- JotForm SupportJohn_BensonAnswered 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
- JotForm SupportJohn_BensonAnswered 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.
- JotForm SupportJohn_BensonAnswered 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.