How do you check priority in validation rule in Salesforce?

How do you check priority in validation rule in Salesforce?

1 Answer

1. create a checkbox formula field in your child object Parent_Object_Protected_State__c that references the value you want to check ( ISPICKVAL(Lookup_Field__r.State__c,’NY’) )
2. Use the validation Rule AND(ISCHANGED(Lookup_Field__c), PRIORVALUE(Parent_Object_Protected_State__c))

What is Priorvalue?

The PRIORVALUE function gets the previous value of a field that is the same value if the record is being created, or the real previous value if the record is being updated.

How to use priorvalue in Validation rule Salesforce?

I want to use PRIORVALUE (Owner.FirstName <> “TBD”) but i get this error “Incorrect argument type for function ‘PRIORVALUE ()’.” Any help is appreciated. PRIORVALUE takes a field and results in what the fields prior value was, which should then be compared to your value. Error: The PRIORVALUE function cannot reference the Owner.FirstName field.

When do you need to enter a date in a Validation rule?

Your rule now requires users to enter dates on or after January 1, 2010. If you enter a date earlier than 2010 and then try to place the focus on another field, Access prevents you from leaving the current field until you fix the problem.

Which is an example of a Field Validation rule?

Field validation rules Use a field validation rule to check the value that you enter in a field when you leave the field. For example, suppose you have a Date field, and you enter >=#01/01/2010# in the Validation Rule property of that field. Your rule now requires users to enter dates on or after January 1, 2010.

How to restrict data input using validation rules?

Field properties Some field properties restrict data input. For example, the Field Size property of a field restricts input by limiting the amount of data. You can also use the Validation Rule property to require specific values, and the Validation Text property to alert your users to any mistakes.