You need to sign in to do that
Don't have an account?
Rakesh Kumar 335
Workflow/Validation rule Help
"Customer State" is a field on lead object. The picklist values are CA, NJ,DC, AZ,IL, etc
The requirement is, if CA is selected, 'zipcode' field on lead should have a value '94544'. Similarly if 'NJ' is selected 07102 an so on.
How do i do this? workflow or formula or any easier way?
The requirement is, if CA is selected, 'zipcode' field on lead should have a value '94544'. Similarly if 'NJ' is selected 07102 an so on.
How do i do this? workflow or formula or any easier way?
Try this formula field
Note: pls select text type in formula field
All Answers
you need to go through below link
https://developer.salesforce.com/docs/atlas.en-us.fundamentals.meta/fundamentals/adg_simple_app_adv_field_dependencies_try_it_out.htm
Thanks
D Naveen Rahul.
Try this formula field
Note: pls select text type in formula field
i get the error "Error: Field Customer_State__c may not be used in this type of formula"
Based on customer state value selected in customer state field, the value to be populated in postal code field.
ex: if i select 'CA' in customer state picklist, the postal code value should be '94544'
first go to create new custom fields
then select formula field, and then inside formula select text type
Step1: select formula
step2 :inside formula field select text type
IF(ISPICKVAL(Customer_State__c, 'CA'), '94544', IF( ISPICKVAL(Customer_State__c, 'NJ'), '94521', IF( ISPICKVAL(Customer_State__c, 'DC'), '73622', IF( ISPICKVAL(Customer_State__c, 'AZ'), '26366', IF( ISPICKVAL(Customer_State__c, 'IL'), '36455', '') ) ) ) )