This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Convert Text String to Numerical Value in the same Field

Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator
Status: New Ideas
Converting a Single Select text string to a numerical value requires multiple fields and formulas. 
This idea proposes a way to automatically convert a Single Select text string into a numerical value within a single Field. An additional build on this concept would be to include a formula calculation option within the single select field options. 
See concepts below...

User selects Text (e.g., "Minor Issues") and Airtable sees a numerical Value (in example below, "3")


Airtable Value Conversion.png
Option B: Embed a Formula option within the field:

User selects text string  "Jan" and Airtable sees 01/01/2024. (I realize example below is not correct formula)

Airtable Value Conversion2.png


Currently this process requires 2-3 fields and formulas to convert a text string to a numerical value which clutter up the base very quickly. Also if the single select text string is long or if the choices change, creating and updating the formulas to convert to a value becomes extremely tedious. 


No validation done yet


Creators who are using text strings to make choices user friendly and they don't want to have multiple fields and formulas complicating the base. 


1 Comment
18 - Pluto
18 - Pluto

That would be cool. In the meantime, you can do this with linked records fields and lookup fields, but you would lose the nice colors.