I’m trying to speed up some Apps by refactoring various formulas. One I’m using everywhere is this one which gets the logged in users security level:
Based on advice from @MultiTech_Visions I’ve created a slice called Current_User with a formula of
This wil create a single row slice. But now I’m stuck on the optimum way to reference it. Which of these is fastest?
IN("Customer",Current_User[Type]) or ANY(Select(Current_User[Type],TRUE))="Customer"
Obviously can’t use
Since Appsheet will assume Current_User[Type] is a list even though we know it isn’t
Which is best or can someone suggest something else?