Not Editable if field is SAVED with specific value

AppSheet AppSheet Q&A
,
1

I have a Status field with 3 values:

  1. Pending
  2. In Process
  3. Completed

2X_c_cd015d57f1ea2cd007bbaafe3bcd8345c93d73cd.jpeg
2X_c_cd015d57f1ea2cd007bbaafe3bcd8345c93d73cd.jpeg1080×2340 115 KB

The field is editable, but once the record has been SAVED with Status = “Completed” the status field can NOT be editable any more.

The issue I am having for now is that if when editing the Status field I select (no saving yet) “Completed” than I can Not edit it again:

2X_9_9db07cb9ba4df7b165318182a0051c7c59f3801a.jpeg
2X_9_9db07cb9ba4df7b165318182a0051c7c59f3801a.jpeg1080×2340 133 KB

2

I understand from where your headache is coming from. Alternative workaround.

There are few possible workaround, but this is a workaround it came up with in my mind.
First you creat physical field, called LockOrUnlock and default value is set to “Unlock” through initial setting. And always hide this field from any view.

Create action set this field value to “Lock”.

Create workflow to fire this action only on the condition of

and(
[_thisrow_before].[Status]<> [_thisrow_after].[Status],
[_thisrow_after].[Status]=“Complete”
)

For status field, set up editif condition, only it is editable when LockOrUnlock field value is “Unlock”

2 Likes
3

Another workaround… NOT(LOOKUP([_THISROW].[ID],“TableName”,“ID”,“Status”)=“Completed”) in Editable? option will do that job because you haven’t saved that value yet.

7 Likes
4

I just tried that and it worked Perfectly! Thanks a lot, @Aleksi

also thank you @tsuji_koichi for always taking time to help the community!

1 Like
5

You’re welcome