Field validation on sales stage ID
Hi All,
I had one requirement from the client side that the user should not change the sales stage of any opportunity if has been approved. Currently I had tried the column formulae with the condition PRE('<SalesStage>')<>[<SalesStage>] AND [<YOUR_Approval_Status_Field>]="Your_approval_Value" AND [<YOUR_Approval_Status_Field>] IS NOT NULL and an error message was made on the field but it did not work.
May be the initial condition is causing issue i.e. PRE('<SalesStage>')<>[<SalesStage>].
Can you please let me know is there any condition we can use?
Regards
I had one requirement from the client side that the user should not change the sales stage of any opportunity if has been approved. Currently I had tried the column formulae with the condition PRE('<SalesStage>')<>[<SalesStage>] AND [<YOUR_Approval_Status_Field>]="Your_approval_Value" AND [<YOUR_Approval_Status_Field>] IS NOT NULL and an error message was made on the field but it did not work.
May be the initial condition is causing issue i.e. PRE('<SalesStage>')<>[<SalesStage>].
Can you please let me know is there any condition we can use?
Regards
0