Skip to main content

Update record automation issue

  • February 9, 2025
  • 2 replies
  • 10 views
A
Forum|alt.badge.img+5
  • alfa12
  • New Participant
  • 4 replies

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!

2 replies

A
Forum|alt.badge.img+5
  • alfa12
  • Author
  • New Participant
  • 4 replies
  • February 9, 2025

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 😉

TheTimeSavingCo
Forum|alt.badge.img+31
  • TheTimeSavingCo
  • Brainy
  • 6454 replies
  • February 10, 2025

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?

 

Adam, Airtable Consultant - thetimesaving.company


Terms & ConditionsAccessibility statement