Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Find record value = empty with Zapier

Solved
Jump to Solution
2337 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Alex_Langlois
4 - Data Explorer
4 - Data Explorer

Hello all! I have been losing my mind for 4 hours on this ‘simple’ task I am trying to implement in my base.

I want to automatically update several fields (example : set Phase to ‘Initiation’) when a new record is created.

I am able to update all required fields with Zapier.

My problem is I am unable to use the ‘Find record’ feature to update the last entry. It would be easy to fix if I was able to simply ‘Find record’ when ‘Field x is empty’ or ‘Find record’ when ‘Auto update for Zapier… = Created’… I don’t understand why I keep getting an error on Zapier… this field exists with only 1 entry set to ‘Created’… and this is the entry I want to update.Screen Shot 2020-04-28 at 1.23.38 PM

1 Solution

Accepted Solutions

Hey there - The issue is that you’re not passing in a record ID to the record field.

You need to know what record you are updating before you can update it.

Wherever you are getting that “Created” field, add a formula in Airtable

RECORD_ID()

Use that in your zap, and you should be fine.

See Solution in Thread

3 Replies 3

Hi @Alex_Langlois,

Why dont you make a new view in your table with a filter on this item then use a Zap on it?

BR,
Mo

Alex_Langlois
4 - Data Explorer
4 - Data Explorer

I did try it. Still not working… the Zap requires a field to id the record to be updated. That is exactly my problem. Screen Shot 2020-04-28 at 2.53.08 PM

Hey there - The issue is that you’re not passing in a record ID to the record field.

You need to know what record you are updating before you can update it.

Wherever you are getting that “Created” field, add a formula in Airtable

RECORD_ID()

Use that in your zap, and you should be fine.