Hello All I have been slowly integrating all my flows into databases. This has been great below is one of my standard flows. To update/insert into the datebase I have to create a msg.topic put the SQL statement in , it is then pushed usually to a functoin node , I do some processing with the msg.pa…

UI Button with dynamic topic based on state

Steve-Mcl 4 August 2019 22:21 2

You might find the template node useful.

E.g.

UPDATE schedule SET weekend_off = {{payload}} WHERE ID = '{{flow.my_id}}'

You can access msg, flow and global variables. Read the help info on the side bar

1 Like

Topic		Replies	Views
Need to use message TOPIC to do an INSERT into a database General	8	379	14 August 2021
Building a dynamic msg.topic to create a mysql insert statement General	17	53	8 July 2025
How can i mention my "ui-button" code in the function node when it is pressed? Dashboard	13	716	14 July 2022
Function to dynamically change the MQTT topic based on user input General	14	4116	19 September 2020
How to reference context based on topic (without using function node)? General	5	1266	24 September 2018