Skip to main content
Topics#Data ManagementFrage von Jo Anne Behling
Jo Anne Behling fragte in #Data Management
18. Mai 2015, 19:53

Account address displayed on a custom object

I created the following formula.  The user will look up the customer and the address will default on the custom object.  The display shows the city, state, zip code and country.  However, the billing street will not dispaly on my object.  What am I missing? 

 

Contact__r.Account.BillingStreet + BR() +

 

  Contact__r.Account.BillingCity + "," +  Contact__r.Account.BillingState + "  "  +  Contact__r.Account.BillingPostalCode + BR() +  Contact__r.Account.BillingCountry

 

Account address displayed on a custom object

 

Thank you.

 

Jo Anne
2 Antworten
  1. Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
    18. Mai 2015, 20:05

    See if this works - 

    IF(
        NOT(ISBLANK(Contact__r.Account.BillingStreet)), 
        Contact__r.Account.BillingStreet + BR(), 
        NULL
    ) +
    IF(
        NOT(ISBLANK(Contact__r.Account.BillingCity)), 
        Contact__r.Account.BillingCity + ", ", 
        NULL
    ) + 
    IF(
        NOT(ISBLANK(Contact__r.Account.BillingState)), 
        Contact__r.Account.BillingState + "  ", 
        NULL
    ) + 
    IF(
        NOT(ISBLANK(Contact__r.Account.BillingPostalCode)), 
        Contact__r.Account.BillingPostalCode + BR(), 
        NULL
    ) + 
    IF(
        NOT(ISBLANK(Contact__r.Account.BillingCountry)), 
        Contact__r.Account.BillingCountry + BR(), 
        NULL
    )
Antwort schreiben...
0/9000