# General

**URL:** https://discourse.nodered.org/c/general/7.md?page=106

[Latest](https://discourse.nodered.org/latest.md) · [Categories](https://discourse.nodered.org/categories.md) · [Tags](https://discourse.nodered.org/tags.md)

**Page:** 107

---

## [Philips Hue Tap Flow](https://discourse.nodered.org/t/philips-hue-tap-flow/85423)

<div class="topic-metadata">

**Author:** [@wise3](https://discourse.nodered.org/u/wise3)\
**Replies:** 9\
**Last updated:** [29 May 2024 16:34 UTC](https://discourse.nodered.org/t/philips-hue-tap-flow/85423 "2024-05-29T16:34:08Z")

</div>

Hello, i'm trying to adapt this excellent node flow https://flows.nodered.org/flow/c95d562d4858cbe1bf80fee95ba9815f?fbclid=IwAR3-tjjPPwWiTE-3W0XmurX5JN5mSCBqfY0aCg3RswcNnhLhnA-fgM-mgwk to convert it to my own device co…

---

## [How to make sure that only one message is sent every few minutes](https://discourse.nodered.org/t/how-to-make-sure-that-only-one-message-is-sent-every-few-minutes/88360)

<div class="topic-metadata">

**Author:** [@HaVi](https://discourse.nodered.org/u/HaVi)\
**Replies:** 2\
**Last updated:** [29 May 2024 16:27 UTC](https://discourse.nodered.org/t/how-to-make-sure-that-only-one-message-is-sent-every-few-minutes/88360 "2024-05-29T16:27:05Z")

</div>

When a certain MQTT message arrives, Pushover sends a message. When a trigger sends MQTT messages in short succession, far too many messages are received. Do you know what the best way is to build in a delay so that the…

---

## [Getting Flow variables into SQLite INSERT](https://discourse.nodered.org/t/getting-flow-variables-into-sqlite-insert/88330)

<div class="topic-metadata">

**Author:** [@jblack](https://discourse.nodered.org/u/jblack)\
**Replies:** 13\
**Last updated:** [29 May 2024 13:10 UTC](https://discourse.nodered.org/t/getting-flow-variables-into-sqlite-insert/88330 "2024-05-29T13:10:13Z")

</div>

I could use a bit of assistance... I am attempting to get a flow variable into a SQLite database. Here is my current INSERT command: INSERT INTO ACC1 (Data, Date, Time) VALUES ("123", strftime('%m-%d-%Y', 'now', 'local…

---

## [Have someone to know how to insert multiple data to MySQL](https://discourse.nodered.org/t/have-someone-to-know-how-to-insert-multiple-data-to-mysql/88337)

<div class="topic-metadata">

**Author:** [@usname1121](https://discourse.nodered.org/u/usname1121)\
**Replies:** 3\
**Last updated:** [29 May 2024 12:01 UTC](https://discourse.nodered.org/t/have-someone-to-know-how-to-insert-multiple-data-to-mysql/88337 "2024-05-29T12:01:22Z")

</div>

I want to insert these data to MySQL database in the one table. how can i insert multiple data in the same time, now i had insert one item data succeed. who can help me?

---

## [I can't format a date in JSONATA](https://discourse.nodered.org/t/i-cant-format-a-date-in-jsonata/88346)

<div class="topic-metadata">

**Author:** [@pierredemay](https://discourse.nodered.org/u/pierredemay)\
**Replies:** 3\
**Last updated:** [29 May 2024 10:31 UTC](https://discourse.nodered.org/t/i-cant-format-a-date-in-jsonata/88346 "2024-05-29T10:31:56Z")

</div>

Hey, I don't understand why my JSONATA line doesn't work in my “Converter” node, about the msg.filename. If someone can take a look : \[{"id":"99e019d5.6f0748","type":"tab","label":"Payrolls","disabled":false,"info":"#…

---

## [How to retrieve the status of my mqtt](https://discourse.nodered.org/t/how-to-retrieve-the-status-of-my-mqtt/88051)

<div class="topic-metadata">

**Author:** [@Paul](https://discourse.nodered.org/u/Paul)\
**Replies:** 41\
**Last updated:** [29 May 2024 09:32 UTC](https://discourse.nodered.org/t/how-to-retrieve-the-status-of-my-mqtt/88051 "2024-05-29T09:32:48Z")

</div>

Hello, I would like to know if it was possible to retrieve the state of my mqtt server in a debug because subsequently I would like to be able to receive a notification which tells me the state of my mqtt server I searc…

---

## [Trigger a Flow Based Upon Date and Time matching System Date and Time](https://discourse.nodered.org/t/trigger-a-flow-based-upon-date-and-time-matching-system-date-and-time/88209)

<div class="topic-metadata">

**Author:** [@JasonH](https://discourse.nodered.org/u/JasonH)\
**Replies:** 9\
**Last updated:** [29 May 2024 05:51 UTC](https://discourse.nodered.org/t/trigger-a-flow-based-upon-date-and-time-matching-system-date-and-time/88209 "2024-05-29T05:51:37Z")

</div>

I have the following setup. It takes a date picker for the user interface and the time entry for the user interface in EST, taking into account DST. When entered it stores these two variables in global sources called t…

---

## [MODBUS Read status relay of DDC to IOT 2050](https://discourse.nodered.org/t/modbus-read-status-relay-of-ddc-to-iot-2050/88238)

<div class="topic-metadata">

**Author:** [@minnguyen999](https://discourse.nodered.org/u/minnguyen999)\
**Replies:** 5\
**Last updated:** [29 May 2024 04:38 UTC](https://discourse.nodered.org/t/modbus-read-status-relay-of-ddc-to-iot-2050/88238 "2024-05-29T04:38:28Z")

</div>

I have a project. Read status RELAY of DDC to IOT 2050. when I read it, the value is error, not 1 or 0. Even though I wrote a convert float 32 function but it still doesn't work. Can anyone help me write a convert func…

---

## [Encrypt msg payload](https://discourse.nodered.org/t/encrypt-msg-payload/87085)

<div class="topic-metadata">

**Author:** [@donsay](https://discourse.nodered.org/u/donsay)\
**Replies:** 4\
**Last updated:** [29 May 2024 03:22 UTC](https://discourse.nodered.org/t/encrypt-msg-payload/87085 "2024-05-29T03:22:37Z")

</div>

Hi. I'm doing an Http 'put' into my NodeRed app. The source is JavaScript on an html page. I've encrypted the 'body' with Crypto-JS, but now I see that's pretty old and has some vulnerabilities. Is there another encrypt…

---

## [Bluetooth, Noble, and Beacons, Oh My](https://discourse.nodered.org/t/bluetooth-noble-and-beacons-oh-my/88308)

<div class="topic-metadata">

**Author:** [@donsay](https://discourse.nodered.org/u/donsay)\
**Replies:** 4\
**Last updated:** [29 May 2024 03:21 UTC](https://discourse.nodered.org/t/bluetooth-noble-and-beacons-oh-my/88308 "2024-05-29T03:21:52Z")

</div>

Hi Folks. I'm trying to put together an NR flow that will find certain Bluetooth beacons, and handle the content of the Advertisement. It seems that node-red-contrib-ble-scan is the node I want, and it depends on n…

---

## [Change name from Device ID](https://discourse.nodered.org/t/change-name-from-device-id/88285)

<div class="topic-metadata">

**Author:** [@Kralle](https://discourse.nodered.org/u/Kralle)\
**Replies:** 8\
**Last updated:** [28 May 2024 19:35 UTC](https://discourse.nodered.org/t/change-name-from-device-id/88285 "2024-05-28T19:35:30Z")

</div>

Hello, I would like to change the name, for example gps001, so that I can immediately recognize the vehicle's identification in the debug and on the map. What would be the configuration then? Thanks

---

## [Enabling a virtual canbus device in docker](https://discourse.nodered.org/t/enabling-a-virtual-canbus-device-in-docker/88322)

<div class="topic-metadata">

**Author:** [@ASmolders](https://discourse.nodered.org/u/ASmolders)\
**Replies:** 0\
**Last updated:** [28 May 2024 12:40 UTC](https://discourse.nodered.org/t/enabling-a-virtual-canbus-device-in-docker/88322 "2024-05-28T12:40:52Z")

</div>

Hello, I'm trying to set up a development environment with docker since I need a virtual canbus (vcan) device under windows. I am using the latest docker image nodered/node-red:latest following the guide under document…

---

## [Delete the decimal places](https://discourse.nodered.org/t/delete-the-decimal-places/88274)

<div class="topic-metadata">

**Author:** [@madmax](https://discourse.nodered.org/u/madmax)\
**Replies:** 4\
**Last updated:** [28 May 2024 10:29 UTC](https://discourse.nodered.org/t/delete-the-decimal-places/88274 "2024-05-28T10:29:34Z")

</div>

Hello! I would like to delete the decimal places on a number? Whats the best way to do this? Thanks in advance.

---

## [Disable a node from another node](https://discourse.nodered.org/t/disable-a-node-from-another-node/88240)

<div class="topic-metadata">

**Author:** [@Veuchez](https://discourse.nodered.org/u/Veuchez)\
**Replies:** 6\
**Last updated:** [28 May 2024 10:29 UTC](https://discourse.nodered.org/t/disable-a-node-from-another-node/88240 "2024-05-28T10:29:26Z")

</div>

Hi everyone, Is it possible to temporarily disable a node from another node? Thank you!

---

## [Mqtt-in password length](https://discourse.nodered.org/t/mqtt-in-password-length/88313)

<div class="topic-metadata">

**Author:** [@HenryTrang](https://discourse.nodered.org/u/HenryTrang)\
**Replies:** 6\
**Last updated:** [28 May 2024 09:02 UTC](https://discourse.nodered.org/t/mqtt-in-password-length/88313 "2024-05-28T09:02:30Z")

</div>

mqtt-in node constantly not connected, when i check the setting i found password has been modify. the length of origin setting pw is 23, when i check it, it become 6. is there limit on pw length on mqtt-in node?

---

## [Setting and running a project using terminal](https://discourse.nodered.org/t/setting-and-running-a-project-using-terminal/88310)

<div class="topic-metadata">

**Author:** [@bigbean17](https://discourse.nodered.org/u/bigbean17)\
**Replies:** 0\
**Last updated:** [28 May 2024 05:13 UTC](https://discourse.nodered.org/t/setting-and-running-a-project-using-terminal/88310 "2024-05-28T05:13:24Z")

</div>

Hi, I'm trying to clone a project (codebase) from github into the projects folder and run that project. Here are what I did: Install node, node-red Change the credentialSecret in the settings.js Clone the project and …

---

## [Timer function with Node-Red in Home assistance](https://discourse.nodered.org/t/timer-function-with-node-red-in-home-assistance/88305)

<div class="topic-metadata">

**Author:** [@tfriedrich85](https://discourse.nodered.org/u/tfriedrich85)\
**Replies:** 2\
**Last updated:** [27 May 2024 23:33 UTC](https://discourse.nodered.org/t/timer-function-with-node-red-in-home-assistance/88305 "2024-05-27T23:33:33Z")

</div>

I would like to control my pool pump in Node red. To do this, I want to use a loop that first switches the pump on for 3 minutes, then wait 15 minutes (until the sun has heated the water on a heating mat on the roof) and…

---

## [Simple Flow read humidity and turn fan on and off](https://discourse.nodered.org/t/simple-flow-read-humidity-and-turn-fan-on-and-off/87493)

<div class="topic-metadata">

**Author:** [@Greg](https://discourse.nodered.org/u/Greg)\
**Replies:** 34\
**Last updated:** [27 May 2024 20:52 UTC](https://discourse.nodered.org/t/simple-flow-read-humidity-and-turn-fan-on-and-off/87493 "2024-05-27T20:52:56Z")

</div>

I am trying something that should be very easy to accomplish, but I am stymied. I am using a nodeMCU and a DHT-22 temperature and humidity sensor (really there are 3, one indoors, one outdoors and one in a separate room)…

---

## [Password protection is not working](https://discourse.nodered.org/t/password-protection-is-not-working/88303)

<div class="topic-metadata">

**Author:** [@k-usama1495](https://discourse.nodered.org/u/k-usama1495)\
**Replies:** 8\
**Last updated:** [27 May 2024 19:06 UTC](https://discourse.nodered.org/t/password-protection-is-not-working/88303 "2024-05-27T19:06:45Z")

</div>

Hi Team, Currently I am using Node-Red 3.1.8. I followed document how to apply password protection but still not working. adminAuth: { type: "credentials", users: \[{ username: "admin", …

---

## [Incorrect coordinates from tracker](https://discourse.nodered.org/t/incorrect-coordinates-from-tracker/88284)

<div class="topic-metadata">

**Author:** [@Kralle](https://discourse.nodered.org/u/Kralle)\
**Replies:** 3\
**Last updated:** [27 May 2024 12:48 UTC](https://discourse.nodered.org/t/incorrect-coordinates-from-tracker/88284 "2024-05-27T12:48:36Z")

</div>

Hello, I have a problem with the trackers that I can't explain. Here it is the tracker gps001. As soon as the vehicle is stationary it sends -1 for the longitude and latitude.Then of course the marker on the map is gone.…

---

## [Logging into a website using node-red](https://discourse.nodered.org/t/logging-into-a-website-using-node-red/88293)

<div class="topic-metadata">

**Author:** [@mrark](https://discourse.nodered.org/u/mrark)\
**Replies:** 0\
**Last updated:** [27 May 2024 11:07 UTC](https://discourse.nodered.org/t/logging-into-a-website-using-node-red/88293 "2024-05-27T11:07:43Z")

</div>

Hello everyone, I am building a flow dedicated to get some PV panels data out of a certain website, which requires a login. I have all the data, but everything I'm trying doesn't seem to work. I tried with a normal HTTP…

---

## [Node-red-node-mysql date +8 hour](https://discourse.nodered.org/t/node-red-node-mysql-date-8-hour/87901)

<div class="topic-metadata">

**Author:** [@HenryTrang](https://discourse.nodered.org/u/HenryTrang)\
**Replies:** 4\
**Last updated:** [27 May 2024 09:11 UTC](https://discourse.nodered.org/t/node-red-node-mysql-date-8-hour/87901 "2024-05-27T09:11:34Z")

</div>

node-red-node-mysql date +8 hour invalid. anyone know how to fixed it?

---

## [Pourquoi ma fonction est elle valide sur un serveur Node-red et pas sur un autre?](https://discourse.nodered.org/t/pourquoi-ma-fonction-est-elle-valide-sur-un-serveur-node-red-et-pas-sur-un-autre/88260)

<div class="topic-metadata">

**Author:** [@jppouma](https://discourse.nodered.org/u/jppouma)\
**Replies:** 2\
**Last updated:** [27 May 2024 05:18 UTC](https://discourse.nodered.org/t/pourquoi-ma-fonction-est-elle-valide-sur-un-serveur-node-red-et-pas-sur-un-autre/88260 "2024-05-27T05:18:05Z")

</div>

Bonjour la communauté, J'ai un script JS dans un bloc Fonction qui fonctionne très bien sur un serveur Node-red (NAS synology) mais qui n'est pas valide sur un autre serveur Node-Red (Cerbo GX de Victron energy). Voici…

---

## [Lightbulb color based on sensor input](https://discourse.nodered.org/t/lightbulb-color-based-on-sensor-input/88271)

<div class="topic-metadata">

**Author:** [@MerMarky](https://discourse.nodered.org/u/MerMarky)\
**Replies:** 3\
**Last updated:** [26 May 2024 15:34 UTC](https://discourse.nodered.org/t/lightbulb-color-based-on-sensor-input/88271 "2024-05-26T15:34:01Z")

</div>

I use function to generate a value for data field for my lightbulb node but it appears that it is not populated correctly. Any ideas? Function code: msg.payload = parseFloat(msg.payload); // Convert payload to a numbe…

---

## [Weird things happening with \`nmap -sP\`](https://discourse.nodered.org/t/weird-things-happening-with-nmap-sp/88277)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 2\
**Last updated:** [26 May 2024 10:54 UTC](https://discourse.nodered.org/t/weird-things-happening-with-nmap-sp/88277 "2024-05-26T10:54:59Z")

</div>

Folks, I'm doing a command nmap -sP \<ip address\> /24 every 20 seconds. Then filtering out for the devices via a switch node. This (filtered) message then goes into a trigger node with a 60 seconds timeout. The 60 is …

---

## [OR Gate accept only ON Message](https://discourse.nodered.org/t/or-gate-accept-only-on-message/88259)

<div class="topic-metadata">

**Author:** [@mimk97](https://discourse.nodered.org/u/mimk97)\
**Replies:** 9\
**Last updated:** [26 May 2024 08:45 UTC](https://discourse.nodered.org/t/or-gate-accept-only-on-message/88259 "2024-05-26T08:45:31Z")

</div>

Is it possible to only pass through the "On" message with an OR gate and if both inputs are set to Off, then only the "Off" message I'm making a URL call for my wallbox Depending on the electricity price or the time, t…

---

## [Debug window: "done processing sending messages:"](https://discourse.nodered.org/t/debug-window-done-processing-sending-messages/88273)

<div class="topic-metadata">

**Author:** [@homonto](https://discourse.nodered.org/u/homonto)\
**Replies:** 6\
**Last updated:** [26 May 2024 08:54 UTC](https://discourse.nodered.org/t/debug-window-done-processing-sending-messages/88273 "2024-05-26T08:54:15Z")

</div>

hi, I just updated my node-red to 3.1 (docker compose) from 3.0 and although everything works, I see lots of messages in debug window: "done processing sending messages:" and first of all: no debug node is there, and, …

---

## [Delay node, help wanted](https://discourse.nodered.org/t/delay-node-help-wanted/88267)

<div class="topic-metadata">

**Author:** [@FSHelgeland](https://discourse.nodered.org/u/FSHelgeland)\
**Replies:** 2\
**Last updated:** [25 May 2024 18:28 UTC](https://discourse.nodered.org/t/delay-node-help-wanted/88267 "2024-05-25T18:28:27Z")

</div>

\[ { "id": "a11fe5d5f925d625", "type": "switch", "z": "7b83b20cb732bf2a", "name": "State Check", "property": "payload", "propertyType": "msg", "rules": \[ …

---

## [Node-red Dashboard ui-template not able to send message/payload](https://discourse.nodered.org/t/node-red-dashboard-ui-template-not-able-to-send-message-payload/88265)

<div class="topic-metadata">

**Author:** [@steelbuddy](https://discourse.nodered.org/u/steelbuddy)\
**Replies:** 2\
**Last updated:** [25 May 2024 18:02 UTC](https://discourse.nodered.org/t/node-red-dashboard-ui-template-not-able-to-send-message-payload/88265 "2024-05-25T18:02:55Z")

</div>

Hi, iI searched and tryed many options to get a payload out of this ui-template-node. Wether version 1 or Version 2 is sending an outpout to a Debug-node. have no more idea what´s wrong? Using v3.1.3 and old Dashbo…

---

## [Send multi topic mqtt](https://discourse.nodered.org/t/send-multi-topic-mqtt/88257)

<div class="topic-metadata">

**Author:** [@wiwan-wijoyo](https://discourse.nodered.org/u/wiwan-wijoyo)\
**Replies:** 2\
**Last updated:** [25 May 2024 12:11 UTC](https://discourse.nodered.org/t/send-multi-topic-mqtt/88257 "2024-05-25T12:11:06Z")

</div>

Hi, how to make mqtt topic submission simpler if preset 1 is on then preset 2,3,4 is off if preset 2 is on then preset 1,3,4 is off etc. image send preset 1 image send preset 2 thanks \[{"id":"acf6a62ed64e2b…

[Previous page](https://discourse.nodered.org/c/general/7.md?page=105)

[Next page](https://discourse.nodered.org/c/general/7.md?page=107)