# Nodered Form ui to Sqlite

**URL:** <https://discourse.nodered.org/t/nodered-form-ui-to-sqlite/69375>\
**Category:** General\
**Tags:** node-red-dashboard, database\
**Created:** [21 October 2022 12:06 UTC](https://discourse.nodered.org/t/nodered-form-ui-to-sqlite/69375 "2022-10-21T12:06:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pjlals](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/pjlals/32/69483_2.png) [@Pjlals](https://discourse.nodered.org/u/Pjlals)\
**Post date:** [21 October 2022 12:06 UTC](https://discourse.nodered.org/t/nodered-form-ui-to-sqlite/69375/1 "2022-10-21T12:06:56Z")

</div>

![2022-10-21-165404_1600x900_scrot](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/c/2c24e4fe35d923f565cd52eb79194f4d75693f39.png)  
 ![2022-10-21-165415_1600x900_scrot](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/8/489ebca94268a9fb4a9ab6a2d410546d9bb1a939.png)

HI everyone  
Am trying to insert varaiable data through form ui to sqlite , but its not working .pls help me out  
thanks in advance

---

<div class="post-metadata">

**Author:** ![Dumy](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dumy/32/50320_2.png) [@Dumy](https://discourse.nodered.org/u/Dumy)\
**Post date:** [21 October 2022 12:26 UTC](https://discourse.nodered.org/t/nodered-form-ui-to-sqlite/69375/2 "2022-10-21T12:26:05Z")

</div>

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

I think you want to make like this.  
i share you the code.

```auto
[{"id":"39c40dcef896fa99","type":"ui_form","z":"698c69548f0b524c","name":"","label":"","group":"bc09249168d821ac","order":4,"width":0,"height":0,"options":[{"label":"name","value":"name","type":"text","required":true,"rows":null},{"label":"age","value":"age","type":"number","required":true,"rows":null}],"formValue":{"name":"","age":""},"payload":"","submit":"submit","cancel":"cancel","topic":"topic","topicType":"msg","splitLayout":"","className":"","x":480,"y":220,"wires":[["6644a8c393171d19","c41b7fe9dbcb9e39"]]},{"id":"c41b7fe9dbcb9e39","type":"function","z":"698c69548f0b524c","name":"function 42","func":"msg.topic = `INSERT INTO user (name, age) VALUES ($name, $surname)`\nmsg.payload = [msg.payload.name, msg.payload.age]\nreturn msg;\n// return msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":630,"y":220,"wires":[["70bbd3e3decad314"]]},{"id":"6644a8c393171d19","type":"debug","z":"698c69548f0b524c","name":"debug 86","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":630,"y":140,"wires":[]},{"id":"70bbd3e3decad314","type":"sqlite","z":"698c69548f0b524c","mydb":"ea8cf61559215e94","sqlquery":"msg.topic","sql":"INSERT INTO (name, age) VALUES ('{{paylaod.name}}', {{payload.age}})","name":"","x":770,"y":220,"wires":[["428cc0525a8351ed"]]},{"id":"428cc0525a8351ed","type":"debug","z":"698c69548f0b524c","name":"debug 87","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":900,"y":220,"wires":[]},{"id":"3c708203e102f8d0","type":"inject","z":"698c69548f0b524c","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":500,"y":280,"wires":[["692aac2a6df6b18a"]]},{"id":"692aac2a6df6b18a","type":"sqlite","z":"698c69548f0b524c","mydb":"ea8cf61559215e94","sqlquery":"fixed","sql":"SELECT * FROM user","name":"","x":680,"y":280,"wires":[["0f96ddd5c2fe6c28"]]},{"id":"0f96ddd5c2fe6c28","type":"debug","z":"698c69548f0b524c","name":"debug 88","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":860,"y":280,"wires":[]},{"id":"bc09249168d821ac","type":"ui_group","name":"Patient","tab":"7dcc246f.ee661c","order":1,"disp":false,"width":"24","collapse":false,"className":""},{"id":"ea8cf61559215e94","type":"sqlitedb","db":"ok","mode":"RWC"},{"id":"7dcc246f.ee661c","type":"ui_tab","name":"TEST","icon":"dashboard","order":3,"disabled":false,"hidden":false}]

```

---

<div class="post-metadata">

**Author:** ![Pjlals](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/pjlals/32/69483_2.png) [@Pjlals](https://discourse.nodered.org/u/Pjlals)\
**Post date:** [21 October 2022 15:01 UTC](https://discourse.nodered.org/t/nodered-form-ui-to-sqlite/69375/3 "2022-10-21T15:01:20Z")

</div>

k ,let me try this

---

<div class="post-metadata">

**Author:** ![Pjlals](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/pjlals/32/69483_2.png) [@Pjlals](https://discourse.nodered.org/u/Pjlals)\
**Post date:** [21 October 2022 16:46 UTC](https://discourse.nodered.org/t/nodered-form-ui-to-sqlite/69375/4 "2022-10-21T16:46:15Z")

</div>

![2022-10-21-221405_1600x900_scrot](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/8/c82fcc70bfc5f6cb07a4d9362421587730a3a14e.png)

hi , now i am able insert data through , can u clarify in ur code , debug panel it is showing array(2), but am not able to get any valu in array ,but when i enter in form ui and submit now , data is showing in db

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [20 December 2022 16:46 UTC](https://discourse.nodered.org/t/nodered-form-ui-to-sqlite/69375/5 "2022-12-20T16:46:39Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.