Question

How to search on a field that may be empty in zapier

  • 14 February 2022
  • 2 replies
  • 24 views

Trying to sync up a postgres record to airtable on create/update. The field has a couple of ids that I would like to check for in airtable to determine whether I should create a new record or update an existing one. The first id (optional_id) I need to search on can possibly be null. This causes the search to fail before it can get to the other id(required_id) that should always be populated. Is there any way I can skip the initial search for optional_id if it turns out to be null in postgres?

My current outline is as follows:

 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

Hi @mensirfrasum34 

Try using the Search Formula option in Airtable Find Record: https://support.airtable.com/hc/en-us/articles/218151657

 

Airtable Find Record also has this setting.

 

Userlevel 7
Badge +14

@mensirfrasum34 

For PostgreSQL, try Find Row via Custom Query