Tracking Emails Sent using automation in Airtable

[Wendy_Yelsik]

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? 

[TheTimeSavingCo · Accepted solution]

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]

Worked perfectly!  Thank you. 

[Emma_Salter]

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?

[TheTimeSavingCo]

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

Link to base

[Emma_Salter]

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

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:

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).

[TheTimeSavingCo]

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

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

[Emma_Salter]

I cant access your base 😕 

[Emma_Salter]

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!

[TheTimeSavingCo]

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