+10I have an automation that sends an automatic email. There are 2 date fields in the text. This should display the date and time. unfortunately the date fields are displayed as in the attachment. how can I change this?
It would look nicer if everything was like the last one. could be removed
Best answer by TheTimeSavingCo
Try creating a formula field and using DATETIME_FORMAT() to format them the way you want to see in your email, and then use them in your email automation
Here's a link to all the modifiers: https://support.airtable.com/hc/en-us/articles/216141218
+28Hey @user2100!
Please find the solution to your issue in this related discussion (courtesy of @ScottWorld 😁).
I hope that helps!
Mike, Consultant @ Automatic Nation
+31Try creating a formula field and using DATETIME_FORMAT() to format them the way you want to see in your email, and then use them in your email automation
Here's a link to all the modifiers: https://support.airtable.com/hc/en-us/articles/216141218
+10Try creating a formula field and using DATETIME_FORMAT() to format them the way you want to see in your email, and then use them in your email automation
Here's a link to all the modifiers: https://support.airtable.com/hc/en-us/articles/216141218
I have created a formula field and the date and time are displayed in it. But if I use this formula field in an email text, the space remains empty.
The date formatting is correct in the table, but the formatting is displayed differently in the email text.
+28+31I have created a formula field and the date and time are displayed in it. But if I use this formula field in an email text, the space remains empty.
The date formatting is correct in the table, but the formatting is displayed differently in the email text.
Sounds like you haven't refreshed the data for your automation testing. Try testing your trigger again
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.