Choice displaying Name, but to populate Unique Identifier to target field

[Jeff_Hager]

Yes, I have a couple of app ideas that I’m waiting for something like this. It has been requested before. You can use a lookup column in the data tab or a vlookup in the sheet to get the UUID of the product name, but if you would ever change the product name, the lookup would stop working for older records. I think we need a feature like this. It’s fundamental to any dropdown on web and PC apps, so it makes sense that the choice component should work the same.

Choice Component - allow key display pairs

In the interest of some kind of data normalization and using key links in your tables/sheets it would be nice to display pretty text for the choice dropdown but save a key value to the database/sheet. This is more in line with how it is implemented in HTML which is what is ultimately driving things under the covers. This is the idea I’m talking about. The user would see the long text but the save would be the shorter. All that you would have to do is allow the user to optionally select a sec…