Sign Up ›

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

Changing default picklist values

Hello,

 

I want to specify different default picklist values on a field called "Market" on a custom object according to the value of a field called "billing market" on the related account. The custom object is the detail of a master detail relationship with account.

 

Does anyone know if this is something you can do with a trigger?

 

Is there any way to make the default picklist value vary according to another parameter?

 

Regards 

SteveBowerSteveBower

If you define different Record Types for an object, each record type can have different Picklist values for a given field.   So, you could define two record types for the custom object, one with one default for "Market", and the other with a different default.  Then your trigger on the related Account could change the record type of the custom object record.  (Note that it won't change the value that's already stored in that record.)   You should also see if a workflow rule will accomplish the change instead of a trigger.

 

Best, Steve.

KirstyFranceKirstyFrance

Hi Steve,


Thanks for the suggestion. Unfortunately I would have to have  over  20 record types for the different markets, so it might not be  manageable.

 

I've tried playing around with workflow rule, but as you don't have the option to use formulas when it comes to updating a picklist field, it is not flexible enough.

 

Regards

Kirsty 
JasonGablerJasonGabler

I'm not using record types, and I'm having the same issue.  Any ideas?

 

thanks,

jason