Display the Default Shipping Address of Customer in the Record’s Main Page

Scenario

Display the default Shipping Address under the Address tab of a Customer Record on the main area of the record using a custom field.

Solution
  1. Navigate to Customization Lists, Records, & Fields Entity Fields New
  2. Label: (Example: Ship Address)
  3. TypeText Area
  4. Store Value: Remove Checkmark
  5. Under Applies To tab > CustomerEnter Checkmark
  6. Under Display tab
  7. Subtab: Main
  8. Display Type: Disabled
  9. Display Size: 40 x 3
  10. Under Validation & Defaulting
  11. Formula: Enter Checkmark
  12. Default Value:

{shipaddressee} || ‘

‘ || NVL2 ({‌shipaddr1}, {‌shipaddr1} || ‘

‘, ”)

||

NVL2 ({‌shipaddr2}, {‌shipaddr2} || ‘

‘, ”)

||

NVL2 ({‌shipcity}, {‌shipcity} || ‘ ‘, ”) ||

NVL2 ({‌shipstate}, {‌shipstate} || ‘ ‘,”) || {‌shipzip} || {‌shipcountry}

Instead of {shipaddressee} we can also use the company name

Leave a comment

Your email address will not be published. Required fields are marked *