Solved: Allow driver to add new items in inline form but p... - Page 2

aminsaleh · 09-22-2023 02:30 PM

Hi all, I hope everything is going good

I have a form for tasks and inside it there is an inline form for adding new items. (see below image plz)

we will assign tasks to drivers, but I want to prevent a driver from updating any previous items in the above items inline form. a driver can only add new items but not editing old entries.

Is there any clue plz

Thanks

AleksiAlkio

So.. as per your responses, the user should be able to edit his/her own items. But you also said.. "a driver can only add new items but not editing old entries.". I assume with this you mean other driver's items. If the Admin should be able to edit everyones Items, then you would need to add that condition to Edit action. Don't know your table structure, but lets assume you have "Users" table with roles. Then the formula would be..
OR(
USEREMAIL()=[EmailColumn],
LOOKUP(USEREMAIL(),users,ID,Role)="Admin"
)

If you don't have an "Users" table, then you could write it like..
IN(USEREMAIL(),LIST([EmailColumn])+LIST("adminA@domain.com","adminB@domain.com"))

View solution in original post

Allow driver to add new items in inline form but prevent edit other sellers' entry