Matt, maybe you can help with this?
I want to allow clients to make ALL_CHANGES to their Work Orders while in “Pending” [Status]. I want them to be able to update the [Status] to “Working”, but then be restricted to READ_ONLY. Once we update the Work Orders[Status] to “Completed”, I want them to be able to do what they have to do and only be able to edit the Work Orders[Status] to “Archived”.
I also want to allow my staff to be able to update the Work Orders[Status] at every stage, in case a client wants us to handle all that. I want my staff to be able to update only columns specific to our tasks such as quantities and methods, but not any of the input from the client such as SKU’s, titles, Work Order Numbers, Purchase Order Numbers, … etc.
Right now, I have the following in the Editable_If expression for column Status:
This is pretty close, allowing only my staff to make changes to the status, but I would like to make it more complex as detailed above.