function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
jmalcodrayjmalcodray 

Building Validation Rule

Hi, I'm building a simple validation rule and having trouble, here is my code:

 

AND(ISPICKVAL( Type , "On-site at Account"),
  ISNULL(On_Site_Visit__c))

 

The filed 'Type' is a pick list and i'm looking for that particular value.  when the pick list value matches, I want to make sure a check box, On_Site_Visit_c  was checked and if not, I dont' want to save this Task record and want to force the user to check that box (which will make him/her address a custom section on the Activity/Task record).

 

Seems simple but ISNULL appears not to be correct.  Was looking for ISCHECKED or something similar??

 

Any assistance is greatly appreciated.

 

Joe Alcodray.

Best Answer chosen by Admin (Salesforce Developers) 
Ankit AroraAnkit Arora

Let me know if it works for you ??

 

AND(ISPICKVAL( Type , "On-site at Account"),
   IF(On_Site_Visit__c, false, true) )

 

Thanks

Ankit Arora

 Blog | Facebook | Blog Page

All Answers

Ankit AroraAnkit Arora

Let me know if it works for you ??

 

AND(ISPICKVAL( Type , "On-site at Account"),
   IF(On_Site_Visit__c, false, true) )

 

Thanks

Ankit Arora

 Blog | Facebook | Blog Page

This was selected as the best answer
jmalcodrayjmalcodray

That worked beautifully Ankit, thanks so much for the assist.

 

Regards,

Joe Alcodray
Ankit AroraAnkit Arora

Glad that is worked for you.

 

 

Thanks

Ankit Arora

 Blog | Facebook | Blog Page