Drop-down lists for Forms or Play SQL Spreadsheets

Hi all,

Once again I am sorry for the delay. I'm trying to implement this issue, and my mistake has been to group this one with too many other improvements. I expect to publish an update soon. On the upside, foreign keys and relationships with other tables will be included in this update when it gets published.

Sorry again for the delay,
Best regards,
Adrien

Dear Play SQL Team,

My company would like that quality issues get entered into a database and track through this database.
Now I wanted to do relationships between 2 tables and have a drop down of products name and categories.

I found this open ticket and this would be great to have a drop down from a different tabel.

Thanks in advance

This would be a huge win if this feature can be implemented. When you have multiple users entering in free text, you are bound to have someone misspell input. When running a query based on the value in that field, it's more than likely the results aren't going to be entirely accurate.

My company is currently evaluating this product and I'm fairly certain they would purchase if this functionality was implemented.

It would be nice if select-list values could be loaded from a database table too.

E.g. I could save a "Departments" SQL query ( select id,name from department ), and then in the form, specify that the "Department" form field is of type "Select List", with values taken from the "Departments" saved query.

Or better yet, make it composable. Have the 'Field' take a body, where each line represents an item in the select list. So for a static list we could just have:

and for a dynamic SQL-generated list we could have:

All the "Play SQL Field" macro has to do is render its body. By separating the UI out in this way, users are free to invent their own interfaces for rendering the field.