Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 26, 2024 03:16 AM
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! Go to Solution.
Sep 26, 2024 03:33 AM
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
Sep 26, 2024 07:32 AM
From 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:
Sep 26, 2024 03:29 AM
Hmm, are you referring to when the automation triggers?
Or are you referring to how dates are displayed in emails perhaps?
Sep 26, 2024 03:32 AM
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.
Sep 26, 2024 03:33 AM
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
Sep 26, 2024 03:35 AM
Thank you I'll try this now. Appreciate the help!
Sep 26, 2024 04:19 AM
Neither is working 😢
Sep 26, 2024 05:23 AM
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?
Sep 26, 2024 05:42 AM
Sep 26, 2024 07:32 AM
From 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:
Sep 26, 2024 08:08 AM
you're amazing thanks a bunch I've sorted it now!! 😊