Skip to main content
Solved

Find record value = empty with Zapier

  • April 28, 2020
  • 3 replies
  • 63 views
A

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.

Best answer by andywingrave

I did try it. Still not working… the Zap requires a field to id the record to be updated. That is exactly my problem.


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.

    3 replies

    Mohamed_Swella1
    Forum|alt.badge.img+17
    • Mohamed_Swella1
    • Inspiring
    • 1030 replies
    • April 28, 2020

    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

    A
    • Alex_Langlois
    • Author
    • New Participant
    • 2 replies
    • April 28, 2020

    I did try it. Still not working… the Zap requires a field to id the record to be updated. That is exactly my problem.

    A
    Forum|alt.badge.img+19
    • andywingrave
    • Inspiring
    • 323 replies
    • Answer
    • April 28, 2020

    I did try it. Still not working… the Zap requires a field to id the record to be updated. That is exactly my problem.


    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.


    Terms & ConditionsAccessibility statement