Hi. Kinda new to Airtable so I hope my question is not dumb.
What I need to do is to make a serial number generator of a kind. The serial number consists of 3 two-digit elements each element indicates a variable. So what I need is a document, where there are 3 dropdowns: Drop down1, Dropdown 2, Dropdown 3. In those dropdowns, there are 5 text values: Text 1-1 to Text 1-5 in the first drop-down, Text 2-1 to Text 2-5 in second and so on. There must be a numeric value assigned to each text value that the user does not see, so, for example, Text 1-1 is equal to 11, Text 1-2 is 12, Text 2-4 is 24 and so on.
Whenever a user chooses a value from the drop-down the numeric value appears on a cell marked as a complete serial number. If all dropdowns are left blank then it says 000000, if on dropdowns Text Value 1-3, Text Value 2-1 and Text Value 3-3 are selected, than the cell marked Serial number says 132133 and so on. All 6 numbers appear in one cell next to each other.
Does anyone have an idea of how to create something like this in Airtable?