Solved: Only allow admin users to add data in a specific t... - Page 2

casitasrd · 09-27-2021 10:01 AM

Hello there,
Does anyone know how to only allow certain users to add data to a specific table?

I have a table call receipts and only want the user with the role Admin to create receipts for instance, but still want the user with role user to see the data.

Also, can the user with role user ask for permission to the user with role admin in order to add the receipt they just created to the table? sort of like an acceptance or decline option. If the admin user accept the data, data gets input, if not, it gets returned to the user to review the error.

casitasrd

Marc, I was able to create the review process using this as a starting point.

Created a data base of employee and managers. In the employee database, needed to specify who their manager is and then:

in the edit selection of the status I put this formula.
if(
and(
[status]= under review , [assign to].[manager].[email]=useremail()), true,

false

)

Thank you for all your help. Cheers!

View solution in original post

Only allow admin users to add data in a specific table