- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 08, 2025 06:22 PM
I'm having trouble getting past the Update record in an automation:
I was able to:
- get the trigger to catch a new email in a table (pic #1)
- filter out the matching email and corresponding row (pic #2)
In the Update action, I used the Airtable record ID from the first step (pic #3). The field of interest I want to import from the donor table, for example, is What year and school did you graduate from (pic #4) but it doesn't work (pic #5) and I also dont see where in the receiving table I can choose where the donor information I want to collect to insert.
Thanks so much!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 08, 2025 06:50 PM
So right after posting this, I saw @ScottWorld 's reply to my other post and tried to fix the above within Make using Watch Records > Search Records > Upsert a Record and I go it to work! So exciting! But still curious why I couldn't get it to work within Airtable. Any and all advice would be greatly appreciated 😉
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 09, 2025 06:30 PM
Hmm, that error message seems to indicate a field you were trying to update has been deleted. When trying to insert data into a field, we also need to use the field values, not the 'Insert as list' bit:
Here's how the automation should look:
And here's it working:
And I've set it up for you here
---
Not sure what you're trying to do, but perhaps a lookup field that shows only their latest survey submission might work too?
 
