Hi,
I want to change the status of a record once the picklist value Loan_Amount_Individual__c(Picklist) is changed and the value is increased from privious value. Loan_Amount_Individual__c(Picklist) has values like 5000, 10000,15000, 20000, 25000... if i change the loan amount from 10000 to 15000 then it should check if it is exceeding sanctioned amount (Sanction_Amount__c) if yes then update the status of my record to 'Pending'.
I wrote a work flow but its not working:
AND( ISPICKVAL(Application_Status__c, 'Good') ,
RecordType.Name = 'Review/Reject',
ISPICKVAL(Application_Category__c, 'Test') ,
VALUE ( TEXT(Loan_Amount_Individual__c ))> Sanction_Amount__c
)
error message while saving :
Error: Incorrect parameter type for TEXT. Expected Number, Date, DateTime, received Picklist
In field update i am changing the status to pending.
5 个回答
You can use something like this. AND((ISPICKVAL(Application_Status__c, 'Good')),
RecordType.Name = 'Review/Reject',ISPICKVAL(Application_Category__c, 'Test'),(ISPICKVAL(Loan_Amount_Individual__c)>Sanction_Amount__c))
