# Inserting into MSSQL-Plus Node through Dashboard Form Inputs

**URL:** https://discourse.nodered.org/t/inserting-into-mssql-plus-node-through-dashboard-form-inputs/72095
**Category:** Dashboard
**Created:** [12 December 2022 19:40 UTC](https://discourse.nodered.org/t/inserting-into-mssql-plus-node-through-dashboard-form-inputs/72095 "2022-12-12T19:40:40Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [12 December 2022 22:48 UTC](https://discourse.nodered.org/t/inserting-into-mssql-plus-node-through-dashboard-form-inputs/72095/4 "2022-12-12T22:48:09Z")

</div>

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](https://discourse.nodered.org/t/query-via-modbus-tcp-mssql-zero-values/71785/9) for an example of how to do parameters

* * *

Copy path...

There’s a great page in the docs ([Working with messages : Node-RED](https://nodered.org/docs/user-guide/messages)) 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](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/d/bd1f333a9e043b061b39917c328b0094d3e52d30.gif)

---

_[View the full topic](https://discourse.nodered.org/t/inserting-into-mssql-plus-node-through-dashboard-form-inputs/72095)._