Solved: How to prevent user to change status back to old v... - Page 2

kalmen_chia · 05-17-2021 03:30 AM

Hi, I have a column “Order Status” which is ENUM [Pending,Started,Finished,Cancelled], and
I wish to block the user to save record
when user
change from Pending to Finished, or
change from Started Back to Pending, or
change from Finished to Cancelled or
change from Cancelled to Finished or
change from Cancelled to Started or
change from Cancelled to Pending

Can any one help to advice me please, thanks.

kalmen_chia

Hi Aurelien,

thanks for the advice and idea,

what works for me is as follow,
SWITCH([Order Status],
“Pending”, LIST(“Finished”),
“Started Back”, LIST(“Pending”),
"Finished ", LIST("Cancelled "),
LIST(“Finished”,“Started”,“Pending”)
)
when is cancelled, they can’t switch it back and
when is finished, they can’t switch it back.

solved.

View solution in original post

How to prevent user to change status back to old value?