- SafetyJNJMechAsked on February 06, 2018 at 04:53 PM
I have Google sheets integrated with my form:
Within the Google SheetIt was working fine up until this morning when it failed to update. I reset the integration, however, the dates now come in in the mm/dd/yyyy format and not the required dd/mm/yyyy format.
Within my account settings
I have my Time Format set to EU-Asia - DMY
Within my Google Sheets setting:
Locale This affects formatting details such as functions, dates, and currency. Time zone Your spreadsheet's history will be recorded in this time zone. This will affect all time-related functions.
The date format within the actual form is as follows:
- SafetyJNJMechAnswered on February 06, 2018 at 05:12 PM
The integration has stopped again this morning only 30mins after re-integrating it.
- JotForm SupportJed_CAnswered on February 06, 2018 at 08:30 PM
I checked your spreadsheet date and it shows as DD/MM/YYYY format. Please note that it uses your location or computer's default time format https://support.google.com/docs/answer/58515.
Please check if your locale time settings is your preferred time format. Let me know if that helps.
Regarding the integration, did you make any changes / edits to your spreadsheet after integration?
- SafetyJNJMechAnswered on February 07, 2018 at 06:19 PM
Thank you Jed_C, I beleive the times were incorrect due to the person's computer time being set wrong. The times on the report changed after I entered into the original submission and resubmitted.