I'm sorry that I find it difficult to follow your train of thought. I think I understand what you want, but you ask the system the have knowledge of a a variable group of users in different circumstances without defining them.
With bots it's quite easy if you create a Google workspace email group to be on the receiving end. To hide/show columns I can't think of another way than using specific email adresses as the user does not log on as a group.
Without having informational through a table that a user is part of an admin group, I don't understand how AppSheet could ever know this.
LinkedIn
Twitter
