function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

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!


Best Answer chosen by Admin (Salesforce Developers) 



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.