Add OR as a filter condition | Voters

Stacker

Create

Roadmap

Feature Requests

237

Add OR as a filter condition

Dot McCleskey

I would like to be able to filter using OR as an option (in addition to AND). I've figured a bit of a work-around using AND is IS NOT, but OR would make things simpler and ensure data integrity as additional values may be added over time, requiring updating maintenance.

April 22, 2020

Activity Feed

Sort by

David Hodgson

This really needs to be implemented - it seems like it should be simple to implement, and there is obviously a lot of need for it, given the upvote count...

Sam Dickie

marked this post as

open

Vt Phong

is there any update on this? It's been several months. The role & permission function is so useless without this

Vt Phong

And this function is still not implemented yet? It's so important.

Armen Nercesian

This is quickly becoming a must-have!!!

Peter Juten

Merged in a post:

Include "OR" within conditional visibility

Sam Stone

Currently, if making multiple conditions...they can only be linked with "AND". I would like to submit a couple scenarios which are not reliant on each other.

July 17, 2020

October 19, 2021

Peter Juten

marked this post as

under review

Adrien Jorge

This is required for conditional visibility that involve the user. Example: I want to display "Personal details" tab only to either the owner of the profile or the admin, no one else. This can't be achieved without OR.

Jeff Miller

Adrien Jorge: I second this. The only way to make something like this work is to create duplicates of the same data and have different visibility features for each. Very frustrating and isn't always possible to implement.

Trixie

Hi Sam - I am hoping for this one too but in the meantime I achieve this by created specific formulas in Airtable that distil all the "or" scenarios into one result. How about you?? have you found a different way to do this?

Milan Muiderman

Trixie: Hi, I don't think this trick works in a 'create new' field as the formula cannot be updated in realtime, or have you found a way to bypass this?

Trixie

Milan Muiderman: I think so, yes - could you give me an example of a scenario that applies to you?

David Campbell

Absolutely. Would sharpen the conditional filtering 100%! +1 here.

→