Use name but store ID in select field

[Kyler_Phillips]

I have a name and an ID column in my database, I want to store the id in the field but use the name in the select menu on my form, any ideas how?

[ScottR]

What does the select menu component look like?
In the label field use item.name and in the value field use item.id - provided your query is pulling the right info to supply the select menu

[MiguelOrtiz]

It does seem that the Retool Forms lack the option to assign label and value when selecting "Dynamic" data. It can be done when assigning Manual values.

[Kyler_Phillips]

How would you assign manual values?

[MiguelOrtiz]

In the "Data" section, select manual.

Then you can add your "name" values in lable and "id" in value.