summary: how to fill a record in a SQL database using an input form?
When I simplify my case, I have a SQL table, with 2 columns. Column 1 contains ID’s. Column 2 is empty.
In the Bubble app, the user gets directed to an URL with their ID from column 1 in it. For example: www.app.com/ID=12345
On this URL/page is an input field: “score”. The users fills this and presses the Send button. The column 2 from the SQL table gets filled with the score. Of course in the row with the corresponding ID.
My problem is that I don’t know how to do the Update-query in the Bubble SQL Database plugin, and the accompanying workflow action.
I tried numerous things to no avail. I just know I have to work with variables in the query, but how? Also, how do I use the parameters in the plugin?
I did read SQL Database Connector | Bubble Docs
but it only gives me hard values for a query.