Starting November 20, the site will be set to read-only.
On December 4, 2023,
Apex Code Development (90768)
General Development (55146)
Visualforce Development (37251)
Lightning (18265)
APIs and Integration (17146)
Trailhead (11680)
Formulas & Validation Rules Discussion (11337)
Other Salesforce Applications (8116)
Jobs Board (6655)
Force.com Sites & Site.com (4842)
Mobile (2694)
You need to sign in to do that
Don't have an account?
kminev Hi,
I need to apply a validation rule on my pick list where I need to check if the value on this particular picklist changed (ISCHANGED) then I need to see what was the prior value???
Is there a way I can get the original value of the picklist before it changed?
Thank you.
I have a similar situation where my requirement is that I don't want to prevent someone from changing a value, unless it's prior value was something and the new value they are changing it to is something else.
If you have similar requirement, you can use something like this:
In my example, I have a Case.Status field which has many possible values, one of them is "Completed" and one of them is "Begin Billing". And I will only allow specific users (i.e. those with a specific Profile) to be able to change Case Status from Completed to Begin Billing. So validation rule needs to check if prior Case Status=Completed and new Case Status=Begin Billing:
AND
(
$User.ProfileId <> 'xxxxxxxx',
ISCHANGED( Status ),
ISPICKVAL(PRIORVALUE( Status ), "Completed"),
ISPICKVAL( Status, "Begin Billing")
)
All Answers
I have a similar situation where my requirement is that I don't want to prevent someone from changing a value, unless it's prior value was something and the new value they are changing it to is something else.
If you have similar requirement, you can use something like this:
In my example, I have a Case.Status field which has many possible values, one of them is "Completed" and one of them is "Begin Billing". And I will only allow specific users (i.e. those with a specific Profile) to be able to change Case Status from Completed to Begin Billing. So validation rule needs to check if prior Case Status=Completed and new Case Status=Begin Billing:
AND
(
$User.ProfileId <> 'xxxxxxxx',
ISCHANGED( Status ),
ISPICKVAL(PRIORVALUE( Status ), "Completed"),
ISPICKVAL( Status, "Begin Billing")
)