Got a bit of strange behaviour.
I’m trying to get it so that
Any(Select(Users[Type],[Users]=UserEmail()))=”Employee”
can only add items to a sub-table, whereas
Any(Select(Users[Type],[Users]=UserEmail()))=”Management”
can add, edit and delete to the same table.
So to do this I have one table with 2 List Views, which both Ref the subtable.
The first points to the entire table, the second points to a slice.
This works fine.
I then thought I could use a
Show_If in the List/Ref of the main table to control which sub-table view you get to see.
The issue is that Appsheet seems to be totally ignoring the Show_If.
Whatever is in the Show_If, it always displays both.
I’ve even tried TRUE and FALSE.
Yet if I tick to hide them, it always hides them.
I’ve used this same technique before without issue.
Can anyone help or suggest a better way?
LinkedIn
Twitter
