Question

Date stamp mismatch between Airtable tables due to Zapier time zone setting?

  • 30 November 2023
  • 27 replies
  • 80 views

Badge

I have a zap that updates a date stamp in an airtable table (Table 1) once a form is submitted from jotform into another table in airtable (Table 2), the zap then updates the date stamp in Table 1. I have an automation that sends out an email when this date stamp in table 1 is 1 day ago. But there is an issues with that dates - in table 2 the submission date of the form from jotform sometimes different to the date stamp that is generated in table 1. 

What could be the cause of this? The time zones in airtable and Jotform are both London, but a time zone in zapier was not specified. I have now changed this to London - will this solve my issue?


27 replies

Badge

Okay I see, so it will be the same time as the created time pulled form jotform?

Userlevel 7
Badge +14

@jakerwatson 

It’s a timestamp when the Zap step runs.

Reply