help with Airtable "find record" step when nothing found

  • 27 March 2024
  • 3 replies

i’m really sorry if this is an obvious answer, because i think i may be missing something basic. thanks in advance for the help!

i have a Zap that takes donations given to our nonprofit on my online platform (Givebutter) to my database in Airtable. Givebutter allows for individuals to become “team members” and help raise money for our annual event. when a donation is given on Givebutter and credited to a “team member,” the transaction will come through with a number in the “member ID” field.

i’m asking the Zap to check to see who that “member ID” belongs to in Airtable, so that they can be properly credited on that donation (the crediting is done in a linked record field from the donation to that person in the database).

however, if it’s the first time that someone has given to that team member, we won’t know their ID yet, we have to fill it in by hand (i have put in a feature request to Givebutter to be able to zap the team member’s name & email, but that’s not available yet).

so i want the Zap to search for the team member, and if one doesn’t exist, create the donation record anyway with the team member ID in the notes field for that donation. that way, we can look on givebutter & see who the team member is, add them to the donation, then add their ID in the right place, and any subsequent donations to them will be correctly credited.

i have set the “find record” step to “Yes” consider it a success if nothing is found, but i didn’t add a “create a record if it doesn’t exist” because there’s currently no other way to search for the team members in the transaction data. i just want it to try to find the person and if it can’t, move on to the next step. i thought “Yes” was all i needed, but the zap is stopping with the following error:

in this case, the test record did not have a team member so the “search value” was empty.

any ideas? thanks!!!

3 replies

Userlevel 7
Badge +14

Hi @AI_hello 

Help us have more context by posting screenshots with how your Zap steps is configured.

i ended up doing a workaround for this zap, and my other zaps are behaving the way i expect, so i think i’m good & don’t need any more help. thanks so much for replying!

Userlevel 7
Badge +11

Hi @AI_hello! 👋

Thanks for the update here. Would you be open to sharing some details of the workaround you used to get past that error? It could be a great help to others who may be running into the same issue. 

Looking forward to hearing from you! 🙂