+ Start a Discussion
ivalum21ivalum21 

Can I update one field given the value of another field?

I know a pick-list can drive the values of another pick-list, but can the value of a pick-list drive the value of a text box?

 

For example, I want to add brackets around a Contact's last name if his Active status (a pick-list with Yes or No values) is set to No.  If it is set to Yes, nothing changes.

 

Is this possible?

 

Thanks for any help you can provide!

ivalum21 

Best Answer chosen by Admin (Salesforce Developers) 
iCloudiusiCloudius

Yes.

 

You should probably check out the Field Updates section under "Create --> Workflows and Approvals".  You can then write a simple formula to specify how this field should populated. (try "["+LastName+"]") 

 

Then you need to write a workflow rule that determines when this update is run.  This should be easy, too - just select the object (Contact) and specify when the rule should be run.  Save and activate the workflow rule.

 

 

This should get you close to what you're trying to achieve.