My first question, I need your help.
I succeeded to connect MySQL with Bubble.
I’d like to use dropdown when I edit user’s profile, but I can’t set up the choices source and the default value with one query.
In the choices source, I’d like to show all options, and in the default value, I’d like to take one option.
This query is here.
I tried to write “manager_id” in the parameter like this, because it could get all options.
But it couldn’t.
When I wrote “where manager_id = manager_id” in the query, I got all options in the dropdown.
If anyone know how to use dropdown using SQL Database Connector, please tell me.