Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

How do I change the time zone on automation actions?

Solved
Jump to Solution
3026 9
cancel
Showing results for 
Search instead for 
Did you mean: 
JWalker
6 - Interface Innovator
6 - Interface Innovator

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.

2 Solutions

Accepted Solutions

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:

Screenshot 2024-09-26 at 10.31.34 PM.png

And here's both fields in an email:

Screenshot 2024-09-26 at 10.31.25 PM.png

See Solution in Thread

9 Replies 9

Hmm, are you referring to when the automation triggers?

Screenshot 2024-09-26 at 6.29.18 PM.png

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.

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

Thank you I'll try this now. Appreciate the help!

Neither 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?

 

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:

Screenshot 2024-09-26 at 10.31.34 PM.png

And here's both fields in an email:

Screenshot 2024-09-26 at 10.31.25 PM.png

you're amazing thanks a bunch I've sorted it now!! 😊