I went to use the Form aspect of Retool for the first time today, not your average forms insides apps but the Retool Forms feature.
Within 2 minutes I discovered that if you use a Select component and you want to use a dynamic one based on data in your Database, essentially you can't.
The component only allows you to select one column from the table
This is at odds with the App way of adding Select components and even at odds with the Manual Select component which allows a different value from the text being displayed.
In this example, I wanted to allow the user to select the site that they were interested in, I obviously can't show the user the id of the field so I have to select site_name. If my site_name is not unique across all Sites, this renders the component somewhat useless as I would have no way of knowing which site the user had selected.
Please can we have both a value column and a text column, in my opinion, this would dramatically increase the effectiveness of Forms as a whole.
