![Patrick_Hughes Patrick_Hughes](https://community.airtable.com/legacyfs/online/avatars/2X/e/e905cf98bc9889d48138784edaeb27588d8d6d7c.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 17, 2024 05:09 PM - edited ‎Sep 17, 2024 06:31 PM
Hi all,
I've been running into an issue with an automation that I just can't seem to figure out; basically, I have one table which contains a date column (Reachout Tracking), along with a linked field to another table which contains contacts to whom I'm sending an email (Contact List).
I'm trying to set up an automation where when I update the Date Sent column, it automatically updates another date column called Date of Last Reachout in the linked table:
I know that something in the automation chain here is messed up, but here's the chain I have so far. It doesn't give me errors when testing but it also doesn't achieve the desired results:
Any tips for how to successfully link and have this column update automatically would be HUGELY appreciated.
Thanks!
Patrick
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 17, 2024 06:56 PM
Looks like your Update Record action might be setup wrong. Given that it's in a repeating group, you need to use the current item like so:
---
I think you could achieve the same result with a rollup field in Contact List with the formula `MAX(values)` to get the latest date though?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 17, 2024 06:56 PM
Looks like your Update Record action might be setup wrong. Given that it's in a repeating group, you need to use the current item like so:
---
I think you could achieve the same result with a rollup field in Contact List with the formula `MAX(values)` to get the latest date though?
![Patrick_Hughes Patrick_Hughes](https://community.airtable.com/legacyfs/online/avatars/2X/e/e905cf98bc9889d48138784edaeb27588d8d6d7c.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 17, 2024 10:06 PM
Thanks so much! That did the trick.
I need to keep the Date of Last Outreach field editable though, but thanks for the rollup suggestion as well.
![](/skins/images/FE00829FDD2AE889FAB731D8F02A8942/responsive_peak/images/icon_anonymous_message.png)