Lock Row if it has certain value

[abood89]

Hi

I have a table with a column as status 

what im trying to achieve is  to prevent any edit to a row when it has the value of finish in statues column but i still need to be able o edit only one column in the same row after i marked it as finish 

i know i can do that by going into each column and set a formula condition but that would be so not easy job since i have 42 column 

[TeeSee1 · Accepted solution]

I was thinking of an alternative approach

Create two form views. One to allow all fields to be edited, the other only the single field.

Disable the system default Edit action.

Create an action with LINKTOROW like this.

LINKTOROW([_THISROW],
 IF([_THISROW].[status]="finished", "form_finished", "form_open")
)

This works but I like @WillowMobileSys's solution better for its simplicity. 

[WillowMobileSys]

What I would recommend is to set criteria in the Edit action.  Allowing row editing only if [Statues] <> "Finished".

To still allow editing of the single column,  set it as a QuickEdit column in the Detail view.

[abood89 · Accepted solution]

That seems could get the job done 

[TeeSee1 · Accepted solution]

I was thinking of an alternative approach

Create two form views. One to allow all fields to be edited, the other only the single field.

Disable the system default Edit action.

Create an action with LINKTOROW like this.

LINKTOROW([_THISROW],
 IF([_THISROW].[status]="finished", "form_finished", "form_open")
)

This works but I like @WillowMobileSys's solution better for its simplicity. 

[abood89]

Thanks for the effort