# General

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

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

**Page:** 447

---

## [How to pass payload data from node red to mysql](https://discourse.nodered.org/t/how-to-pass-payload-data-from-node-red-to-mysql/55875)

<div class="topic-metadata">

**Author:** [@asyrahshah](https://discourse.nodered.org/u/asyrahshah)\
**Replies:** 6\
**Last updated:** [30 December 2021 13:44 UTC](https://discourse.nodered.org/t/how-to-pass-payload-data-from-node-red-to-mysql/55875 "2021-12-30T13:44:01Z")

</div>

Hello I am new with node red. Currently, I am working with node-red and mysql database for my final year project. I would like to send temperature data to the database but i have error stated that the array is undefined. …

---

## ["Project" optional user-supplied commit message](https://discourse.nodered.org/t/project-optional-user-supplied-commit-message/55839)

<div class="topic-metadata">

**Author:** [@ajlennon](https://discourse.nodered.org/u/ajlennon)\
**Replies:** 2\
**Last updated:** [30 December 2021 12:26 UTC](https://discourse.nodered.org/t/project-optional-user-supplied-commit-message/55839 "2021-12-30T12:26:36Z")

</div>

We're having a great time with the project support, which is auto-committing on deploys and pushing up to a repo on GitHub. This works very very well. What would help a lot is if we could turn on an optional commit mess…

---

## [On and off random for 2 Relays alternating](https://discourse.nodered.org/t/on-and-off-random-for-2-relays-alternating/55851)

<div class="topic-metadata">

**Author:** [@edstobi](https://discourse.nodered.org/u/edstobi)\
**Replies:** 5\
**Last updated:** [30 December 2021 11:35 UTC](https://discourse.nodered.org/t/on-and-off-random-for-2-relays-alternating/55851 "2021-12-30T11:35:12Z")

</div>

Hi I am trying to send to mqtt a random on and off for two relays. I tried to work with delay random delay. But this succeeds me only once and then stopped. I want to send random on and off as long as an action is act…

---

## [Watch smart-plug for power usage ans switch on/off other smart-plug](https://discourse.nodered.org/t/watch-smart-plug-for-power-usage-ans-switch-on-off-other-smart-plug/55847)

<div class="topic-metadata">

**Author:** [@adrieg](https://discourse.nodered.org/u/adrieg)\
**Replies:** 8\
**Last updated:** [30 December 2021 10:21 UTC](https://discourse.nodered.org/t/watch-smart-plug-for-power-usage-ans-switch-on-off-other-smart-plug/55847 "2021-12-30T10:21:21Z")

</div>

How can I create an sequence so a smart-plug will be watched and if power usage is above 1 watt the other plug turns on. I have made a sequence but that only works when I turn on the 1st plug and it only runs once. Hope…

---

## [Calculate number of hours with temperature higher then?](https://discourse.nodered.org/t/calculate-number-of-hours-with-temperature-higher-then/55873)

<div class="topic-metadata">

**Author:** [@dohnalradek](https://discourse.nodered.org/u/dohnalradek)\
**Replies:** 1\
**Last updated:** [30 December 2021 08:44 UTC](https://discourse.nodered.org/t/calculate-number-of-hours-with-temperature-higher-then/55873 "2021-12-30T08:44:31Z")

</div>

Hi. I need to calculate number of hours with average temperatue higher then 7°C. I can calculate avwrage temperature per hour (by using calculate node) But I dont know what next? This node push one number every hou…

---

## [TradeView financial charts in Dashboard UI Template](https://discourse.nodered.org/t/tradeview-financial-charts-in-dashboard-ui-template/55691)

<div class="topic-metadata">

**Author:** [@interscope101](https://discourse.nodered.org/u/interscope101)\
**Replies:** 13\
**Last updated:** [30 December 2021 04:04 UTC](https://discourse.nodered.org/t/tradeview-financial-charts-in-dashboard-ui-template/55691 "2021-12-30T04:04:27Z")

</div>

Hello, attempting to incorporate TraveView charts into Dashboard UI Template. Code below works fine as a direct embed. However, not having success doing it via a msg.payload inject (in order to be able to progr…

---

## [Merging instead of appending JSON in JOIN node after SPLIT](https://discourse.nodered.org/t/merging-instead-of-appending-json-in-join-node-after-split/55864)

<div class="topic-metadata">

**Author:** [@hobojoe720](https://discourse.nodered.org/u/hobojoe720)\
**Replies:** 6\
**Last updated:** [29 December 2021 23:18 UTC](https://discourse.nodered.org/t/merging-instead-of-appending-json-in-join-node-after-split/55864 "2021-12-29T23:18:37Z")

</div>

I pull some data out of MySQL, split this and then format the results to create the JSON I need from each row and am trying to get this to merge correctly but think I am missing something here. The example flow below res…

---

## [Removing a node manually](https://discourse.nodered.org/t/removing-a-node-manually/55860)

<div class="topic-metadata">

**Author:** [@ebolisa](https://discourse.nodered.org/u/ebolisa)\
**Replies:** 18\
**Last updated:** [29 December 2021 23:09 UTC](https://discourse.nodered.org/t/removing-a-node-manually/55860 "2021-12-29T23:09:03Z")

</div>

Hello, How to surgically remove a node? Somehow, I corrupted a node but I just cannot remove it via dashboard. In log: 2021-12-29T18:06:01.980Z Remove : node-red-contrib-aedes In console: "Error: Unrecognised mo…

---

## [How to make a flow, a topic is missing](https://discourse.nodered.org/t/how-to-make-a-flow-a-topic-is-missing/55703)

<div class="topic-metadata">

**Author:** [@etmomoabc](https://discourse.nodered.org/u/etmomoabc)\
**Replies:** 12\
**Last updated:** [29 December 2021 21:32 UTC](https://discourse.nodered.org/t/how-to-make-a-flow-a-topic-is-missing/55703 "2021-12-29T21:32:52Z")

</div>

Hi guys, Can someone help me? My question is, I want to do an automation. When outputting multiple topics, if a topic is missing, then turn on the switch. For example, the usual output are A, B and C 3 topics, but whe…

---

## [PT2262-in to boolean true](https://discourse.nodered.org/t/pt2262-in-to-boolean-true/55838)

<div class="topic-metadata">

**Author:** [@NR-Beginner](https://discourse.nodered.org/u/NR-Beginner)\
**Replies:** 7\
**Last updated:** [29 December 2021 20:13 UTC](https://discourse.nodered.org/t/pt2262-in-to-boolean-true/55838 "2021-12-29T20:13:31Z")

</div>

hello insider, a newbie here .... i am stuck. i have a 4 channel remote here, i would like to use it to control 4 philips Hue smartplugs. The smartplugs only respond to boolean true or false I recognize by PT2262-in t…

---

## [Best practices for my Google Home device names (cross room)](https://discourse.nodered.org/t/best-practices-for-my-google-home-device-names-cross-room/55796)

<div class="topic-metadata">

**Author:** [@BartButenaers](https://discourse.nodered.org/u/BartButenaers)\
**Replies:** 5\
**Last updated:** [29 December 2021 18:36 UTC](https://discourse.nodered.org/t/best-practices-for-my-google-home-device-names-cross-room/55796 "2021-12-29T18:36:57Z")

</div>

Hi folks, Not 100% Node-RED related, but had a lot of fun today because my node-red-contrib-google-smarthome is finally running. Even my Google Home Mini device - which is lying in my basement unused already for severa…

---

## [Change node to set value for each object in array](https://discourse.nodered.org/t/change-node-to-set-value-for-each-object-in-array/55853)

<div class="topic-metadata">

**Author:** [@peter\_a](https://discourse.nodered.org/u/peter_a)\
**Replies:** 5\
**Last updated:** [29 December 2021 18:09 UTC](https://discourse.nodered.org/t/change-node-to-set-value-for-each-object-in-array/55853 "2021-12-29T18:09:12Z")

</div>

I have a flow context variable that contains an array of objects. Each object has a a key/value pair with key "on" and a boolean value: {"seg": \[ {"id": 0, "on": true}, {"id": 1, "on": true}, {"…

---

## [Sending a msg.reset](https://discourse.nodered.org/t/sending-a-msg-reset/55858)

<div class="topic-metadata">

**Author:** [@ebolisa](https://discourse.nodered.org/u/ebolisa)\
**Replies:** 2\
**Last updated:** [29 December 2021 18:01 UTC](https://discourse.nodered.org/t/sending-a-msg-reset/55858 "2021-12-29T18:01:53Z")

</div>

Hi, I'm trying to send a reset to a shiftregister node. The docs state that I need to send/set a msg.reset but it doesn't work. Where's my error? TIA \[ { "id": "7fa393fdc39736c7", "type": "shift r…

---

## [Creating new flow instead of using existing one](https://discourse.nodered.org/t/creating-new-flow-instead-of-using-existing-one/55852)

<div class="topic-metadata">

**Author:** [@Maximilian](https://discourse.nodered.org/u/Maximilian)\
**Replies:** 4\
**Last updated:** [29 December 2021 16:54 UTC](https://discourse.nodered.org/t/creating-new-flow-instead-of-using-existing-one/55852 "2021-12-29T16:54:00Z")

</div>

Hello, recently for some reason, when node-red gets started, it finds the flow in the directory, but instead it chooses to create a new flow and use that one instead. Can you help with this issue please? Original versi…

---

## [Accessing ContextStore of embedded instance of nodered from parent node.js application](https://discourse.nodered.org/t/accessing-contextstore-of-embedded-instance-of-nodered-from-parent-node-js-application/55761)

<div class="topic-metadata">

**Author:** [@looccaa](https://discourse.nodered.org/u/looccaa)\
**Replies:** 2\
**Last updated:** [29 December 2021 16:07 UTC](https://discourse.nodered.org/t/accessing-contextstore-of-embedded-instance-of-nodered-from-parent-node-js-application/55761 "2021-12-29T16:07:11Z")

</div>

Hi, I am trying to create applicaton in nodejs with embeded node-red instance. Is there any possibility to access (read and write) the ContextStore (global, flow and node cotenxt variables) set in Nodered nodes from pa…

---

## [UI Text background color change](https://discourse.nodered.org/t/ui-text-background-color-change/55804)

<div class="topic-metadata">

**Author:** [@traderjoe](https://discourse.nodered.org/u/traderjoe)\
**Replies:** 5\
**Last updated:** [29 December 2021 15:41 UTC](https://discourse.nodered.org/t/ui-text-background-color-change/55804 "2021-12-29T15:41:02Z")

</div>

I'm trying to change the background color of the UI text. I'm trying to do something like this: I like the way this looks because it adds a lot more color to an otherwise dull dashboard. The original dashboard looks…

---

## [Digital twin with node red](https://discourse.nodered.org/t/digital-twin-with-node-red/55823)

<div class="topic-metadata">

**Author:** [@taj2](https://discourse.nodered.org/u/taj2)\
**Replies:** 3\
**Last updated:** [29 December 2021 15:16 UTC](https://discourse.nodered.org/t/digital-twin-with-node-red/55823 "2021-12-29T15:16:42Z")

</div>

Hi all, I am currently researching digital twins. I would like to know how we can make a digital twin with node red and docker. without the need to use the cloud only in my Raspberry. Any tutorials or links would be ve…

---

## [Is it safe to use the uibuilder route for a Node-RED based http-in API?](https://discourse.nodered.org/t/is-it-safe-to-use-the-uibuilder-route-for-a-node-red-based-http-in-api/55767)

<div class="topic-metadata">

**Author:** [@dczysz](https://discourse.nodered.org/u/dczysz)\
**Replies:** 7\
**Last updated:** [29 December 2021 14:49 UTC](https://discourse.nodered.org/t/is-it-safe-to-use-the-uibuilder-route-for-a-node-red-based-http-in-api/55767 "2021-12-29T14:49:43Z")

</div>

I have a UI built with the (fantastic) UI Builder node, with the base path set to ui. I'm hosting this behind a reverse proxy with the path of /ui\* to properly forward for example both /ui/index.html and /uibuilder/vend…

---

## [Modbus connection stop](https://discourse.nodered.org/t/modbus-connection-stop/17076)

<div class="topic-metadata">

**Author:** [@jlb](https://discourse.nodered.org/u/jlb)\
**Replies:** 14\
**Last updated:** [29 December 2021 14:48 UTC](https://discourse.nodered.org/t/modbus-connection-stop/17076 "2021-12-29T14:48:08Z")

</div>

Hello, I d like to know if there is a solution in order to stop/start a modbus connection with an inject button/function ? I tried with some stop/kill command but if the polling is stopped, the data are always read from…

---

## [Can't install palette on docker stack](https://discourse.nodered.org/t/cant-install-palette-on-docker-stack/55835)

<div class="topic-metadata">

**Author:** [@Desaydrone](https://discourse.nodered.org/u/Desaydrone)\
**Replies:** 0\
**Last updated:** [29 December 2021 13:22 UTC](https://discourse.nodered.org/t/cant-install-palette-on-docker-stack/55835 "2021-12-29T13:22:30Z")

</div>

Hi every one, I try to install palette on my node red (fresh install with portainer) and i can't. Here the log that i have in result 602 verbose stack Error: ENOTSUP: operation not supported on socket, symlink '../mult…

---

## [Sendgrid substitution tags not working](https://discourse.nodered.org/t/sendgrid-substitution-tags-not-working/55812)

<div class="topic-metadata">

**Author:** [@Sebas\_t](https://discourse.nodered.org/u/Sebas_t)\
**Replies:** 7\
**Last updated:** [29 December 2021 09:10 UTC](https://discourse.nodered.org/t/sendgrid-substitution-tags-not-working/55812 "2021-12-29T09:10:34Z")

</div>

Hi, I'm designing a IoT platform with notification. The notifications will be send using the sendgrid and I want to insert data from my platform in the e-mail using substitution tags. However the email sends just fine…

---

## [Got problems with Alexa-home nodes this morning](https://discourse.nodered.org/t/got-problems-with-alexa-home-nodes-this-morning/55746)

<div class="topic-metadata">

**Author:** [@cymplecy](https://discourse.nodered.org/u/cymplecy)\
**Replies:** 11\
**Last updated:** [29 December 2021 05:12 UTC](https://discourse.nodered.org/t/got-problems-with-alexa-home-nodes-this-morning/55746 "2021-12-29T05:12:11Z")

</div>

@hardillb

---

## [Is there a scheduling node that does this](https://discourse.nodered.org/t/is-there-a-scheduling-node-that-does-this/55800)

<div class="topic-metadata">

**Author:** [@hazymat](https://discourse.nodered.org/u/hazymat)\
**Replies:** 19\
**Last updated:** [29 December 2021 01:31 UTC](https://discourse.nodered.org/t/is-there-a-scheduling-node-that-does-this/55800 "2021-12-29T01:31:30Z")

</div>

\[edited to clarify some points\] This is kind of a question AND an idea for a contrib (if it doesn't exist). There are a tonne of scheduling nodes and I've tried quite a few of them. Here's a good list. Perhaps I've miss…

---

## [Help with controlling relay board by using node-RED](https://discourse.nodered.org/t/help-with-controlling-relay-board-by-using-node-red/55807)

<div class="topic-metadata">

**Author:** [@marius](https://discourse.nodered.org/u/marius)\
**Replies:** 15\
**Last updated:** [28 December 2021 22:16 UTC](https://discourse.nodered.org/t/help-with-controlling-relay-board-by-using-node-red/55807 "2021-12-28T22:16:27Z")

</div>

hello. I'm looking for help with this error: Welcome to the Node-RED Dashboard Please add some UI nodes to your flow and redeploy I have noticed a common problem with this.... 28 Dec 22:19:48 - \[info\] Node-RED version…

---

## [Countdown timer, im missing a reset function](https://discourse.nodered.org/t/countdown-timer-im-missing-a-reset-function/55798)

<div class="topic-metadata">

**Author:** [@syma33](https://discourse.nodered.org/u/syma33)\
**Replies:** 1\
**Last updated:** [28 December 2021 21:46 UTC](https://discourse.nodered.org/t/countdown-timer-im-missing-a-reset-function/55798 "2021-12-28T21:46:15Z")

</div>

this works but with flaws.. the goal is to set countdowntimer and have a resetbutton combined with the force button. (while forcing is set, timer will be set to reset) However, in this i tried but here isnt any way to st…

---

## [Compute countdown timer value via Node-RED and then use in Grafana](https://discourse.nodered.org/t/compute-countdown-timer-value-via-node-red-and-then-use-in-grafana/55769)

<div class="topic-metadata">

**Author:** [@grant1](https://discourse.nodered.org/u/grant1)\
**Replies:** 6\
**Last updated:** [28 December 2021 19:10 UTC](https://discourse.nodered.org/t/compute-countdown-timer-value-via-node-red-and-then-use-in-grafana/55769 "2021-12-28T19:10:03Z")

</div>

I currently have a simple javascript countdown timer script running in a Grafana Text panel: Here is what the Text panel looks like: I realize using Node-RED dashboard would be a logical place to use a countdown t…

---

## [Flows stopped due to missing node types. rpi-gpio out](https://discourse.nodered.org/t/flows-stopped-due-to-missing-node-types-rpi-gpio-out/55789)

<div class="topic-metadata">

**Author:** [@taj2](https://discourse.nodered.org/u/taj2)\
**Replies:** 6\
**Last updated:** [28 December 2021 16:19 UTC](https://discourse.nodered.org/t/flows-stopped-due-to-missing-node-types-rpi-gpio-out/55789 "2021-12-28T16:19:27Z")

</div>

Hi, I'm learning node red I get this error message when deploying. I don't know how to solve it. I am using Node red V2.1.4 on my raspberry and I can't see where to select the node type.

---

## [Which node to install for mssql server 19](https://discourse.nodered.org/t/which-node-to-install-for-mssql-server-19/55795)

<div class="topic-metadata">

**Author:** [@isabel](https://discourse.nodered.org/u/isabel)\
**Replies:** 2\
**Last updated:** [28 December 2021 16:16 UTC](https://discourse.nodered.org/t/which-node-to-install-for-mssql-server-19/55795 "2021-12-28T16:16:37Z")

</div>

Hi, I am having trouble in connecting mssql server, i have node red version v2.1.4 and sql server 19, which node do i have to install ? node-red-config-mssql? or plus? Thanks a lot

---

## [MODBUS RTU: Respond on read telegram using node-red-contrib-modbus](https://discourse.nodered.org/t/modbus-rtu-respond-on-read-telegram-using-node-red-contrib-modbus/55605)

<div class="topic-metadata">

**Author:** [@americanium](https://discourse.nodered.org/u/americanium)\
**Replies:** 5\
**Last updated:** [28 December 2021 15:38 UTC](https://discourse.nodered.org/t/modbus-rtu-respond-on-read-telegram-using-node-red-contrib-modbus/55605 "2021-12-28T15:38:44Z")

</div>

Hallo! I want to simulate a slave and serving different values to the master. Master / Slave (Pi with Node-red and Modbus interface). I know the sample which is included in the node-red package but I think I don't unde…

---

## [Completely stuck with node-red-contrib-google-smarthome](https://discourse.nodered.org/t/completely-stuck-with-node-red-contrib-google-smarthome/55709)

<div class="topic-metadata">

**Author:** [@BartButenaers](https://discourse.nodered.org/u/BartButenaers)\
**Replies:** 15\
**Last updated:** [28 December 2021 12:55 UTC](https://discourse.nodered.org/t/completely-stuck-with-node-red-contrib-google-smarthome/55709 "2021-12-28T12:55:12Z")

</div>

Hi folks, Merry christmas to you all !!!! I have to admit that I am very near a Node-RED burn out... Have been trying to fill gaps in the last years by developing lots of custom nodes. But now 4 years later I have a …

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

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