You need to sign in to do that
Don't have an account?
SFDCneophyte
Cross object formulas... Again
Hello All,
I'm trying to populate a TEXT field on a custom object. The goal is to check for an Account Name on the Lead Object or on the Contact Object. Based on my formula below I'm getting a eror. Any help would be greatly appreciated.
Thanks,
IF
(OR(Lead__r.Account__r.Name),
(OR(Contact__r.Account.Name)),
null)
Error: Incorrect parameter for function 'OR()'. Expected Boolean, received Text
So you created a custom object called Account? Leads are not related to Accounts natively.
The key question is can a Lead AND a Contact be related to the custom object at the same time? If so, then which one wins if they are both are populated, since your field can only accept one or the other.
For example, this will populate the Contact Account Name if they are both populated.
All Answers
Leads do not have Account Names, is your custom object related to both Leads and Contacts? And only one or the other can be related to the object at the same time?
My custom object is related to both the lead object as well as the contact object. Essentially an Account Record can have both leads and contacts. So our leads and contacts can be linked to an account.
So you created a custom object called Account? Leads are not related to Accounts natively.
The key question is can a Lead AND a Contact be related to the custom object at the same time? If so, then which one wins if they are both are populated, since your field can only accept one or the other.
For example, this will populate the Contact Account Name if they are both populated.
OK, I created a custom object called "Prospects" this custom object was created to specifically track the progess of leads as they move through our system .So a prospect can be a "Lead" or a "Contact" So if I create a new prospect record and that person is a lead or a contact I would want the system to identify the name entered and then return the Account associated with this individual, be it Lead or Contact.... Possible?
:)
Sorry I edited my last reply while you were replying. See the formula above.
Thank you once again! I hope you don't mind if I add you as a friend... Thanks, - Keith
Glad to help. Happy to be a friend... unless youre a psycopath lol