Correct Typeform time stamps for GSheet Integration | Community
Skip to main content
Answered

Correct Typeform time stamps for GSheet Integration

  • June 2, 2024
  • 1 reply
  • 20 views

My Type form is adding rows to a Google Sheeet with each new form entry using the standard Tyepform GSheet Integration. The Timestamps being added to the Gsheet with each new entry from Typeform are set to the incorrect time.
Where can I adjust this setting in Typeform.

Best answer by john.desborough

@Dutchy - the timestamps from Typeform are in UTC as they are stored in the server. This ensures consistency in the data regardless of geolocation. 

you’ll need to convert the timestamps in the Google sheet to match the timezone you wish to use: suggest though that you create an additional field in the Sheet to do this conversion 

 

des

View original

john.desborough
Forum|alt.badge.img+6

@Dutchy - the timestamps from Typeform are in UTC as they are stored in the server. This ensures consistency in the data regardless of geolocation. 

you’ll need to convert the timestamps in the Google sheet to match the timezone you wish to use: suggest though that you create an additional field in the Sheet to do this conversion 

 

des


Reply