# Latest

**URL:** https://discourse.nodered.org/latest.md?page=273

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

**Page:** 274

---

## [Write json files to another computer on the network](https://discourse.nodered.org/t/write-json-files-to-another-computer-on-the-network/82986)

<div class="topic-metadata">

**Author:** [@Linhey](https://discourse.nodered.org/u/Linhey)\
**Replies:** 7\
**Last updated:** [19 November 2023 14:49 UTC](https://discourse.nodered.org/t/write-json-files-to-another-computer-on-the-network/82986 "2023-11-19T14:49:26Z")

</div>

I want to be able to write a JSON file to another computer internally on my network, but however I construct the file path in the write node I cannot get access. I suppose this is an issue with authorization, but surel…

---

## [How to delete data from influxdb2 with node red](https://discourse.nodered.org/t/how-to-delete-data-from-influxdb2-with-node-red/83007)

<div class="topic-metadata">

**Author:** [@88bit](https://discourse.nodered.org/u/88bit)\
**Replies:** 4\
**Last updated:** [19 November 2023 11:56 UTC](https://discourse.nodered.org/t/how-to-delete-data-from-influxdb2-with-node-red/83007 "2023-11-19T11:56:02Z")

</div>

Hi all, I’m trying to delete records from a influxdb and I can’t find anything about this anywhere. I have found some possibilities using the http API but I have no idea how to implement this in Node Red. Any help would…

---

## [Does anybody know the correct command line for sshpass to SSH in, start a script and log out again?](https://discourse.nodered.org/t/does-anybody-know-the-correct-command-line-for-sshpass-to-ssh-in-start-a-script-and-log-out-again/82974)

<div class="topic-metadata">

**Author:** [@Mastiff](https://discourse.nodered.org/u/Mastiff)\
**Replies:** 12\
**Last updated:** [19 November 2023 09:52 UTC](https://discourse.nodered.org/t/does-anybody-know-the-correct-command-line-for-sshpass-to-ssh-in-start-a-script-and-log-out-again/82974 "2023-11-19T09:52:12Z")

</div>

I want to run the script sikkerhetskopiering.sh that copies the data from Node-RED, Home Assistant and a few other things, from an exec node (impossible directly because I have Node-RED in a Docker container, and I want …

---

## [Tado are changing their authentication. Help needed please](https://discourse.nodered.org/t/tado-are-changing-their-authentication-help-needed-please/82991)

<div class="topic-metadata">

**Author:** [@bobbles](https://discourse.nodered.org/u/bobbles)\
**Replies:** 3\
**Last updated:** [19 November 2023 00:26 UTC](https://discourse.nodered.org/t/tado-are-changing-their-authentication-help-needed-please/82991 "2023-11-19T00:26:20Z")

</div>

I am using the node "node-red-contrib-tado-client" that is owned by mattdavis90. I have received the following email from Tado that says the following. We have noticed that you are using the unofficial tado° REST API w…

---

## [\[FR / PR\] Click on id in debug panel highlights node or flow](https://discourse.nodered.org/t/fr-pr-click-on-id-in-debug-panel-highlights-node-or-flow/82988)

<div class="topic-metadata">

**Author:** [@ralphwetzel](https://discourse.nodered.org/u/ralphwetzel)\
**Replies:** 26\
**Last updated:** [18 November 2023 21:51 UTC](https://discourse.nodered.org/t/fr-pr-click-on-id-in-debug-panel-highlights-node-or-flow/82988 "2023-11-18T21:51:35Z")

</div>

Quite regularly I find myself putting the id of a node or flow in a msg for debugging. To find this node / flow in my editor, I'm then copying this id & enter it in the search box. Works - but is a bit inconvenient. I'm…

---

## [Digits in the Gauge](https://discourse.nodered.org/t/digits-in-the-gauge/82996)

<div class="topic-metadata">

**Author:** [@Panda](https://discourse.nodered.org/u/Panda)\
**Replies:** 3\
**Last updated:** [18 November 2023 21:32 UTC](https://discourse.nodered.org/t/digits-in-the-gauge/82996 "2023-11-18T21:32:34Z")

</div>

Hey guys, is it possible to change the digits in the gauge. I want to see something like 23.68, but I only get 23.7. I tried msg.precision = 4 but this didn't change anything.

---

## [esp32-Tasmota-nodered-influx](https://discourse.nodered.org/t/esp32-tasmota-nodered-influx/82932)

<div class="topic-metadata">

**Author:** [@eli5](https://discourse.nodered.org/u/eli5)\
**Replies:** 14\
**Last updated:** [18 November 2023 21:05 UTC](https://discourse.nodered.org/t/esp32-tasmota-nodered-influx/82932 "2023-11-18T21:05:55Z")

</div>

Hey there, i have a esp32 with a DHT22 Sensor on it and let it send via mosquito in my node-red installation. Everything works fine so far. Now I try to keep that data to visualise it via Grafana. I want to store it in…

---

## [Use only one join-wait](https://discourse.nodered.org/t/use-only-one-join-wait/82993)

<div class="topic-metadata">

**Author:** [@themsk](https://discourse.nodered.org/u/themsk)\
**Replies:** 2\
**Last updated:** [18 November 2023 18:10 UTC](https://discourse.nodered.org/t/use-only-one-join-wait/82993 "2023-11-18T18:10:26Z")

</div>

Hi guys. I have a flow where i use two join-wait and i like to minimalize the code and use only one join-wait if its possible. the flow is for persons arrival at home. this is the flow code: \[{"id":"b2a1d7392b12278d",…

---

## [Error: Arduino Serial port closed when connecting to arduino Uno](https://discourse.nodered.org/t/error-arduino-serial-port-closed-when-connecting-to-arduino-uno/82934)

<div class="topic-metadata">

**Author:** [@viniciusleite](https://discourse.nodered.org/u/viniciusleite)\
**Replies:** 6\
**Last updated:** [18 November 2023 17:51 UTC](https://discourse.nodered.org/t/error-arduino-serial-port-closed-when-connecting-to-arduino-uno/82934 "2023-11-18T17:51:59Z")

</div>

I got this error after starting node-red, deploying a flow where I send true on the payload of a message to arduino Digital pin 9 and then changing the pin to 12 and deploying again. I'm on an Ubuntu 22.04 Virtual Machi…

---

## [UIBUILDER example: Create a selection drop-down using low-code configuration](https://discourse.nodered.org/t/uibuilder-example-create-a-selection-drop-down-using-low-code-configuration/82994)

<div class="topic-metadata">

**Author:** [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Replies:** 0\
**Last updated:** [18 November 2023 17:32 UTC](https://discourse.nodered.org/t/uibuilder-example-create-a-selection-drop-down-using-low-code-configuration/82994 "2023-11-18T17:32:50Z")

</div>

So that I don't forget to post this somewhere vaguely useful, here is some front-end code as an example of using UIBUILDER's low-code capabilities in your front-end (browser) code to create an on-screen element dynamical…

---

## [Right Axis in the Time plot](https://discourse.nodered.org/t/right-axis-in-the-time-plot/82989)

<div class="topic-metadata">

**Author:** [@Panda](https://discourse.nodered.org/u/Panda)\
**Replies:** 2\
**Last updated:** [18 November 2023 11:39 UTC](https://discourse.nodered.org/t/right-axis-in-the-time-plot/82989 "2023-11-18T11:39:47Z")

</div>

Hey guys, I'm trying to use the right Axis in my time plot. But when I use msg.axes I'll only get the error "...must be an array or null..." I want to record my internet speed and ping. How can someone help me to use…

---

## [Node-red login with google oauth2.0 help](https://discourse.nodered.org/t/node-red-login-with-google-oauth2-0-help/82927)

<div class="topic-metadata">

**Author:** [@ArcanePhysics](https://discourse.nodered.org/u/ArcanePhysics)\
**Replies:** 5\
**Last updated:** [18 November 2023 10:37 UTC](https://discourse.nodered.org/t/node-red-login-with-google-oauth2-0-help/82927 "2023-11-18T10:37:16Z")

</div>

Hello, I am, trying to set up my node-red with google oauth login Following this page Securing Node-RED : Node-RED section OAuth/OpenID based authentication I have installed passport-google-oauth20 and filled the co…

---

## [What am I doing wrong?](https://discourse.nodered.org/t/what-am-i-doing-wrong/82982)

<div class="topic-metadata">

**Author:** [@cymplecy](https://discourse.nodered.org/u/cymplecy)\
**Replies:** 3\
**Last updated:** [18 November 2023 09:46 UTC](https://discourse.nodered.org/t/what-am-i-doing-wrong/82982 "2023-11-18T09:46:47Z")

</div>

Why is the top inject not being routed to top debug node? \[{"id":"c82cdbdd3cd2858e","type":"inject","z":"d760e2801b9ca31b","name":"t","props":\[{"p":"payload"},{"p":"payload.init","v":"true","vt":"bool"}\],"repeat":""…

---

## [Array to string with delimiting characters](https://discourse.nodered.org/t/array-to-string-with-delimiting-characters/82980)

<div class="topic-metadata">

**Author:** [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Replies:** 6\
**Last updated:** [18 November 2023 09:38 UTC](https://discourse.nodered.org/t/array-to-string-with-delimiting-characters/82980 "2023-11-18T09:38:07Z")

</div>

Hi, i am stuck at one point and unable to get to solution. I am almost there (or am I?). i have an array output coming from mysql query, which i need to convert to a string with a semicolon between each string. I can do…

---

## [\[Feature Request\]Add Detach Selected Nodes to right-click menu](https://discourse.nodered.org/t/feature-request-add-detach-selected-nodes-to-right-click-menu/82981)

<div class="topic-metadata">

**Author:** [@cymplecy](https://discourse.nodered.org/u/cymplecy)\
**Replies:** 0\
**Last updated:** [18 November 2023 08:59 UTC](https://discourse.nodered.org/t/feature-request-add-detach-selected-nodes-to-right-click-menu/82981 "2023-11-18T08:59:23Z")

</div>

The only editor action that I use, that I can't achieve with the right-click context menu is Could it be added please? Now, it might be that everyone has a item they want adding to the right-click menu so feel free t…

---

## [Code function for change format data from Kepware to Power BI](https://discourse.nodered.org/t/code-function-for-change-format-data-from-kepware-to-power-bi/82978)

<div class="topic-metadata">

**Author:** [@Denchai](https://discourse.nodered.org/u/Denchai)\
**Replies:** 6\
**Last updated:** [18 November 2023 07:58 UTC](https://discourse.nodered.org/t/code-function-for-change-format-data-from-kepware-to-power-bi/82978 "2023-11-18T07:58:29Z")

</div>

Who know about code function for change format data from Kepware like picture below to API of Power BI format as \[ { "RANDOM\_NUM" :98.6 } \] Thank you.

---

## [Node-red-node-ui-microphone](https://discourse.nodered.org/t/node-red-node-ui-microphone/82956)

<div class="topic-metadata">

**Author:** [@T3chn0](https://discourse.nodered.org/u/T3chn0)\
**Replies:** 1\
**Last updated:** [17 November 2023 16:46 UTC](https://discourse.nodered.org/t/node-red-node-ui-microphone/82956 "2023-11-17T16:46:53Z")

</div>

Hello, i want to modify a this node so i can get called with an input node instead doing click on the dashboard, i want to call it from the javascript but i cant, what i am trying is: node.on('input', function(msg, sen…

---

## [Change my button background color](https://discourse.nodered.org/t/change-my-button-background-color/82973)

<div class="topic-metadata">

**Author:** [@pepe2](https://discourse.nodered.org/u/pepe2)\
**Replies:** 2\
**Last updated:** [17 November 2023 16:46 UTC](https://discourse.nodered.org/t/change-my-button-background-color/82973 "2023-11-17T16:46:29Z")

</div>

Hi, I like to change my background color of my button on a dashboard, depending of the state of a global variable. It has to look like =\> {{global.get("speelOverhevel" ) == true? 'green' : 'red'}} But that is not worki…

---

## [Sending HTML Email](https://discourse.nodered.org/t/sending-html-email/1084)

<div class="topic-metadata">

**Author:** [@dskilton](https://discourse.nodered.org/u/dskilton)\
**Replies:** 5\
**Last updated:** [17 November 2023 16:12 UTC](https://discourse.nodered.org/t/sending-html-email/1084 "2023-11-17T16:12:58Z")

</div>

I would like to use the node-red-contrib-email-out node, or something similar, to send an HTML email that contains an image in the body of the email based on a triggered event. I have read the documentation on how to se…

---

## [Hello! I'm trying to extract the data from an sql server into a table from my dashboard but i dont get the table filled. My version of node-red is v3.0.2, Windows, and i'm running a Docker](https://discourse.nodered.org/t/hello-im-trying-to-extract-the-data-from-an-sql-server-into-a-table-from-my-dashboard-but-i-dont-get-the-table-filled-my-version-of-node-red-is-v3-0-2-windows-and-im-running-a-docker/82910)

<div class="topic-metadata">

**Author:** [@JanIwnl](https://discourse.nodered.org/u/JanIwnl)\
**Replies:** 16\
**Last updated:** [17 November 2023 15:51 UTC](https://discourse.nodered.org/t/hello-im-trying-to-extract-the-data-from-an-sql-server-into-a-table-from-my-dashboard-but-i-dont-get-the-table-filled-my-version-of-node-red-is-v3-0-2-windows-and-im-running-a-docker/82910 "2023-11-17T15:51:24Z")

</div>

---

## [MySQL COUNT with Node-Red](https://discourse.nodered.org/t/mysql-count-with-node-red/82832)

<div class="topic-metadata">

**Author:** [@PhilLu1](https://discourse.nodered.org/u/PhilLu1)\
**Replies:** 33\
**Last updated:** [17 November 2023 13:57 UTC](https://discourse.nodered.org/t/mysql-count-with-node-red/82832 "2023-11-17T13:57:29Z")

</div>

Hello, I try to use COUNT with Node-Red on a MySQL DB. Query is perfectly working on MySQL PHP My Admin... SELECT COUNT(\*) AS nombre FROM \`loinc\_be\_fr\_linguisticvariant\` WHERE \`SYSTEM\` LIKE 'Isolat' AND \`CLASS\` LIKE '…

---

## [Mongodb4 connection issue](https://discourse.nodered.org/t/mongodb4-connection-issue/82966)

<div class="topic-metadata">

**Author:** [@googizzy](https://discourse.nodered.org/u/googizzy)\
**Replies:** 0\
**Last updated:** [17 November 2023 13:16 UTC](https://discourse.nodered.org/t/mongodb4-connection-issue/82966 "2023-11-17T13:16:59Z")

</div>

I have set up my mongodb4 connection as follows: As the documentation says: URI - Define your own connection string in URI format. Read the docs: Connection String in URI Format Which I got from my Mongo Hosted in…

---

## [Node red securite](https://discourse.nodered.org/t/node-red-securite/82964)

<div class="topic-metadata">

**Author:** [@alismont](https://discourse.nodered.org/u/alismont)\
**Replies:** 1\
**Last updated:** [17 November 2023 11:33 UTC](https://discourse.nodered.org/t/node-red-securite/82964 "2023-11-17T11:33:46Z")

</div>

NODE RED I installed node-red on the raspberry pi400. Installation ok I open a browser pop to start node-red editor. The system asks me for a username and password. I don't know what to put in the USERNAME & PW field…

---

## [Failing to add/start Node Red in PM2](https://discourse.nodered.org/t/failing-to-add-start-node-red-in-pm2/82891)

<div class="topic-metadata">

**Author:** [@Mikee1234K](https://discourse.nodered.org/u/Mikee1234K)\
**Replies:** 14\
**Last updated:** [17 November 2023 11:18 UTC](https://discourse.nodered.org/t/failing-to-add-start-node-red-in-pm2/82891 "2023-11-17T11:18:34Z")

</div>

I used to start NR with PM2, but had to reinstall everything after a SSD crash. I followed the tuorials, but its not working. I am running Win11, installed NR via npm. I had NR in PM2, but it didnt start. I deleted it to…

---

## [Timestamp synchroniziation in database](https://discourse.nodered.org/t/timestamp-synchroniziation-in-database/63136)

<div class="topic-metadata">

**Author:** [@ALIEN](https://discourse.nodered.org/u/ALIEN)\
**Replies:** 6\
**Last updated:** [17 November 2023 12:09 UTC](https://discourse.nodered.org/t/timestamp-synchroniziation-in-database/63136 "2023-11-17T12:09:56Z")

</div>

Dear Friends, Hi, recently I am trying to develop a data acquisition platform and its already done but I have an issue with database! The problem is despite the fact that Modbus reader fetching data every 2 second and t…

---

## [Image display on dashboard](https://discourse.nodered.org/t/image-display-on-dashboard/82937)

<div class="topic-metadata">

**Author:** [@MachineInsights](https://discourse.nodered.org/u/MachineInsights)\
**Replies:** 6\
**Last updated:** [17 November 2023 10:55 UTC](https://discourse.nodered.org/t/image-display-on-dashboard/82937 "2023-11-17T10:55:58Z")

</div>

Hi all, I am hoping this is easy but it's driving me insane. I am trying to show an image on my dashboard from a template node and have updated the settings file with httpStatic line, I've added the image to the referen…

---

## [~/.npm folder missing - Permissions error updating Nodes](https://discourse.nodered.org/t/npm-folder-missing-permissions-error-updating-nodes/82938)

<div class="topic-metadata">

**Author:** [@mudwalker](https://discourse.nodered.org/u/mudwalker)\
**Replies:** 6\
**Last updated:** [17 November 2023 10:01 UTC](https://discourse.nodered.org/t/npm-folder-missing-permissions-error-updating-nodes/82938 "2023-11-17T10:01:30Z")

</div>

Hi Folks, Looking for some help on my 'production system'. I have tried to update my Nodes using Manage Palette and I get the errors below. I can't find the home/pi/.npm directory. I am pretty sure that I updated my …

---

## [What timer node do I need to trigger at every 5 min past the hour](https://discourse.nodered.org/t/what-timer-node-do-i-need-to-trigger-at-every-5-min-past-the-hour/82935)

<div class="topic-metadata">

**Author:** [@cymplecy](https://discourse.nodered.org/u/cymplecy)\
**Replies:** 9\
**Last updated:** [17 November 2023 09:46 UTC](https://discourse.nodered.org/t/what-timer-node-do-i-need-to-trigger-at-every-5-min-past-the-hour/82935 "2023-11-17T09:46:21Z")

</div>

i.e every 5 mins on the clock 5 minute markers

---

## [Include other Widgets into a UI template](https://discourse.nodered.org/t/include-other-widgets-into-a-ui-template/82939)

<div class="topic-metadata">

**Author:** [@olab](https://discourse.nodered.org/u/olab)\
**Replies:** 3\
**Last updated:** [17 November 2023 08:59 UTC](https://discourse.nodered.org/t/include-other-widgets-into-a-ui-template/82939 "2023-11-17T08:59:21Z")

</div>

Hi folks, I would like to create a ui\_template that contains regular HTML table but also an ui\_gauge node. The reason for this is that the template is to be duplicated multiple times to my dashboard and all of them sho…

---

## [Centering Text in template (CSS)](https://discourse.nodered.org/t/centering-text-in-template-css/82958)

<div class="topic-metadata">

**Author:** [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Replies:** 3\
**Last updated:** [17 November 2023 08:07 UTC](https://discourse.nodered.org/t/centering-text-in-template-css/82958 "2023-11-17T08:07:12Z")

</div>

How to center a text in a template node ? I am sorry for asking, but the forum search could not help me, since i am totally a noob with css/html appreciate any help. \[{"id":"af8205cd532ef336","type":"ui\_template","z":"…

[Previous page](https://discourse.nodered.org/latest.md?page=272)

[Next page](https://discourse.nodered.org/latest.md?page=274)