When a form is submitted it shows the GMT date & time however when an automation email is sent it sent as UTC. Can someone please help me fix this.
Thank you.
Solved
How do I change the time zone on automation actions?
+6Best answer by TheTimeSavingCo
Yes I have set up a trigger for an email to be sent but even though the time zone for my forms & data pages/interfaces show BST when the information gets sent on the email it is changed to UTC.
Ah, try using a formula field with DATETIME_FORMAT and SET_TIMEZONE, and use that formula field in your email
https://support.airtable.com/docs/formulas-and-date-fields
https://support.airtable.com/docs/supported-timezones-for-set-timezone
+31Hmm, are you referring to when the automation triggers?
Or are you referring to how dates are displayed in emails perhaps?
+6Hmm, are you referring to when the automation triggers?
Or are you referring to how dates are displayed in emails perhaps?
Yes I have set up a trigger for an email to be sent but even though the time zone for my forms & data pages/interfaces show BST when the information gets sent on the email it is changed to UTC.
+31Yes I have set up a trigger for an email to be sent but even though the time zone for my forms & data pages/interfaces show BST when the information gets sent on the email it is changed to UTC.
Ah, try using a formula field with DATETIME_FORMAT and SET_TIMEZONE, and use that formula field in your email
https://support.airtable.com/docs/formulas-and-date-fields
https://support.airtable.com/docs/supported-timezones-for-set-timezone
+6Ah, try using a formula field with DATETIME_FORMAT and SET_TIMEZONE, and use that formula field in your email
https://support.airtable.com/docs/formulas-and-date-fields
https://support.airtable.com/docs/supported-timezones-for-set-timezone
Thank you I'll try this now. Appreciate the help!
+6Ah, try using a formula field with DATETIME_FORMAT and SET_TIMEZONE, and use that formula field in your email
https://support.airtable.com/docs/formulas-and-date-fields
https://support.airtable.com/docs/supported-timezones-for-set-timezone
Neither is working 😢
+31Neither is working 😢
Could you provide a screenshot of the data in your table, a screenshot of the email that's sent out, and an example of what you would want the email to show?
+31From your screenshot it doesn't look like you used a formula field with DATETIME_FORMAT. Could you provide a screenshot of your formula field and the automation setup?
Here's how my formula field looks:
And here's both fields in an email:
+6From your screenshot it doesn't look like you used a formula field with DATETIME_FORMAT. Could you provide a screenshot of your formula field and the automation setup?
Here's how my formula field looks:
And here's both fields in an email:
you're amazing thanks a bunch I've sorted it now!! 😊
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.