Perplexing Workflow Issue
I have set up a workflow that should update the Service Request Status field when certain values in another field are chosen. It is set to triger when the reocrd is modified.
IIf(FieldValue('<plUser_Status_ITAG>') = 'Resolved', 'Closed', IIf(FieldValue('<plUser_Status_ITAG>') = 'Admin', 'Pending', 'Open'))
I have another that is set to trigger when the New Record is Saved which is written exactly the same way.
The users should always be choosing Admin when the SR is opened.
My problem is that the new record workflow doesn't work so instead of having the Status changed to Pending, it shows as Open. Then if I change to another value in the other field the Status remains as Open, which is fine. If I change the value back to Admin, then the Status changes to Pending. And if I change the value to Resolved, the Status stays at Pending or Open depending on what the previous value was.
IIf(FieldValue('<plUser_Status_ITAG>') = 'Resolved', 'Closed', IIf(FieldValue('<plUser_Status_ITAG>') = 'Admin', 'Pending', 'Open'))
I have another that is set to trigger when the New Record is Saved which is written exactly the same way.
The users should always be choosing Admin when the SR is opened.
My problem is that the new record workflow doesn't work so instead of having the Status changed to Pending, it shows as Open. Then if I change to another value in the other field the Status remains as Open, which is fine. If I change the value back to Admin, then the Status changes to Pending. And if I change the value to Resolved, the Status stays at Pending or Open depending on what the previous value was.
0