Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Find record value = empty with Zapier

Solved
Jump to Solution
812 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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.