Limit user to edit parts of form

[marko4522]

Hi everyone,

Is there a way to limit an app user to not edit one particular enum column, in already created form from other app user.  I did this with 'Editable_If' expression, via usermail()

But in the other, how to let him to edit that  so when open new form.

[Trevwiller]

USEREMAIL() is the best way I have seen to allow only certain users to edit a column. If you are trying to remove the column other users form view you can either choose to edit the display functionality to only display to certain users. If you are trying to remove the enum from the form view it can be done by navigating to views, then system generated at the bottom, and select the view name you want to edit. in the view editor go to column order then remove it. Also using the ISBLANK() expression can help filter out changes to the enum.

[marko4522]

The idea is that admin can create form with Client column, and do not let the user to accidentaly change that particular form(work order).

But at the same time when user open new form, have a opportunity to choose client name

[Joseph_Seddik · Accepted solution]

OR(
  NOT( IN([_RowNumber], tableName[_RowNumber]) ),
  "adminEmail" = USEREMAIL()
)