# Pass data throught a button to SQL Table

**URL:** <https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649>\
**Category:** General\
**Created:** [10 March 2022 10:30 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649 "2022-03-10T10:30:21Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![QGIO](https://avatars.discourse-cdn.com/v4/letter/q/f17d59/32.png) [@QGIO](https://discourse.nodered.org/u/QGIO)\
**Post date:** [10 March 2022 10:30 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/1 "2022-03-10T10:30:21Z")

</div>

Hello!  
I have created a UI like this:  
\</\>

 ![immagine](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/7/27feca4140a26181d7eb4c491c3619d40be88add.png)

When I press the button 'CARICA' I would insert the inserted data to an SQL table (already created).  
Which flow can I use? How can I pass inserted data to the SQL table (I have the flow for the connection to the SQL database.

Many thanks

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [10 March 2022 10:47 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/2 "2022-03-10T10:47:04Z")

</div>

How is this different from your prior thread [RequestError: Incorrect syntax near '.'](https://discourse.nodered.org/t/requesterror-incorrect-syntax-near/59605)

---

<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:** [10 March 2022 10:53 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/3 "2022-03-10T10:53:51Z")

</div>

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](https://discourse.nodered.org/t/dashboard-and-ms-sql-database-number-and-text-input-nodes/55696/2):
>
> 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](https://www.imperva.com/learn/application-security/sql-injection-sqli/#:~:text=SQL%20injection%2C%20also%20known%20as,lists%20or%20private%20customer%20details.) 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.

---

<div class="post-metadata">

**Author:** ![QGIO](https://avatars.discourse-cdn.com/v4/letter/q/f17d59/32.png) [@QGIO](https://discourse.nodered.org/u/QGIO)\
**Post date:** [10 March 2022 11:53 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/4 "2022-03-10T11:53:28Z")

</div>

Thank you Steve, this can help me!  
I installed the suggest node of MSSQL plus, but I don't see the same format (I continue to see the format for the SQL standard node)

\</\>

 ![immagine](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/d/7d0f739acc6c81d8414b574cd715f47746a002c7.png)

Another question: for the Form node, do you know if it is possible to include dropdown menu for some field?

---

<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:** [10 March 2022 11:54 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/5 "2022-03-10T11:54:41Z")

</div>

You need to remove the 5y old MSSQL node & restart node-red

---

<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:** [10 March 2022 12:31 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/6 "2022-03-10T12:31:09Z")

</div>

> [@QGIO](#):
>
> Another question: for the Form node, do you know if it is possible to include dropdown menu for some field?

No, the UI form doesnt have a drop down.

In your case you probably need to use individual components & store the values in rediness for when the button is pressed. Did you see the following post?

> If you dont want to use the `ui_form` then you need to store the individual values entered and recover them when the done button is pressed e.g....
> 
> ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/d/6dd235efd1bd76b22921da7b8bc8e3730d5ba226.png)

---

<div class="post-metadata">

**Author:** ![QGIO](https://avatars.discourse-cdn.com/v4/letter/q/f17d59/32.png) [@QGIO](https://discourse.nodered.org/u/QGIO)\
**Post date:** [10 March 2022 12:50 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/7 "2022-03-10T12:50:37Z")

</div>

yes, I see but but I don't see the information inside the node Store and Get.  
Do you have suggestion also for JOIN node?

---

<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:** [10 March 2022 12:56 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/8 "2022-03-10T12:56:36Z")

</div>

> [@QGIO](#):
>
> yes, I see but but I don't see the information inside the node Store and Get

They are just change nodes. Very basic. I think maybe you are new to node-red? I'll post a couple of canned replies below that will help...

* * *

See [this article in the cookbook](https://cookbook.nodered.org/basic/join-streams) for an example of how to join messages into one object.

* * *

I recommend watching this playlist: [Node-RED Essentials](https://www.youtube.com/playlist?list=PLyNBB9VCLmo1hyO-4fIZ08gqFcXBkHy-6). The videos are done by the developers of node-red. They're nice & short and to the point. You will understand a whole lot more in about 1 hour. A small investment for a lot of gain.

---

<div class="post-metadata">

**Author:** ![QGIO](https://avatars.discourse-cdn.com/v4/letter/q/f17d59/32.png) [@QGIO](https://discourse.nodered.org/u/QGIO)\
**Post date:** [10 March 2022 13:02 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/9 "2022-03-10T13:02:10Z")

</div>

is it correct to use for uninstall the old  
\</\>  
npm uninstall -g node-red-contrib-mssql

and than install this new

\</\>  
npm install node-red-contrib-mssql-plus`

---

<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:** [10 March 2022 13:03 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/10 "2022-03-10T13:03:55Z")

</div>

Depends where you installed it in the first place.

Typically, it is installed in your node-red folder (not global)

CD into your `.node-red` folder then run `npm uninstall node-red-contrib-mssql`

---

<div class="post-metadata">

**Author:** ![QGIO](https://avatars.discourse-cdn.com/v4/letter/q/f17d59/32.png) [@QGIO](https://discourse.nodered.org/u/QGIO)\
**Post date:** [11 March 2022 09:10 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/12 "2022-03-11T09:10:03Z")

</div>

In this case, what I have to send to the button ?  
\</\>

 ![immagine](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/c/cc911e778433737bbd50eae9b987b0161634ece7.png)

I have three separate variables (as in the flow reported in the example)

---

<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:** [11 March 2022 09:13 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/13 "2022-03-11T09:13:13Z")

</div>

> [@QGIO](#):
>
> In this case, what I have to send to the button

Depends how you saved them in context.

can you share a minimal flow (the parts of interest only)?

---

<div class="post-metadata">

**Author:** ![QGIO](https://avatars.discourse-cdn.com/v4/letter/q/f17d59/32.png) [@QGIO](https://discourse.nodered.org/u/QGIO)\
**Post date:** [11 March 2022 09:18 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/14 "2022-03-11T09:18:01Z")

</div>

![immagine](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/7/07313faa1cb328c57f9f439eec8aa6e8c8aa0a2c.png)

---

<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:** [11 March 2022 09:19 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/15 "2022-03-11T09:19:18Z")

</div>

I cant look inside the nodes if you only share a picture.

Select the nodes of interest, press CTRL+E and copy the flow.

Paste copied flow in a reply (use the `</>` code button)

---

<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:** [11 March 2022 09:25 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/17 "2022-03-11T09:25:49Z")

</div>

firstly, you have only posted 1 node - I need you to select all nodes you showed in that screenshot.  
secondly, you did not paste the flow in the right place & it is corrupted by forum formatting.

`````  
` PASTE FLOW CODE INSIDE BACKTICKS`  
`````

---

<div class="post-metadata">

**Author:** ![QGIO](https://avatars.discourse-cdn.com/v4/letter/q/f17d59/32.png) [@QGIO](https://discourse.nodered.org/u/QGIO)\
**Post date:** [11 March 2022 09:31 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/19 "2022-03-11T09:31:52Z")

</div>

```auto
[{"id":"bce72d0f261b67cb","type":"ui_button","z":"e0129591b64c21bc","name":"","group":"2733e4a59af46689","order":4,"width":0,"height":0,"passthru":false,"label":"Carica","tooltip":"","color":"","bgcolor":"","className":"","icon":"","payload":"","payloadType":"str","topic":"topic","topicType":"msg","x":90,"y":380,"wires":[["bf23e13acd4755f5"]]},{"id":"bf23e13acd4755f5","type":"change","z":"e0129591b64c21bc","name":"","rules":[{"t":"set","p":"payload1","pt":"msg","to":"UserInputTip","tot":"flow"},{"t":"set","p":"payload2","pt":"msg","to":"TextInput","tot":"flow"},{"t":"set","p":"payload3","pt":"msg","to":"UserInputCl","tot":"flow"}],"action":"","property":"","from":"","to":"","reg":false,"x":240,"y":380,"wires":[["25e5761ffbe89611","1db479193c8afbc3"]]},{"id":"46b4474ec3fa7473","type":"ui_dropdown","z":"e0129591b64c21bc","name":"TIPOLOGIA","label":"TIPOLOGIA","tooltip":"","place":"Select option","group":"2733e4a59af46689","order":1,"width":"9","height":"1","passthru":true,"multiple":false,"options":[{"label":"Attrezzatura","value":"Attrezzatura","type":"str"},{"label":"Strumentazione","value":"Strumentazione","type":"str"}],"payload":"","topic":"payload","topicType":"msg","className":"","x":110,"y":160,"wires":[["59ca0d5e6c329d86"]]},{"id":"a6b5e5dadea9aa3b","type":"change","z":"e0129591b64c21bc","name":"","rules":[{"t":"set","p":"TextInput","pt":"flow","to":"payload2","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":310,"y":220,"wires":[["ad9197c903577eba"]]},{"id":"fcfa9bd412d25121","type":"ui_text_input","z":"e0129591b64c21bc","name":"","label":"","tooltip":"","group":"2733e4a59af46689","order":2,"width":0,"height":0,"passthru":true,"mode":"text","delay":300,"topic":"TextInput","sendOnBlur":true,"className":"","topicType":"flow","x":100,"y":220,"wires":[["a6b5e5dadea9aa3b"]]},{"id":"bffd5199f28bef9f","type":"ui_dropdown","z":"e0129591b64c21bc","name":"CLASSIFICAZIONE","label":"CLASSIFICAZIONE","tooltip":"","place":"Select option","group":"2733e4a59af46689","order":3,"width":"9","height":"1","passthru":true,"multiple":false,"options":[{"label":"Primario","value":"Primario","type":"str"},{"label":"Secondario","value":"Secondario","type":"str"}],"payload":"","topic":"payload","topicType":"msg","className":"","x":140,"y":280,"wires":[["ad8dfbbda055fbc4"]]},{"id":"ad8dfbbda055fbc4","type":"change","z":"e0129591b64c21bc","name":"","rules":[{"t":"set","p":"UserInputCl","pt":"flow","to":"payload3","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":400,"y":280,"wires":[["7e9ce1925c496ba7"]]},{"id":"2733e4a59af46689","type":"ui_group","name":"Inserimento Nuovo Strumento","tab":"fa803f07a50afa29","order":1,"disp":true,"width":"9","collapse":false,"className":""},{"id":"fa803f07a50afa29","type":"ui_tab","name":"Inserimento Attrezzature-Strumentazione","icon":"dns","order":2,"disabled":false,"hidden":false}]

```

---

<div class="post-metadata">

**Author:** ![QGIO](https://avatars.discourse-cdn.com/v4/letter/q/f17d59/32.png) [@QGIO](https://discourse.nodered.org/u/QGIO)\
**Post date:** [11 March 2022 09:33 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/20 "2022-03-11T09:33:15Z")

</div>

I included the nodes of the three inputs and of the Button

---

<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:** [11 March 2022 10:09 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/21 "2022-03-11T10:09:27Z")

</div>

Here is a working flow. Look at the settings I used and how it flows.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/4/647c6a408cf0e72198610390b6f17bf8034fcf9e.png)

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/d/ad03f606c575aa84dab16d76f63c718c970f4e7e.png)

Demo flow (use CTRL+I to import)

```auto
[
    {
        "id": "89f0d8bb4916ea84",
        "type": "ui_toast",
        "z": "7c13b8452619581b",
        "position": "top right",
        "displayTime": "3",
        "highlight": "red",
        "sendall": true,
        "outputs": 0,
        "ok": "OK",
        "cancel": "",
        "raw": false,
        "className": "",
        "topic": "Error",
        "name": "",
        "x": 1120,
        "y": 480,
        "wires": []
    },
    {
        "id": "ca1b95d22899ed5f",
        "type": "change",
        "z": "7c13b8452619581b",
        "name": "",
        "rules": [
            {
                "t": "set",
                "p": "payload",
                "pt": "msg",
                "to": "Classification is empty",
                "tot": "str"
            }
        ],
        "action": "",
        "property": "",
        "from": "",
        "to": "",
        "reg": false,
        "x": 912,
        "y": 480,
        "wires": [
            [
                "89f0d8bb4916ea84"
            ]
        ]
    },
    {
        "id": "ee4477c3a660cfb6",
        "type": "change",
        "z": "7c13b8452619581b",
        "name": "",
        "rules": [
            {
                "t": "set",
                "p": "payload",
                "pt": "msg",
                "to": "User Input is empty",
                "tot": "str"
            }
        ],
        "action": "",
        "property": "",
        "from": "",
        "to": "",
        "reg": false,
        "x": 912,
        "y": 560,
        "wires": [
            [
                "89f0d8bb4916ea84"
            ]
        ]
    },
    {
        "id": "62d7e078e0fdd545",
        "type": "change",
        "z": "7c13b8452619581b",
        "name": "",
        "rules": [
            {
                "t": "set",
                "p": "payload",
                "pt": "msg",
                "to": "Tip is empty",
                "tot": "str"
            }
        ],
        "action": "",
        "property": "",
        "from": "",
        "to": "",
        "reg": false,
        "x": 916,
        "y": 640,
        "wires": [
            [
                "89f0d8bb4916ea84"
            ]
        ]
    },
    {
        "id": "0ded7664e38d4c45",
        "type": "switch",
        "z": "7c13b8452619581b",
        "name": "UserInputCl empty \\n UserInputCl OK",
        "property": "UserInputCl",
        "propertyType": "msg",
        "rules": [
            {
                "t": "null"
            },
            {
                "t": "else"
            }
        ],
        "checkall": "true",
        "repair": false,
        "outputs": 2,
        "x": 694,
        "y": 496,
        "wires": [
            [
                "ca1b95d22899ed5f"
            ],
            [
                "9ec0bad87e7e3ed6"
            ]
        ]
    },
    {
        "id": "9ec0bad87e7e3ed6",
        "type": "switch",
        "z": "7c13b8452619581b",
        "name": "TextInput empty \\n TextInput OK",
        "property": "TextInput",
        "propertyType": "msg",
        "rules": [
            {
                "t": "null"
            },
            {
                "t": "else"
            }
        ],
        "checkall": "true",
        "repair": false,
        "outputs": 2,
        "x": 684,
        "y": 576,
        "wires": [
            [
                "ee4477c3a660cfb6"
            ],
            [
                "29dd2bc068cbb1f8"
            ]
        ]
    },
    {
        "id": "29dd2bc068cbb1f8",
        "type": "switch",
        "z": "7c13b8452619581b",
        "name": "UserInputTip empty \\n UserInputTip OK",
        "property": "UserInputTip",
        "propertyType": "msg",
        "rules": [
            {
                "t": "null"
            },
            {
                "t": "else"
            }
        ],
        "checkall": "true",
        "repair": false,
        "outputs": 2,
        "x": 698,
        "y": 656,
        "wires": [
            [
                "62d7e078e0fdd545"
            ],
            [
                "441e35421e46de9c"
            ]
        ]
    },
    {
        "id": "bf23e13acd4755f5",
        "type": "change",
        "z": "7c13b8452619581b",
        "name": "",
        "rules": [
            {
                "t": "set",
                "p": "UserInputTip",
                "pt": "msg",
                "to": "UserInputTip",
                "tot": "flow"
            },
            {
                "t": "set",
                "p": "TextInput",
                "pt": "msg",
                "to": "TextInput",
                "tot": "flow"
            },
            {
                "t": "set",
                "p": "UserInputCl",
                "pt": "msg",
                "to": "UserInputCl",
                "tot": "flow"
            }
        ],
        "action": "",
        "property": "",
        "from": "",
        "to": "",
        "reg": false,
        "x": 468,
        "y": 496,
        "wires": [
            [
                "0ded7664e38d4c45",
                "cd1d0d31ac6446e8"
            ]
        ]
    },
    {
        "id": "441e35421e46de9c",
        "type": "debug",
        "z": "7c13b8452619581b",
        "name": "-->> To MSSQL PLUS -->>",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": true,
        "complete": "true",
        "targetType": "full",
        "statusVal": "UserInputTip & \"/\" & UserInputCl & \"/\" & TextInput",
        "statusType": "jsonata",
        "x": 768,
        "y": 736,
        "wires": []
    },
    {
        "id": "bce72d0f261b67cb",
        "type": "ui_button",
        "z": "7c13b8452619581b",
        "name": "",
        "group": "2733e4a59af46689",
        "order": 4,
        "width": 0,
        "height": 0,
        "passthru": false,
        "label": "Carica",
        "tooltip": "",
        "color": "",
        "bgcolor": "",
        "className": "",
        "icon": "",
        "payload": "",
        "payloadType": "str",
        "topic": "topic",
        "topicType": "msg",
        "x": 318,
        "y": 496,
        "wires": [
            [
                "bf23e13acd4755f5"
            ]
        ]
    },
    {
        "id": "cd1d0d31ac6446e8",
        "type": "debug",
        "z": "7c13b8452619581b",
        "name": "",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "true",
        "targetType": "full",
        "statusVal": "",
        "statusType": "auto",
        "x": 438,
        "y": 576,
        "wires": []
    },
    {
        "id": "2733e4a59af46689",
        "type": "ui_group",
        "name": "Inserimento Nuovo Strumento",
        "tab": "fa803f07a50afa29",
        "order": 1,
        "disp": true,
        "width": "9",
        "collapse": false,
        "className": ""
    },
    {
        "id": "fa803f07a50afa29",
        "type": "ui_tab",
        "name": "Inserimento Attrezzature-Strumentazione",
        "icon": "dns",
        "order": 2,
        "disabled": false,
        "hidden": false
    }
]

```

  

## NB...

Judging by many of the simple mistakes you made, I definitely recommend you spend some time learning. It will save you (and me) lots of time if you understand what is going on.  
Please take a time out to watch the very useful node-red videos 👇

> [@Steve-Mcl](#):
>
> I recommend watching this playlist: [Node-RED Essentials](https://www.youtube.com/playlist?list=PLyNBB9VCLmo1hyO-4fIZ08gqFcXBkHy-6). The videos are done by the developers of node-red. They're nice & short and to the point. You will understand a whole lot more in about 1 hour. A small investment for a lot of gain.

---

<div class="post-metadata">

**Author:** ![QGIO](https://avatars.discourse-cdn.com/v4/letter/q/f17d59/32.png) [@QGIO](https://discourse.nodered.org/u/QGIO)\
**Post date:** [11 March 2022 11:46 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/22 "2022-03-11T11:46:25Z")

</div>

Thank a lot and sorry if you wasted time for me.

What about the nodes (I mean dropdown and input text) of input data ? I don't see in your flow

---

<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:** [11 March 2022 11:49 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649/23 "2022-03-11T11:49:26Z")

</div>

> [@QGIO](#):
>
> What about the nodes (I mean dropdown and input text) of input data ? I don't see in your flow

I dont understand what you mean. I used what you sent me.

show me what you mean with screenshots of flow and debug output to explain what you mean?

[Next page](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649.md?page=2)