function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Rajesh SriramuluRajesh Sriramulu 

Compare picklist values

Hi,

 

I have Rank field as picklist and having picklist values as:

 

A1-poor
A2- Below Low
A3-Low
A4-Average
A5-Above Average
A6-below high
A7-High

 

 

and having date fields like

 

date_A1

date_A2

date_A3

date_A4

date_A5

date_A6

date_A7

 

 

I need to check if old value is lower and updated  value is higher means, then  between the other values needs to update today date as higher value date.

 

for eg:   Rank has changed from "A2- Below Low" to "A6-below high" then "date_A6"high is updated by today date and also between

 

them 3 fields also need update by today date i.e "date_A3,date_A4,date_A5".

 

It may change the rank from any way. There are 20 picklist values are there.So we can't check every value.

 


Can any one know how to do this requirement.

 

 

Thanks in Advance.

Rajesh.