Add feature to create pre-defined option sets with name value pairs for use with single select and multi-select option fields

Phillip Ushijima

Problem Statement:

At times, there may be a need to display a list of options to a user that are presented differently than the underlying value that is stored. Sometimes, this is a rating scale like Low, Medium, High that might have numeric values that are stored as 1, 2, 3. Other times, it may be a list of states or provinces that are presented as the full name but stored as an abbreviation. Option sets may also be desired to use across multiple fields.

Proposed Solution:

Add a feature to allow defining option sets that can be used to create name value pairs of differing data types. Allow single and multi-select option fields to use a defined option set. Allow admins building forms and reports that display these to choose which value should be shown - the underlying stored value or the display value. Allow conditional formatting and calculations based on the stored value of the option set used for a field. e.g. Allow averaging the underlying numeric score of a Low, Medium, High option set field.

Ashley Fischer

This would be great! We are currently implementing a company wide request process where we want the requestor to select from a list where the list options are descriptive, but only store the numerical values so that we can run formulas and such on them.