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
aiyaz_SFDCaiyaz_SFDC 

Validate whether a lookup field is empty

Is  there a sure set way to verify whether a lookup field is empty? 

 

Thanks for any help.

Dan_LichtmanDan_Lichtman
Hi,
You can use the LEN function to validate if a lookup filed is empty or not:
For example, you cannot save an account if the parent account field is empty:
Error Condition Formula : Len(ParentId ) = 0
aiyaz_SFDCaiyaz_SFDC

Thanks for the reply.  I've actually used other functions with no luck whatsover, but I cannot recall whether i've used LEN, although i did try quite a few.  Once i test it out i'll let you know how it goes.

 

Thanks for the idea.
aiyaz_SFDCaiyaz_SFDC

Thanks for the help.  I think my problem before was the logic i was using.  I think I was performing too many validation checks in one validation rule.   Instead of keeping it simple.