+ Start a Discussion
Anji P 9Anji P 9 

I want to apply validation rule on if loantype is educatioon then apllication fee more than 500 how to do it any one help me

Best Answer chosen by Anji P 9
Amol ChAmol Ch
Hi Anjl,

I'm assuming loantype is a Picklist datatype field and apllication fee is Currency field.

So your Validation formula will be like this :
 
AND( ISPICKVAL( loantype__c, 'Education'), OR( ISBLANK(application_fee__C), application_fee__C < 500))

For more help you can referteh below article:

https://developer.salesforce.com/docs/atlas.en-us.usefulValidationRules.meta/usefulValidationRules/fields_useful_field_validation_formulas.htm

https://resources.docs.salesforce.com/204/latest/en-us/sfdc/pdf/salesforce_useful_validation_formulas.pdf


https://trailhead.salesforce.com/en/modules/point_click_business_logic/units/validation_rules

Let me know if it works for you.

 

All Answers

Amol ChAmol Ch
Hi Anjl,

I'm assuming loantype is a Picklist datatype field and apllication fee is Currency field.

So your Validation formula will be like this :
 
AND( ISPICKVAL( loantype__c, 'Education'), OR( ISBLANK(application_fee__C), application_fee__C < 500))

For more help you can referteh below article:

https://developer.salesforce.com/docs/atlas.en-us.usefulValidationRules.meta/usefulValidationRules/fields_useful_field_validation_formulas.htm

https://resources.docs.salesforce.com/204/latest/en-us/sfdc/pdf/salesforce_useful_validation_formulas.pdf


https://trailhead.salesforce.com/en/modules/point_click_business_logic/units/validation_rules

Let me know if it works for you.

 
This was selected as the best answer
Suraj TripathiSuraj Tripathi
Hi Anji,
You can try like this for your validation.
IF( ISPICKVAL( loantype__c , 'Education') , application_fee__c < 500 , application_fee__c )

Mark as a best if it helps you.
Regards,
Suraj
Arpit Jain7Arpit Jain7
HI,

I think your validation rule will look like below

AND( ISPICKVAL( loantype__c, 'Education'), application_fee__C < 500)

You can further update it as per requirement.

Thanks
Arpit
Anji P 9Anji P 9
thanks Arplt jain Its working fine