# Latest

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

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

**Page:** 775

---

## [How To get Variable name as value then store in in mysql dataabse](https://discourse.nodered.org/t/how-to-get-variable-name-as-value-then-store-in-in-mysql-dataabse/48229)

<div class="topic-metadata">

**Author:** [@muhammad\_mikail\_j](https://discourse.nodered.org/u/muhammad_mikail_j)\
**Replies:** 2\
**Last updated:** [14 July 2021 05:36 UTC](https://discourse.nodered.org/t/how-to-get-variable-name-as-value-then-store-in-in-mysql-dataabse/48229 "2021-07-14T05:36:55Z")

</div>

Hi All, Nice to connect with people in this forum. I would like to make data logger with flow below, PLC (Data source) -\> Node-Red -\> MySql database. I have store value to database with function below : msg.topic = …

---

## [Some suggestions that will can help reading visually the flow](https://discourse.nodered.org/t/some-suggestions-that-will-can-help-reading-visually-the-flow/48334)

<div class="topic-metadata">

**Author:** [@nored](https://discourse.nodered.org/u/nored)\
**Replies:** 4\
**Last updated:** [13 July 2021 21:01 UTC](https://discourse.nodered.org/t/some-suggestions-that-will-can-help-reading-visually-the-flow/48334 "2021-07-13T21:01:32Z")

</div>

Hi i just have some suggestions, if its possible to add other point on top and buttom to wire the nodes , this will help getting nodes vertical also, which in my opinion will be more visually helpfull because it get me…

---

## [Using flow variable in change node to set HTTP request URL](https://discourse.nodered.org/t/using-flow-variable-in-change-node-to-set-http-request-url/48378)

<div class="topic-metadata">

**Author:** [@Nathan](https://discourse.nodered.org/u/Nathan)\
**Replies:** 10\
**Last updated:** [13 July 2021 20:36 UTC](https://discourse.nodered.org/t/using-flow-variable-in-change-node-to-set-http-request-url/48378 "2021-07-13T20:36:02Z")

</div>

Hi there, I'm trying to set a URL dynamically by: Setting a flow variable in a function: flow.set(sendURL,"https://myURL.com/api/"); Accessing the variable in the Change node: Set msg.url to flow.myVar Passing that …

---

## [JavaScript Editor Font Size](https://discourse.nodered.org/t/javascript-editor-font-size/48380)

<div class="topic-metadata">

**Author:** [@ryan1998](https://discourse.nodered.org/u/ryan1998)\
**Replies:** 1\
**Last updated:** [13 July 2021 19:58 UTC](https://discourse.nodered.org/t/javascript-editor-font-size/48380 "2021-07-13T19:58:54Z")

</div>

It would be great if it were possible to increase the font size in the JavaScript editor. Any help would be appreciated.

---

## [Updating dashboard on a raspi zero](https://discourse.nodered.org/t/updating-dashboard-on-a-raspi-zero/48367)

<div class="topic-metadata">

**Author:** [@alexander77](https://discourse.nodered.org/u/alexander77)\
**Replies:** 5\
**Last updated:** [13 July 2021 18:32 UTC](https://discourse.nodered.org/t/updating-dashboard-on-a-raspi-zero/48367 "2021-07-13T18:32:04Z")

</div>

It fails with the following message: 2021-07-13T13:44:18.530Z npm install --no-audit --no-update-notifier --no-fund --save --save-prefix=~ --production node-red-dashboard@2.30.0 2021-07-13T13:44:51.546Z \[err\] npm 2021…

---

## [Ui\_dropdown no reaction to input payload if passing through](https://discourse.nodered.org/t/ui-dropdown-no-reaction-to-input-payload-if-passing-through/38329)

<div class="topic-metadata">

**Author:** [@philbowles](https://discourse.nodered.org/u/philbowles)\
**Replies:** 5\
**Last updated:** [13 July 2021 16:32 UTC](https://discourse.nodered.org/t/ui-dropdown-no-reaction-to-input-payload-if-passing-through/38329 "2021-07-13T16:32:12Z")

</div>

NODE-RED: v1.2.6 on Raspi Model 3B running Buster ui\_dashboard version: 2.26.1 Documentation says: " Setting msg.payload will pre-select the value in the dropdown." Nowehere can I find the fact that this only works i…

---

## [Connect to my Weidmuller over Internet](https://discourse.nodered.org/t/connect-to-my-weidmuller-over-internet/47526)

<div class="topic-metadata">

**Author:** [@RobertG](https://discourse.nodered.org/u/RobertG)\
**Replies:** 4\
**Last updated:** [13 July 2021 16:31 UTC](https://discourse.nodered.org/t/connect-to-my-weidmuller-over-internet/47526 "2021-07-13T16:31:25Z")

</div>

Hey, I have made an dashboard to my weidmuller UC20-WL2000-AC, and can control it locally really good. But would really like to open it up threw my phone. How would i solve this? With mqtt protocol?

---

## [Mysql query set correct table name without ''](https://discourse.nodered.org/t/mysql-query-set-correct-table-name-without/48355)

<div class="topic-metadata">

**Author:** [@ketpa](https://discourse.nodered.org/u/ketpa)\
**Replies:** 2\
**Last updated:** [13 July 2021 15:26 UTC](https://discourse.nodered.org/t/mysql-query-set-correct-table-name-without/48355 "2021-07-13T15:26:29Z")

</div>

I want update mysql table Inside function: msg.payload = \['harm', 'day', 'val', 1\]; msg.topic="UPDATE ? SET day=?,val=? WHERE id=?" ; return msg; How to put string 'harm' like harm not 'harm' because it cause probl…

---

## [Question: Creating a subflow for dynamic accessing a message (one of a given set)](https://discourse.nodered.org/t/question-creating-a-subflow-for-dynamic-accessing-a-message-one-of-a-given-set/48359)

<div class="topic-metadata">

**Author:** [@lostbits](https://discourse.nodered.org/u/lostbits)\
**Replies:** 1\
**Last updated:** [13 July 2021 13:49 UTC](https://discourse.nodered.org/t/question-creating-a-subflow-for-dynamic-accessing-a-message-one-of-a-given-set/48359 "2021-07-13T13:49:39Z")

</div>

Hey, I am using a subflow to count messages. Since I want to do it more generic, I currently addet an InputPattern via environment.. I do the following: which is working like this: The SubFlow detects node Objec…

---

## [Developing a business application in Node-Red](https://discourse.nodered.org/t/developing-a-business-application-in-node-red/48360)

<div class="topic-metadata">

**Author:** [@nygma2004](https://discourse.nodered.org/u/nygma2004)\
**Replies:** 0\
**Last updated:** [13 July 2021 13:38 UTC](https://discourse.nodered.org/t/developing-a-business-application-in-node-red/48360 "2021-07-13T13:38:22Z")

</div>

I am not doing software development as a profession. It was a long time I used any generic framework and time to learn something new is few and far between. Still, I was thinking if developing a business application in …

---

## [Sharing with non-technical friends and coworkers](https://discourse.nodered.org/t/sharing-with-non-technical-friends-and-coworkers/48356)

<div class="topic-metadata">

**Author:** [@shnydercom](https://discourse.nodered.org/u/shnydercom)\
**Replies:** 0\
**Last updated:** [13 July 2021 12:58 UTC](https://discourse.nodered.org/t/sharing-with-non-technical-friends-and-coworkers/48356 "2021-07-13T12:58:40Z")

</div>

Hi, at my previous job I tried to convince my co-developers to use more nocode or low-code tools, but wasn't quite successful. I wanted to share with non-technical people or data analysts how a part of the product works.…

---

## [Error while using FTP from Node RED and Filezilla](https://discourse.nodered.org/t/error-while-using-ftp-from-node-red-and-filezilla/48210)

<div class="topic-metadata">

**Author:** [@KrishnanRavichandran](https://discourse.nodered.org/u/KrishnanRavichandran)\
**Replies:** 23\
**Last updated:** [13 July 2021 12:09 UTC](https://discourse.nodered.org/t/error-while-using-ftp-from-node-red-and-filezilla/48210 "2021-07-13T12:09:21Z")

</div>

I am trying to send some Files from a remote site using the FTP and accessing it through the Filezilla. I have a strange issue: Initially I had 4 files as a csv data sent and it was working fine. But, later I added som…

---

## [Bme280 Node only two decimal places](https://discourse.nodered.org/t/bme280-node-only-two-decimal-places/47891)

<div class="topic-metadata">

**Author:** [@KirchnerAlex](https://discourse.nodered.org/u/KirchnerAlex)\
**Replies:** 13\
**Last updated:** [13 July 2021 11:51 UTC](https://discourse.nodered.org/t/bme280-node-only-two-decimal-places/47891 "2021-07-13T11:51:49Z")

</div>

I use the node node-red-contrib-bme280. The temperature is output with two decimal places only. Where can I change that the full value, so all decimal places are output? I can't find it in the code. Can someone help me? …

---

## [Compare payload value to last received payload](https://discourse.nodered.org/t/compare-payload-value-to-last-received-payload/48351)

<div class="topic-metadata">

**Author:** [@JoshuaG](https://discourse.nodered.org/u/JoshuaG)\
**Replies:** 6\
**Last updated:** [13 July 2021 11:00 UTC](https://discourse.nodered.org/t/compare-payload-value-to-last-received-payload/48351 "2021-07-13T11:00:26Z")

</div>

I receive a payload value that rises every second, after a while it'll stop for a moment and reset to 0 again. What I want to do is capture that max value. I'm struggling to hold onto the last value to compare it again…

---

## [Node red ncd-red-mcp23008 fails install](https://discourse.nodered.org/t/node-red-ncd-red-mcp23008-fails-install/48269)

<div class="topic-metadata">

**Author:** [@Rob](https://discourse.nodered.org/u/Rob)\
**Replies:** 18\
**Last updated:** [13 July 2021 09:44 UTC](https://discourse.nodered.org/t/node-red-ncd-red-mcp23008-fails-install/48269 "2021-07-13T09:44:08Z")

</div>

Hi all, I'm trying to install this node but it's failing and I don't see the reason....anyone smarter than me is seeing it? If so, THANKS!!!!! Here is the log: 2021-07-11T14:06:21.014Z npm install --no-audit --no-upd…

---

## [Light on by opening the door](https://discourse.nodered.org/t/light-on-by-opening-the-door/48060)

<div class="topic-metadata">

**Author:** [@Wurmi](https://discourse.nodered.org/u/Wurmi)\
**Replies:** 16\
**Last updated:** [13 July 2021 07:57 UTC](https://discourse.nodered.org/t/light-on-by-opening-the-door/48060 "2021-07-13T07:57:22Z")

</div>

I have a little logic problem. I want to turn on the light, when someone is opening the door. On the busmonitor i receive the msg from the binary input, if the door is open. In Node-red i get also a true on the debu…

---

## [Set dynamic password for MSSQL node](https://discourse.nodered.org/t/set-dynamic-password-for-mssql-node/48082)

<div class="topic-metadata">

**Author:** [@sathishkumarc14](https://discourse.nodered.org/u/sathishkumarc14)\
**Replies:** 3\
**Last updated:** [13 July 2021 06:08 UTC](https://discourse.nodered.org/t/set-dynamic-password-for-mssql-node/48082 "2021-07-13T06:08:40Z")

</div>

How to set dynamic user name and password for MSSQL PLUS CN NODE? Is there any possibility? Whenever new deployment happens, we have to update the user name and password for database node.

---

## [Where did my palette go? (How to get it back)](https://discourse.nodered.org/t/where-did-my-palette-go-how-to-get-it-back/48340)

<div class="topic-metadata">

**Author:** [@SoggyGeek](https://discourse.nodered.org/u/SoggyGeek)\
**Replies:** 3\
**Last updated:** [13 July 2021 02:09 UTC](https://discourse.nodered.org/t/where-did-my-palette-go-how-to-get-it-back/48340 "2021-07-13T02:09:02Z")

</div>

Have been using Node Red for awhile. Not a total noob. But can't figure this out. Normally, the palette where you select a new node for your flow, is along the left edge of the node-red flows screen. I was using a lap…

---

## [How to use the Aedes MQTT broker?](https://discourse.nodered.org/t/how-to-use-the-aedes-mqtt-broker/48201)

<div class="topic-metadata">

**Author:** [@jktan](https://discourse.nodered.org/u/jktan)\
**Replies:** 37\
**Last updated:** [13 July 2021 00:43 UTC](https://discourse.nodered.org/t/how-to-use-the-aedes-mqtt-broker/48201 "2021-07-13T00:43:24Z")

</div>

How does one use the Aedes MQTT broker node with the MQTT-out node? I have googled and found a few pages which basically show the Aedes node just standing alone or linked to a Debug node. Have done this, but my measurem…

---

## [Can't get req/res Info after onvif node call](https://discourse.nodered.org/t/cant-get-req-res-info-after-onvif-node-call/48327)

<div class="topic-metadata">

**Author:** [@jamessantoya26](https://discourse.nodered.org/u/jamessantoya26)\
**Replies:** 7\
**Last updated:** [12 July 2021 22:03 UTC](https://discourse.nodered.org/t/cant-get-req-res-info-after-onvif-node-call/48327 "2021-07-12T22:03:47Z")

</div>

Hi guys, I am trying to resolve the request call that I make in node-red, and I am executing the onvif-discovery call to get information from the cameras, but when the node responds, the request information does not exi…

---

## [How to disgard NaN messages](https://discourse.nodered.org/t/how-to-disgard-nan-messages/48329)

<div class="topic-metadata">

**Author:** [@MaxSchaaper](https://discourse.nodered.org/u/MaxSchaaper)\
**Replies:** 5\
**Last updated:** [12 July 2021 20:45 UTC](https://discourse.nodered.org/t/how-to-disgard-nan-messages/48329 "2021-07-12T20:45:33Z")

</div>

A readout of my energy Smart meter gives me different values. Sometimes it gives a NaN value and sometimes the real value of the Gas-meter. How do I change my fow to disguard the NaN values and only let the real values p…

---

## [Is it possible to send data from ui-form to a table?](https://discourse.nodered.org/t/is-it-possible-to-send-data-from-ui-form-to-a-table/48336)

<div class="topic-metadata">

**Author:** [@Jackob25](https://discourse.nodered.org/u/Jackob25)\
**Replies:** 7\
**Last updated:** [12 July 2021 20:37 UTC](https://discourse.nodered.org/t/is-it-possible-to-send-data-from-ui-form-to-a-table/48336 "2021-07-12T20:37:32Z")

</div>

Is it possible to use the ui-form node to put data into a table of some kind? i'm trying to get a leader-board type of thing working where I can input the information and it go right into the table but I'm not sure what …

---

## [How to tackle this one](https://discourse.nodered.org/t/how-to-tackle-this-one/48031)

<div class="topic-metadata">

**Author:** [@craigcurtin](https://discourse.nodered.org/u/craigcurtin)\
**Replies:** 23\
**Last updated:** [12 July 2021 20:27 UTC](https://discourse.nodered.org/t/how-to-tackle-this-one/48031 "2021-07-12T20:27:06Z")

</div>

Guys, When my heatpump is in standby mode (i.e not water being pumped through it) - one of the registers (DPS ids) is updated on a 30 second basis and flips between two values. What would be the best way to capture thi…

---

## [Music from a file](https://discourse.nodered.org/t/music-from-a-file/48335)

<div class="topic-metadata">

**Author:** [@Jackob25](https://discourse.nodered.org/u/Jackob25)\
**Replies:** 1\
**Last updated:** [12 July 2021 20:11 UTC](https://discourse.nodered.org/t/music-from-a-file/48335 "2021-07-12T20:11:42Z")

</div>

I'm not sure the best way to make a system that pauses, plays and restarts music from a sound file that's on the machine. This is what I have so far and I can't get it to work... I have scrolled through and keep finding …

---

## [Date picker output is one day ahead](https://discourse.nodered.org/t/date-picker-output-is-one-day-ahead/48250)

<div class="topic-metadata">

**Author:** [@davidz](https://discourse.nodered.org/u/davidz)\
**Replies:** 12\
**Last updated:** [12 July 2021 16:19 UTC](https://discourse.nodered.org/t/date-picker-output-is-one-day-ahead/48250 "2021-07-12T16:19:41Z")

</div>

The date picker output on the dashboard is exactly one day ahead. Is this intentional or a bug? For example, if one chooses "7/10/2021" from the date picker, then the output is "7/11/2021". Here is the test flow. \[{"id…

---

## [Create a delay to stabilze a switch](https://discourse.nodered.org/t/create-a-delay-to-stabilze-a-switch/48304)

<div class="topic-metadata">

**Author:** [@nightmare1](https://discourse.nodered.org/u/nightmare1)\
**Replies:** 3\
**Last updated:** [12 July 2021 15:58 UTC](https://discourse.nodered.org/t/create-a-delay-to-stabilze-a-switch/48304 "2021-07-12T15:58:02Z")

</div>

Thanks in advance im just new to Node Red. Its hard to give this a title, but what i have is a 4 switches controlled by heartrate. but i only want to change the switch once it has been within a range for 5 seconds In …

---

## [Different forum posts shown at top on Android vs WIndows](https://discourse.nodered.org/t/different-forum-posts-shown-at-top-on-android-vs-windows/48321)

<div class="topic-metadata">

**Author:** [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Replies:** 1\
**Last updated:** [12 July 2021 15:15 UTC](https://discourse.nodered.org/t/different-forum-posts-shown-at-top-on-android-vs-windows/48321 "2021-07-12T15:15:47Z")

</div>

PC and Android both running Firefox and visiting discourse.nodered.org, showing "Latest". On the phone "Latest" is a dropdown. On PC "all categories" is a drop down. On my PC I see 2 pinned posts: "How to share code or…

---

## [Searhing nodered.org](https://discourse.nodered.org/t/searhing-nodered-org/48320)

<div class="topic-metadata">

**Author:** [@eddee54455](https://discourse.nodered.org/u/eddee54455)\
**Replies:** 2\
**Last updated:** [12 July 2021 15:13 UTC](https://discourse.nodered.org/t/searhing-nodered-org/48320 "2021-07-12T15:13:15Z")

</div>

A really dumb question..... I have been wanting to search https://nodered.org/ for help, particularly the docs and tutorials sections, where I would like to lookup syntax of commands/examples etc... I cannot seem to fi…

---

## [Simple Password Authentication](https://discourse.nodered.org/t/simple-password-authentication/48313)

<div class="topic-metadata">

**Author:** [@Apple](https://discourse.nodered.org/u/Apple)\
**Replies:** 16\
**Last updated:** [12 July 2021 14:21 UTC](https://discourse.nodered.org/t/simple-password-authentication/48313 "2021-07-12T14:21:38Z")

</div>

Hi all hope all is well. I've setup a simple user/password authentication receiving stored names a txt file and passwords from a separate txt file for authentication agaisnt the user's input. I'm struggling to figure o…

---

## [Modbus RTU nodes with DE and RE control](https://discourse.nodered.org/t/modbus-rtu-nodes-with-de-and-re-control/48319)

<div class="topic-metadata">

**Author:** [@quemf](https://discourse.nodered.org/u/quemf)\
**Replies:** 0\
**Last updated:** [12 July 2021 13:56 UTC](https://discourse.nodered.org/t/modbus-rtu-nodes-with-de-and-re-control/48319 "2021-07-12T13:56:45Z")

</div>

Hi everyone, I am trying to communicate between an Arduino Leonardo based PLC: https://www.industrialshields.com/web/content?model=ir.attachment&field=datas&id=262929& and a Raspberry based PLC: https://www.industrialsh…

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

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