Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Using Formula to Fix Time in Automated Email

Topic Labels: Automations
562 2
Showing results for 
Search instead for 
Did you mean: 

I have an automated email going out to notify people what day/time the Round of edits are due. The date and time look fine in my record but the email says “Please complete your edits by 2021-04-09T09:52:00.000Z”. This is not easily readable.

I’ve learned about adding a formula to the table that corrects this but it’s specific to only one field. DATETIME_FORMAT({RD1 Comments Due}, ‘M/DD/YYYY \at h:mma’). That works in the body of the email when I select this formula record to get RD1 Comments Due.

Now I want to have an automated email for RD2 Comments Due. Do I have to make a 2nd Time Formula for that field?

2 Replies 2

Yes. Date field formatting in the Airtable UI is only for the UI. When displaying that date anywhere else, it will need to be formatted using a formula field. For example, if you have five date fields that you want to share outside of Airtable, there will need to be five formula fields.

I was afraid of that! I guess it’s worth the extra work.