You need to sign in to do that
Don't have an account?
bathy
Opportunity Stage update
Hi All,
I have created a validation rule to ensure the users update notes(custom text area field) every time they change the opportunity stage.
And( ISCHANGED( StageName ) , Not(ISCHANGED( Notes2__c ) )) this is the formula.This works fine. But my Salesforce users want to update the notes with minimum 20 characters which I tried using another validation rule with the formual AND(ISCHANGED( StageName ), if(len( Notes2__c )<(len(Priorvalue(Notes2__c))+20),true,false)) but it is not working as expected.
system is going into loop and asking the user to update the notes even though they entered more than 20 characters.
Please advise any other way of achieving this.
thanks in advance
I have created a validation rule to ensure the users update notes(custom text area field) every time they change the opportunity stage.
And( ISCHANGED( StageName ) , Not(ISCHANGED( Notes2__c ) )) this is the formula.This works fine. But my Salesforce users want to update the notes with minimum 20 characters which I tried using another validation rule with the formual AND(ISCHANGED( StageName ), if(len( Notes2__c )<(len(Priorvalue(Notes2__c))+20),true,false)) but it is not working as expected.
system is going into loop and asking the user to update the notes even though they entered more than 20 characters.
Please advise any other way of achieving this.
thanks in advance
//Above formula will check length of the notes with previous notes length + 20 character
//Above formula will check length of the notes with 20 character
you can use any of the formula as per your requirement.
If this solves your problem, kindly mark it as the best answer.
Thanks,
Vatsal
All Answers
//Above formula will check length of the notes with previous notes length + 20 character
//Above formula will check length of the notes with 20 character
you can use any of the formula as per your requirement.
If this solves your problem, kindly mark it as the best answer.
Thanks,
Vatsal