User Tables and Custom Roles for Workflow Application

[Markus_Malessa]

I have come across some great discussions regarding the use of user tables such as this:

Current_User (Slice) - How to conform your app around WHO is using the app Tips & Tricks 💡

@MultiTech_Visions @tsuji_koichi I agree that I sometimes find inconsistencies in the behavior of Expressions. When this happens, I have to spend hours to narrow down the problem and then look for an alternative method to get the result I need. This is very frustrating. I think that the AppSheet Expression interpreter code needs refactoring.

At the same time I have come across discussions that mention the use of slices to narrow down data is a ‘bad’ idea because someone that is savvy can still get access to the whole data set.

My use case is an application that takes a batch of documents, they are created at the ‘Clerical’ role level, then they are passed to an ‘Assignment’ role level, then ‘Technician’ role, and finally ‘Finalization’ role where the batch is assigned a ‘Complete’ status.

I am still early enough in design that things can be changed around. However I was planning a column for Status which would set at which role level the batch is at the moment until ‘Completion’ as well as who it is assigned to in each of the processes.

Ultimately there will be a view that anyone can ‘read’ all rows for the batch table, then a view of your current assigned batches depending on role, status, and your email. I had planned on using slices and allowing certain actions within the slices like ‘add, update, delete, read’ to specific roles and status items along with specific user actions and workflows.

I was hoping someone might have example applications they could point me towards that are similar in nature to what I am trying to accomplish?
Also some clarification when to apply security filters to the table itself vs using slices to filter data and to allow ‘crud’ actions to slices/full table would be helpful?