Filter table based on Company, Role

[RVR]

Hi!

I’ve got a Users Table, with Name, Email, Role and Company

I’ve got a Ticket Table, with all ticket information, Email, Role and Company

I would like to make sure that everyone from Company A, can see all open tickets. Everyone from Company B, can only see their own tickets, unless their role is Admin. Then they can see everything from Company B.

[RVR]

Solved!

I actually managed with an IF-THEN-ELSE column

In my Ticket table “Add Column” and select “IF-THEN-ELSE”.

• IF User’s Company is “Company A” → Then output "Show"
• IF User’s Company **is the same as the Order’s Company** → **Then output** “Show”`
• ELSE → "Hide"

Then a filter on my List:
IF Computed Column (IF-THEN-ELSE) is “Show”