Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
venkatsforcevenkatsforce 

auto-populate based on value of status field

  1. Create a field called Account Size ( auto-populate based on value of status field)
    1. If status field value = ‘Ant’ then update Account Size =1.
    2. If status field value = ‘Squirrel’ then update Account Size =2.
    3.  If status field value = ‘Zebra’ then update Account Size =3.
    4. If status field value = ‘Elephant’ then update Account Size =4.
ReidCReidC

Is this a question?
venkatsforcevenkatsforce

Yes this is aquestion?ReidC
ReidCReidC

You could.

* create a formula field that inspects the value of the picklist and displays a value based on what it finds (similar to your record type question asked elsewhere)

* create a trigger that does this programmatically on insert or update

* do a field update via workflow

 

The right way depends on the context you are in and the business problem you are trying to solve.

 

What are you working on?  Is this a training assignment of some kind?  I ask because "squirrel" doesn't show up very often in picklists. :-)