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.
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.
Hmm, are you referring to when the automation triggers?
Or are you referring to how dates are displayed in emails perhaps?
Hmm, 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.
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
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!
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
Neither is working 😢
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:
And here's both fields in an email:
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:
you're amazing thanks a bunch I've sorted it now!! 😊
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.