Hi, I'm creating a web application using Node-RED. I'm having complications in inserting, updating and deleting data from the Node-Red dashboard inputs (drop down, switch, slider, numeric, text input, date picker) to the database. User registration, login and display information are the main functi…

[image] rishanaziz: To something? I can't get you. To anything, it doesn't matter what it is set to. Set it the string complete for example. The Join node just looks for msg.complete to be present, it doesn't test the value.

I think you might find that there is still an issue after making the change I suggested. It might seem to work perfectly at first but then not quite do what you want. Come back if it is an issue for you.

Hi Colin, I think it's working as what I expected. However, I would like to know whether we are able to save the values to the database with the insert-query function that I had created? The following is the screenshot: [image] The following is the insert-query function that I had created: msg.…

Does it work? If not what happens?

Yes, it's working. Thank you very much for your help.

Have you noticed that if you submit the text then just change the code and submit again then it does not work as only the code is sent? I see you have separately asked a question on how to link back from the submit to clear the fields, but if you want, it is possible to make it so that if you click…

Change which code? How to do clear the fields?

If you want it to send the latest values even when you have only changed one (such as the code) then you can use this [{"id":"ab218375.33ee68","type":"ui_text_input","z":"acd8202b.36972","name":"name","label":"Name","group":"b7868331.17d03","order":1,"width":0,"height":0,"passthru":false,"mode":"te…

Okay. If like that, what I should set on the Change node?

Node-RED

Node-RED Forum

Need Help to Insert, Update and Delete Data from Node-RED Dashboard Inputs to the Database

Dashboard

tarihoran20 3 May 2019 09:53 34

Send data to Microsoft Azure

Topic		Replies	Views
Pass data throught a button to SQL Table General	27	1254	15 March 2022
Read from mysql db Dashboard	54	17688	23 December 2018
Receiving data from multiple nodes and uploading it to sqlite database General	12	1315	1 February 2021
How to setup a multi-input form to register an Item Dashboard	4	696	29 June 2021
Creating form then logging entry in SQL General	14	478	7 May 2021

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Need Help to Insert, Update and Delete Data from Node-RED Dashboard Inputs to the Database

Related topics