Use the formula field for Picklist values (Based on Selected Picklist Value, populate Primary Address) #inSalesforce

on

Use the formula field for Picklist values (Based on Selected Picklist Value, populate Primary Address) #inSalesforce


Setup | Object Manager | Accounts | Fields & Relationships | New | Select Data Type as Formula | Click Next |

1. 

Formula field 


FullBillingAddress

Formula: BillingStreet & " , " & BillingCity & " , " & BillingState & " , Zip Code " & BillingPostalCode & " , " & BillingCountry


2.

Formula field:


FullShippingAddress

Formula: ShippingStreet & " , " & ShippingCity & " , " & ShippingState & " , Zip Code " & ShippingPostalCode & " , " & ShippingCountry


3.

Create Picklist field:

Name it may be Select The Address

Billing Address

Shipping Address


4.

Formula field:

Primary Address

Formula: CASE(SelectTheAddress__c,"Billing Address", FullBillingAddress__c,"Shipping Address", FullShippingAddress__c,"")


Visual: https://www.youtube.com/watch?v=ZwXgHxS_7jQ

Comments

Post a Comment