Wednesday, 18 January 2012

Formatting Shipping address of account using formula field


//Pulling the shipping address of account on the case with formula field and formatting the address as shipping address of account


IF(ISBLANK(Account.ShippingStreet),'',Account.ShippingStreet&BR())&
IF(ISBLANk(Account.ShippingCity),'',IF(AND(ISBLANK(Account.ShippingState),ISBLANK(Account.ShippingPostalCode),ISBLANK(Account.ShippingCountry)),Account.ShippingCity,Account.ShippingCity&","))&
IF(ISBLANK(Account.ShippingState),'',Account.ShippingState&" ")&
IF(ISBLANK(Account.ShippingPostalCode),'',Account.ShippingPostalCode&BR())&
IF(ISBLANK(Account.ShippingCountry),'',IF(ISBLANK(Account.ShippingPostalCode),BR()&Account.ShippingCountry,Account.ShippingCountry))

No comments:

Post a Comment