Dec 06, 2022 08:21 PM
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?
Solved! Go to Solution.
Dec 07, 2022 03:11 AM
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
Dec 07, 2022 03:11 AM
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
Dec 07, 2022 08:51 AM
Worked perfectly! Thank you.
Oct 29, 2024 08:43 PM
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?
Oct 30, 2024 02:53 AM - edited Oct 31, 2024 07:35 PM
Nope, nothing's changed. Try setting up your automation like this:
Oct 30, 2024 06:48 PM
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).
Oct 31, 2024 12:05 AM
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!
Oct 31, 2024 12:07 AM
I cant access your base 😕
Oct 31, 2024 01:04 AM
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!
Oct 31, 2024 07:35 PM
Glad you got it sorted! Ah sorry about that, not sure what happened with that link. Have updated it!