Skip to main content
Topics#Data ManagementFrage von Nikki Hagen
Nikki Hagen (Columbia Machine, Inc.) fragte in #Data Management
5. März 2015, 22:50

Formulas for standard and custom objects

Afternoon.  I am going crazy and I hope one of you can save me.  Here is the scenario.  I am using the following objects.  Opportunity (standard), Quote (standard), Freight Quotes (Custom).  Relationships are as follows: Quote to Opportunity has a default master detail relationship and Freight Quotes to Quote is a lookup relationship.  I am trying to create a formula field that is as follows:  Quote.Account_Site__c

 

I get a syntax error: Field Quote does not exist.  Check spelling.  I have created many formula fields without any problems.

 

If anyone can help, it would be appreciated.  I seriously am going to lose my mind!  Thank you.  Please see attachment with screen shots.Formulas for standard and custom objects
4 Antworten
  1. Justin Brill (Salesforce)
    5. März 2015, 23:39
    If there is a lookup relationship to Quote on Freight Quote, it will be available in a formula on Freight Quote. 

     

    So maybe go to custom fields on Freight quote. Find the quote lookup and copy the API name of the field. Then all you do is replace '__c' with '__r' then append '.Account_Site__c'

     

    I'm guessing there's a misspelling or something in the API name...
Antwort schreiben...
0/9000