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
- Navigate to Customization > Lists, Records, & Fields > Entity Fields > New
- Label: (Example: Ship Address)
- Type: Text Area
- Store Value: Remove Checkmark
- Under Applies To tab > Customer: Enter Checkmark
- Under Display tab
- Subtab: Main
- Display Type: Disabled
- Display Size: 40 x 3
- Under Validation & Defaulting
- Formula: Enter Checkmark
- 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