You need to sign in to do that
Don't have an account?

PICKLIST with different VALUE than CAPTION
The custom field type "Picklist" saves its values as Strings. How can I save number values into the database, but having String captions for the picklist?
For example:
The picklist has the following captions:
"Worse"
"Bad"
"Good"
"Better"
When the user picks "Worse" I want the custom field to be saved as 1 into the database, when he picks "Bad" it should be saved as 2, and so on...
Your going to need another formula field in the back ground and asign a value to each option in the formula.. Something like...
if(pickval="Worse"),1
Thats not the whole code, but you get the point.
Thanks,
PB
All Answers
Your going to need another formula field in the back ground and asign a value to each option in the formula.. Something like...
if(pickval="Worse"),1
Thats not the whole code, but you get the point.
Thanks,
PB
This kind of solution works for so many cases... Just add another field!
Shame on me that I didn't hit on that idea myself.
Thank you very much!
Josh