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?
Which one do you mean. Adding is possible when creating a new record OR user can edit if the field is blank?
Basically i do not want certain user to go in a change information after it has been added.
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.
So… do you want this to happen in row level? Customer can add a record but can’t modify it?
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.
Brilliant Thank you
1 Like