Help

Tracking Emails Sent using automation in Airtable

Solved
Jump to Solution
856 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Wendy_Yelsik
6 - Interface Innovator
6 - Interface Innovator

I send emails using Airtables automation.   You can see when an email is sent from inside the automation setup.  Is there a way to put a field in a table that lists the last date an email was sent to easily see email history? 

1 Solution

Accepted Solutions
TheTimeSavingCo
16 - Uranus
16 - Uranus

Hi Wendy, I'm assuming you have a table where each record represents an email, and your automation triggers off of a new record being created in this table?

If so, perhaps you could try the following:

1. Add a new formula field called "Now" with the formula "NOW()`
2. Add a new Date field called "Last date email sent"
3. In the automation that sends the email, add another step to update the triggering record, specifically to place the value of the "Now" field into the "Last date email sent" field

See Solution in Thread

2 Replies 2
TheTimeSavingCo
16 - Uranus
16 - Uranus

Hi Wendy, I'm assuming you have a table where each record represents an email, and your automation triggers off of a new record being created in this table?

If so, perhaps you could try the following:

1. Add a new formula field called "Now" with the formula "NOW()`
2. Add a new Date field called "Last date email sent"
3. In the automation that sends the email, add another step to update the triggering record, specifically to place the value of the "Now" field into the "Last date email sent" field

Wendy_Yelsik
6 - Interface Innovator
6 - Interface Innovator

Worked perfectly!  Thank you.