SQL Connector - filling a dropdown and other examples

While I’m able to connect to my Azure database, I am lost on trying to fill a dropdown field on a Bubble form for a user to them make a selection. Tried looking through other questions on the forum and still lost. I know, for me at least, it would be helpful to get more examples of using the connector to populate the different controls.

An example of what I am after. I want the user to fill in a timesheet that then gets written to the SQL database on Azure. The user needs to first select a client, which is a SELECT query in a query string called ‘test’. I can’t get the field set up. I am having issues trying to fill out the properties for the field on the form.

Try using a workflow action to “display list” on a repeating group, and use the sql query as the source.