+ Start a Discussion
Nagaraju Mogili 22Nagaraju Mogili 22 

How can we create a validation rule on different fileds of same object

Ex: I have 5 subject to give the marks and I should not give more than 100 marks for any subject
Best Answer chosen by Nagaraju Mogili 22
SandhyaSandhya (Salesforce Developers) 
Hi,

You can write formula as 
OR (S1__c>100,S2__c>100,S3__c>100).

Please refer below link which has the solution for the same.

http://www.crmsalesforcetraining.com/create-validation-rules-salesforce/

If this helps you, please mark it as solved so that it will be availabe for others as a solution.

Best Regards,
Sandhya

 

All Answers

SandhyaSandhya (Salesforce Developers) 
Hi,

You can write formula as 
OR (S1__c>100,S2__c>100,S3__c>100).

Please refer below link which has the solution for the same.

http://www.crmsalesforcetraining.com/create-validation-rules-salesforce/

If this helps you, please mark it as solved so that it will be availabe for others as a solution.

Best Regards,
Sandhya

 
This was selected as the best answer
Vinod ChoudharyVinod Choudhary
Hi  Nagaraju,

Add a formula field (checkbox) and have all the common criteria code inside. Use this formula field and extend it as required for respective fields

Thanks
Vinod