Forum Discussion
show RLS Role name Currently being viewed on each sheet
I am using static row level security. I would like the ability create a card that shows the name of the role currently being viewed on the dashboard. My RLS is based on the Manager column below. It e...
Hi Anonymous , sorry to know it didn't work for you. Please try below:
ActiveRole =
VAR CurrentRole = USERNAME()
RETURN
SWITCH(
CurrentRole,
"John", "John",
"Jim", "Jim",
"Bill", "Bill",
"No Role Assigned"
)If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
thank you Akash_Varuna can you help me with the logic