-
JoaneMarletAsked on June 13, 2019 at 3:14 AM
-
Mike_G JotForm SupportReplied on June 13, 2019 at 3:39 AM
The Date field, with the Time option enabled, has an option to have the current date and time when the form loads.
With regards to linking the date to Google Spreadsheet, please know that the Submission Date of the form is also sent to the integrated spreadsheet on a separate column by default.
If you have other questions or concerns, please do not hesitate to let us know.
-
JoaneMarletReplied on June 13, 2019 at 3:48 AM
Got it. but is there a way to change the timezone? Or is there an alternative widget that has the same options (with read-only) and can set the timezone? I need to update it with timezone GMT-4
thank you.
-
Mike_G JotForm SupportReplied on June 13, 2019 at 4:23 AM
The Date field will have the same date on the device where the form is accessed. However, the Submission Date in the integrated Google Spreadsheet is similar to the Submission Date on the submissions page of the form.
You can change the Timezone of the Submission Date on the submissions page of your form by following the instructions in this guide — How-to-Change-Submission-Date-to-a-Different-Format-and-Timezone.
Regardless of the timezone where the form was submitted, it will be converted to the timezone set in your account on the submissions page.
I hope this helps. If you have other questions or concerns, please feel free to let us know.