-
SafetyJNJMechAsked on February 6, 2018 at 4:53 PM
I have Google sheets integrated with my form:
- Form = form https://form.jotform.co/SafetyJNJMech/prestart
- Sheet = https://docs.google.com/spreadsheets/d/13fVvpCkIHcNv8FxWyjI8jj2b4h08sWBj3C2J4fXnUz8/edit?usp=sharing
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:
-
SafetyJNJMechReplied on February 6, 2018 at 5:12 PM
The integration has stopped again this morning only 30mins after re-integrating it.
-
Jed_CReplied on February 6, 2018 at 8: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?
-
SafetyJNJMechReplied on February 7, 2018 at 6: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.