Inserting into MSSQL-Plus Node through Dashboard Form Inputs

Dashboard
4
  1. Delete everything except the form node and SQL node & 2 debug nodes
  2. Connect the form to 1 debug and to SQL node
  3. Connect SQL output to 2nd debug
  4. Setup the SQL node to use parameters
  5. Enter test values into the form and submit (so you get form values in debug panel)
  6. Use the copy path from the debug msg to populate the parameters

There is no need for global context.

See this post for an example of how to do parameters

Copy path...

There’s a great page in the docs (Working with messages : Node-RED) that will explain how to use the debug panel to find the right path to any data item.

Pay particular attention to the part about the buttons that appear under your mouse pointer when you over hover a debug message property in the sidebar.

BX00Cy7yHi

1 Like