Custom Edit Permissions in the form After form submission

[Mangesh_Mundhe]

Requirement is : User is allowed to submit the form first , once the user submits the form then that user should not be able to edit some of the fields from that form he is submitted earlier but he can edit other fields . But some Users with special
privilege should be able to edit the fields which are not to be edited by the user after the form submission . These people with special privilege are kept in different groups and they should be able to edit particular fields as per the group… so if say people from the Admin group can edit X and Y columns from the form after submission… then neither the normal user nor the people with special privilage from the other group than Admin group should be edit the X and Y column fields…
But when anyone who uses the app is adding record using the Form they should be able to add all the fields restrictions should be applied on at the time of editing…
Please help me to get this done

[Suvrutt_Gurjar]

You will need to use a combination of Editable_if column constraints based on user emails and identify if the row being added is new or it already exists so that you can stop certain fields being edited by certain users after the form is saved.

To know if the row is being newly added or exists, please use the tip share by @Steve

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

Is this a new row?/Does this row already exist? Is this a new row? NOT(IN([_ROWNUMBER], My Table[_ROWNUMBER])) or: ISBLANK( FILTER( "My Table", ([_ROWNUMBER] = [_THISROW].[_ROWNUMBER]) ) ) Does this row already exist? IN([_ROWNUMBER], My Table[_ROWNUMBER]) or: ISNOTBLANK( FILTER( "My Table", ([_ROWNUMBER] = [_THISROW].[_ROWNUMBER]) ) ) In the above, replace My Table with the name of the table about which you’re inquiring. When modifying rows, such as in forms or wi…

help.appsheet.com

Editable_If Column Constraint

Conditionally allow the user to edit a column value.

[Mangesh_Mundhe]

@ Suvrutt_Gurjar Thank you so much for sharing this…This was really helpful