Certain users can add but can not update

[Dan_Lawrie]

Hi is it possible to add a edit if constraint so that only certain users can update data in a column, but everyone can add new data to said column?

[Aleksi]

Which one do you mean. Adding is possible when creating a new record OR user can edit if the field is blank?

[Dan_Lawrie]

Basically i do not want certain user to go in a change information after it has been added.

[Dan_Lawrie]

for example.

USER 1 works for me, he can go into the order and change the products on an order as well as add other products.

But User 2 is the customer so when loading his order I want him to be able to select the products required, but not change once he has submitted.

[Steve]

You can use an access expression for the table to choose which users have the ability to add, update, and/or delete rows for the table. From your description, you’d want customers to have add access but not update or delete access; but staff would have full access.

[Dan_Lawrie]

Brilliant Thank you

[Aleksi]

So… do you want this to happen in row level? Customer can add a record but can’t modify it?