I want to create a custom picklist field that would represent a packaging type which would in turn represent a divider for the shipment's total quantity. For example, if the dropdown had the following options:
- 100lb Drum
- 30lb Container
And the total quantity being shipped was 300lbs. Then depending which option was selected from the dropdown I would either be shipping 3 (300/100) or 10 (300/30) units based on the given unit type.
I want the number of units to be a formula field that does this simple equation, but I don't believe I can do that if the picklist is a text field, so I want the picklist value to just be the Integer
(either 100 or 30), but the label to be a string that is easy for the user to understand.
My research of this so far says it is not possible so I need to either confirm that and figure out another option, or figure out how it is possible. Thanks in advance for any help.