Visibility conditions - AND/OR

[Nicolas_Maldonado]

Hi everyone,

I’m trying to set up visibility conditions but running into limitations with the AND/OR operators. Currently, the system only allows me to choose AND/OR once for all conditions, but I need to implement this specific logic:

(Property is ‘COD08-Carlos Lleras’ AND Role is ‘Investor’) OR (Role is ‘Admin’)

The current interface only lets me do:

• Property is ‘COD08-Carlos Lleras’ OR Role is ‘Investor’ OR Role is ‘Admin’ or
• Property is ‘COD08-Carlos Lleras’ AND Role is ‘Investor’ AND Role is ‘Admin’

Is there any way to create more complex conditional logic like nested AND/OR operations? Or perhaps a workaround to achieve this type of visibility control?

Thanks in advance for any help or suggestions!

[Jeff_Hager]

I recommend creating an IF column in the table like this, and then filter by that column.

IF Property is not 'COD08-Carlos Lleras' THEN false
ELSEIF Role is 'Investor' THEN true
ELSEIF Role is 'Admin' THEN true
ELSE false

Or do you mean something like this where property and admin aren’t associated?

IF Role is 'Admin' THEN true
ELSEIF Property is not 'COD08-Carlos Lleras' THEN false
ELSEIF Role is 'Investor' THEN true
ELSE false

[ThinhDinh]

Do you have any other roles than Investor and Admin?

I assume would also have more types of properties than COD08-Carlos Lleras?