Pass data throught a button to SQL Table

[Steve-Mcl]

Here is a solution (one of many on the forum)

It uses a form so that all dashboard inputs arrive at the SQL node at the same time.

Dashboard and MS SQL database - number and text input nodes

Hi Naz. Firstly, one thing to realise is that messages NEVER arrive at the same time. So where you have user_id, first_name and last_name linked to a done button - this is never going to work. Secondly, you risk sql injection by concatinating strings to generate SQL Queries. To simplify user input and to avoid SQL Injection, use the ui_form - it has sends all values entered in one msg. Also, use node-red-contrib-mssql-plus as it allows you to use parameters (that negate SQL injection) Exampl…

If you are using separate UI elements, then you will need to either use a JOIN node (to make a single object with all the user values in) OR use flow/global context to store the users input.