As of now I filter data and views by straight away putting useremail() directly in the show_if or other contingent fields. Like show if useremail()=“email@example.com”
Which will be a problem when the users increase.
For that I have assigned each user a user role (there are four roles as of now, with prospects to diversify in the future), and I wish to filter data and views based on that role, rather than using useremail() directly.
Or do I have to bring up the ‘role’ value for each user for achieving that? If so, then I guess that I have to use dereferences after making a virtual column in every sheet that records the useremail and dereferencing that role corresponding to user-email in the employee page.
Am I on the right track, or far from it?