- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 10, 2024 05:24 AM
I 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
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 10, 2024 05:50 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 10, 2024 07:47 AM
Sounds like you haven't refreshed the data for your automation testing. Try testing your trigger again
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 10, 2024 05:40 AM - edited Sep 10, 2024 06:23 AM
Hey @user2100!
Please find the solution to your issue in this related discussion (courtesy of @ScottWorld 😁).
I hope that helps!
Mike, Consultant @ Automatic Nation
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 10, 2024 05:50 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 10, 2024 06:14 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 10, 2024 06:23 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 10, 2024 07:47 AM
Sounds like you haven't refreshed the data for your automation testing. Try testing your trigger again
