I think that several kind of applications need to distinguish what a user can do based on different criteria...
I also think that a lot (maybe all) those criteria can be well modelled using a user-profile/role/autorisation system.
So, I believe that it can help a lot to have something like this inside AppSheet.
It can be easier to apply the security filters, to modify the "Edit allow" fields and simplify the logic for this.
Why this? Thanks @Marc_Dillon I forgot to explain the purpose
In this way, it can be possible to immagine to have a set of expression to retrieve easily the the profiles, roles and authroisatoin.
It is like we have today with USERROLE() but more dynamic
And, I think with this, we can save time configuring, adding, managing etc this part inside the tables..
Here below an examlpe of the structure that I have in mind:
- User
|- Profile 1
|-Role 1
|-Autorisation 1
|-Autorisation 2
|-Role 2
|-Autorisation 3
|-Autorisation 4
|- Profile 2
|-Role 3
............................