Skip to main content
Topics#Data ManagementQuestion de Jo Anne Behling
Jo Anne Behling a posé une question dans #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 réponses
  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
    )
Rédiger une réponse...
0/9000