Create SQL Insert Statement from a form input

[dav121412]

I have worked it out. Instead of trying to run the INSERT statement for all rows at the same time what needs to happen is you need to call the INSERT (query) from a JS Query and pass each row to the INSERT which will then run the SQL script.

This is because there is some SQL Injection protection enabled in Retool and you don't want to disable it. This means you cannot add variables columns and values to the SQL.

Here is a good explanation on how to trigger the query and pass the row to the INSERT Query

How to use additional scope (additionalScope) in your queries

Why use additionalScope When writing queries you'd like to reuse with different input value(s), Retool's additionalScope might be helpful! See our docs here and some more in depth examples below. How to use additionalScope The additionalScope option allows you to pass variables to the query that aren't already defined in the global scope (e.g. text1.value). In order to use additionalScope, you must first trigger a query in an event handler or using the .trigger() method in a JS query. [imag…