Skip to main content
Question

Table Filter "or" ?

  • September 12, 2024
  • 2 replies
  • 17 views

Hi everyone!

I was trying to create a filter w/ my zapier table to hide entries w/ specific statuses. The challenge I have is that when the entry is first inputted it doesn’t have a status. :( This means if I try to “hide” the others - it won’t let me see those w/o a status.

Is there an “Or” option that I’m not aware of and/or is there is a way to have the status preset when it’s added to the table.

Looking for the “3rd” option to be “blank” … or the option to add “OR” and then this

 

 

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

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • September 12, 2024

Hi @lilithreborn79 

Help link for filtering records in Zapier Tables: https://help.zapier.com/hc/en-us/articles/19695584120461-Filter-records-on-Zapier-Tables

 

If you add multiple filters, the table will display only records that match all the filters, as it uses AND logic. 

 

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • September 12, 2024

@lilithreborn79 

A possible workaround…

Configure a View for just the blanks

Use that View to trigger a Zap (when a new record is in the View)

Use the Zap to update the record to field to another value.

 

Use your other View to include the other field option.