Help

Re: Tracking Emails Sent using automation in Airtable

Solved
Jump to Solution
186 1
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
18 - Pluto
18 - Pluto

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

9 Replies 9
TheTimeSavingCo
18 - Pluto
18 - Pluto

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. 

Hi,

 

I am looking for the same sort of solution, but this doesn't seem to be working for me. Has something changed in this space since 2022 when you posted this suggestion?

Emma_Salter_0-1730259774251.png

 

Nope, nothing's changed.  Try setting up your automation like this:

Screenshot 2024-10-30 at 5.52.53 PM.png

Link to base

Man I feel so stupid - it still doesnt work, but a different error this time.

Emma_Salter_0-1730336985730.png

When I look up Could not convert string to date help I just appear to get more confused. I thought it might have been because I have set date format to European, so I changed that and it still throws an error:

Emma_Salter_1-1730338220595.png

Where it says Record ID in the Input for testing, is there a reason is shows random letters/numbers as opposed to the name of the record? The email is getting sent as it should be (testing one comes to me).

 

 

Hmm I think your formula field isn't set up right; it should look like this: 

Screenshot 2024-10-31 at 3.04.40 PM.png

Try duplicating the base I linked above and checking what the differences are between the automation I set up and yours!

I cant access your base 😕 

Emma_Salter_0-1730358436254.png

 

Ah! I fixed my formula! I had totally copied your suggestion and used the quotation marks when I copied it so it was just displaying the text! and that why the formula wasnt throwing an error either! Oh man - what a week I am having!

Glad you got it sorted!  Ah sorry about that, not sure what happened with that link.  Have updated it!