Does anyone have thoughts on how to use the ‘Show if’ feature in UX Views.
Background. I have an app with a range of views and I am thinking that instead of creating mulitple single-serve apps with custom slices and security filters for the different userbases, I could instead use this show if feature in the UX view I want to limit .
The description states ‘Optional Yes/No formula to decide whether this view should be shown’
What I want do to is write a formula that states if USEREMAIL() is in a column (eg Manager Email Column) then show the view.
Other users USEREMAIL() are in Staff table/Email Column, so would not be in the Manager column, so would not be displayed as a view which is the correct outcome.
Does anyone have a Yes/No formula that complies with this View Show If
feature that go towards accomplishing this? I have watched many of the appsheet tutorial videos but have not seen any that refer to this feature.
I guess some sort of lookup of ManagerEmail = USEREMAIL() but then how to turn it into a Yes/No? As you can see, I’m flailing about on this one.
Any tips would be appreciated.