# Latest

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

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

**Page:** 445

---

## [How to display an array as graph/chart](https://discourse.nodered.org/t/how-to-display-an-array-as-graph-chart/71808)

<div class="topic-metadata">

**Author:** [@Becker](https://discourse.nodered.org/u/Becker)\
**Replies:** 12\
**Last updated:** [7 December 2022 20:34 UTC](https://discourse.nodered.org/t/how-to-display-an-array-as-graph-chart/71808 "2022-12-07T20:34:29Z")

</div>

Hi, I get different forecast: Tibber and Solecast. example: \[{"total":0.3723,"energy":0.2646,"tax":0.1077,"startsAt":"2022-12-07T00:00:00.000+01:00","currency":"EUR","level":"CHEAP"},{"total":0.3379,"energy":0.2357,"t…

---

## [How to process any messaging queues synchronously in node-red](https://discourse.nodered.org/t/how-to-process-any-messaging-queues-synchronously-in-node-red/71805)

<div class="topic-metadata">

**Author:** [@shubham-credence](https://discourse.nodered.org/u/shubham-credence)\
**Replies:** 11\
**Last updated:** [7 December 2022 16:41 UTC](https://discourse.nodered.org/t/how-to-process-any-messaging-queues-synchronously-in-node-red/71805 "2022-12-07T16:41:36Z")

</div>

Hi, I'm using Node-RED version: v1.3.7 and Node.js version: v14.17.5 . Is their any packages or node-red core nodes exists in node-red which process AQMP messages synchronously. Because i am facing issues, while proce…

---

## [Noob - Reading serial - splitting correctly](https://discourse.nodered.org/t/noob-reading-serial-splitting-correctly/71803)

<div class="topic-metadata">

**Author:** [@boydo](https://discourse.nodered.org/u/boydo)\
**Replies:** 6\
**Last updated:** [7 December 2022 16:36 UTC](https://discourse.nodered.org/t/noob-reading-serial-splitting-correctly/71803 "2022-12-07T16:36:30Z")

</div>

New to node read so go easy!! I am trying to read serial connection. When I output to debug, I get the following. The message payload I am after is the 225 chars starting ts1 etc.. How do I setup the serial connecti…

---

## [Terminate library connection from httpAdminMiddleware](https://discourse.nodered.org/t/terminate-library-connection-from-httpadminmiddleware/71825)

<div class="topic-metadata">

**Author:** [@mw75](https://discourse.nodered.org/u/mw75)\
**Replies:** 0\
**Last updated:** [7 December 2022 15:16 UTC](https://discourse.nodered.org/t/terminate-library-connection-from-httpadminmiddleware/71825 "2022-12-07T15:16:24Z")

</div>

Hi community, i've connected node-red to an OIDC provider and assign permissions by mapping roles to the username. I have two roles: flow-admin and flow-designer. They only differ in the capability of reading and writin…

---

## [Trying to get 'require' to work but no result](https://discourse.nodered.org/t/trying-to-get-require-to-work-but-no-result/71819)

<div class="topic-metadata">

**Author:** [@henkkas](https://discourse.nodered.org/u/henkkas)\
**Replies:** 5\
**Last updated:** [7 December 2022 14:46 UTC](https://discourse.nodered.org/t/trying-to-get-require-to-work-but-no-result/71819 "2022-12-07T14:46:33Z")

</div>

I am trying to get a third-party package to work. I first tried the example 'os', and I got it functional. Now I am trying to get the package 'node-dsmr' to function in a similar way. I installed the package in ~/.node…

---

## [Variable in HTTP GET URL makes the response wrong](https://discourse.nodered.org/t/variable-in-http-get-url-makes-the-response-wrong/71770)

<div class="topic-metadata">

**Author:** [@network\_potato](https://discourse.nodered.org/u/network_potato)\
**Replies:** 7\
**Last updated:** [7 December 2022 14:12 UTC](https://discourse.nodered.org/t/variable-in-http-get-url-makes-the-response-wrong/71770 "2022-12-07T14:12:37Z")

</div>

Really bad title of the post but I don't know how else to explain it :sweat\_smile: I have been using variables in the URL field of my HTTP Request nodes for months without issue, but today I tried something new. I am p…

---

## [Node-red-node-serialport, can't get data, only connected](https://discourse.nodered.org/t/node-red-node-serialport-cant-get-data-only-connected/71779)

<div class="topic-metadata">

**Author:** [@henkkas](https://discourse.nodered.org/u/henkkas)\
**Replies:** 11\
**Last updated:** [7 December 2022 12:51 UTC](https://discourse.nodered.org/t/node-red-node-serialport-cant-get-data-only-connected/71779 "2022-12-07T12:51:20Z")

</div>

I have a Raspbery pi3+ with debian 11. I want to connect with the P1 port of the smartmeter over USB port, so I tried with node-red-contrib-smartmeter package to connect with smartmeter. But it didn't work what so ever. …

---

## [Help to use a node-red-contrib-ui-etable](https://discourse.nodered.org/t/help-to-use-a-node-red-contrib-ui-etable/71783)

<div class="topic-metadata">

**Author:** [@joaoceresoli](https://discourse.nodered.org/u/joaoceresoli)\
**Replies:** 1\
**Last updated:** [7 December 2022 12:43 UTC](https://discourse.nodered.org/t/help-to-use-a-node-red-contrib-ui-etable/71783 "2022-12-07T12:43:48Z")

</div>

I am developing a solution for irrigation, I already have functional communication with the PLC, via RS232, but I want to create a simple interface to enter the irrigation schedules (there are 16 sectors and 32 irrigatio…

---

## [Query via Modbus TCP -\> MSSQL - zero values](https://discourse.nodered.org/t/query-via-modbus-tcp-mssql-zero-values/71785)

<div class="topic-metadata">

**Author:** [@MaaAR](https://discourse.nodered.org/u/MaaAR)\
**Replies:** 10\
**Last updated:** [7 December 2022 11:09 UTC](https://discourse.nodered.org/t/query-via-modbus-tcp-mssql-zero-values/71785 "2022-12-07T11:09:14Z")

</div>

Hello all, I have the following problem. I query my heat pump every 5 minutes via Modbus TCP. Then I take the values and make a join. After that I write them per INSERT command into a MSSQL database. For some time this…

---

## [How to get Https certificate to nodered with ip address](https://discourse.nodered.org/t/how-to-get-https-certificate-to-nodered-with-ip-address/71806)

<div class="topic-metadata">

**Author:** [@Swetha](https://discourse.nodered.org/u/Swetha)\
**Replies:** 1\
**Last updated:** [7 December 2022 11:05 UTC](https://discourse.nodered.org/t/how-to-get-https-certificate-to-nodered-with-ip-address/71806 "2022-12-07T11:05:52Z")

</div>

Hey, I’m trying secure the nodered version 3.0 and change http to https with the help of self signed certificates since its running in ip address. Issue: I’m able to access the https site with self signed x509 certifi…

---

## [Watch Node isnt watching outside when Nodered runs on docker](https://discourse.nodered.org/t/watch-node-isnt-watching-outside-when-nodered-runs-on-docker/71606)

<div class="topic-metadata">

**Author:** [@Josh](https://discourse.nodered.org/u/Josh)\
**Replies:** 3\
**Last updated:** [7 December 2022 07:04 UTC](https://discourse.nodered.org/t/watch-node-isnt-watching-outside-when-nodered-runs-on-docker/71606 "2022-12-07T07:04:49Z")

</div>

Hi Forum, I have a minimal watch node flow running on my nodered docker. I want the watch my local directory D:\\ for any change in file. But unfortunately my watch node isnt watching for any changes. Can anyone provide …

---

## [Notification Margin](https://discourse.nodered.org/t/notification-margin/71743)

<div class="topic-metadata">

**Author:** [@afafirmansyah](https://discourse.nodered.org/u/afafirmansyah)\
**Replies:** 2\
**Last updated:** [7 December 2022 00:53 UTC](https://discourse.nodered.org/t/notification-margin/71743 "2022-12-07T00:53:24Z")

</div>

How to give left and right margin? this happened after I updated ui-dashboard to version 3.2.3

---

## [Observation & Question about MQTT Node Timing](https://discourse.nodered.org/t/observation-question-about-mqtt-node-timing/71791)

<div class="topic-metadata">

**Author:** [@Buckskin](https://discourse.nodered.org/u/Buckskin)\
**Replies:** 6\
**Last updated:** [6 December 2022 23:10 UTC](https://discourse.nodered.org/t/observation-question-about-mqtt-node-timing/71791 "2022-12-06T23:10:56Z")

</div>

Before you all roll on the floor laughing I know that this observation has little impact in real life, but I wondered why it was happening. I was re-doing a small flow using a watt2kwhr node attached to an MQTT node and…

---

## [Settings.js Termux in android](https://discourse.nodered.org/t/settings-js-termux-in-android/8165)

<div class="topic-metadata">

**Author:** [@manueldiasmanuel](https://discourse.nodered.org/u/manueldiasmanuel)\
**Replies:** 5\
**Last updated:** [6 December 2022 21:47 UTC](https://discourse.nodered.org/t/settings-js-termux-in-android/8165 "2022-12-06T21:47:06Z")

</div>

Hi, I am using a script to start up node-red when the android systems boots up. I am trying to change the setting.js file but a don´t what is the path for the the right one. How to change the node-red setting.js file…

---

## [Updating multiple SQL records at once](https://discourse.nodered.org/t/updating-multiple-sql-records-at-once/71716)

<div class="topic-metadata">

**Author:** [@rbmgf7](https://discourse.nodered.org/u/rbmgf7)\
**Replies:** 5\
**Last updated:** [6 December 2022 19:28 UTC](https://discourse.nodered.org/t/updating-multiple-sql-records-at-once/71716 "2022-12-06T19:28:50Z")

</div>

Novice to NR and SQL. I'm doing a query where I pull columns of records (one unique) from a database. Then I do some simple math to the non-unique records and then return all of it to their respective record in SQL bas…

---

## [Ideas for Node Authoring: Auto-HTML Generation, Rendering Extra Info, Type-checking, Multiple Inputs](https://discourse.nodered.org/t/ideas-for-node-authoring-auto-html-generation-rendering-extra-info-type-checking-multiple-inputs/71315)

<div class="topic-metadata">

**Author:** [@jackcarey](https://discourse.nodered.org/u/jackcarey)\
**Replies:** 5\
**Last updated:** [6 December 2022 19:22 UTC](https://discourse.nodered.org/t/ideas-for-node-authoring-auto-html-generation-rendering-extra-info-type-checking-multiple-inputs/71315 "2022-12-06T19:22:27Z")

</div>

I'm writing this post to garner feedback on some ideas I have to improve the node authoring experience in NodeRED (not expecting any sort of implementation from anyone). Automatic HTML Generation Why: When creating node…

---

## [Export node red stored data to excel](https://discourse.nodered.org/t/export-node-red-stored-data-to-excel/71724)

<div class="topic-metadata">

**Author:** [@Johnson](https://discourse.nodered.org/u/Johnson)\
**Replies:** 12\
**Last updated:** [6 December 2022 19:06 UTC](https://discourse.nodered.org/t/export-node-red-stored-data-to-excel/71724 "2022-12-06T19:06:03Z")

</div>

I have a question regarding storing of data. I want to export the data stored in global context into an excel .I did some research and found a node called csv .But is it possible to get the start, stop and duration val…

---

## ["Connection lost" on a specific dashboard tab](https://discourse.nodered.org/t/connection-lost-on-a-specific-dashboard-tab/71780)

<div class="topic-metadata">

**Author:** [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Replies:** 2\
**Last updated:** [6 December 2022 19:04 UTC](https://discourse.nodered.org/t/connection-lost-on-a-specific-dashboard-tab/71780 "2022-12-06T19:04:48Z")

</div>

I currently have three dashboard tabs. One of them draws a chart with 4 lines using data from MySQL. When I switch to this tab using the dashboard hamburger menu: A mesage pops up "Connection lost" for a second. Same…

---

## [Pdf or picture slideshow](https://discourse.nodered.org/t/pdf-or-picture-slideshow/71662)

<div class="topic-metadata">

**Author:** [@denissanga](https://discourse.nodered.org/u/denissanga)\
**Replies:** 5\
**Last updated:** [6 December 2022 19:01 UTC](https://discourse.nodered.org/t/pdf-or-picture-slideshow/71662 "2022-12-06T19:01:11Z")

</div>

Hi all I would create a slides how popup in node red to open pdf files or images? This is possible?

---

## [Button name line break](https://discourse.nodered.org/t/button-name-line-break/19619)

<div class="topic-metadata">

**Author:** [@edje11](https://discourse.nodered.org/u/edje11)\
**Replies:** 8\
**Last updated:** [6 December 2022 17:26 UTC](https://discourse.nodered.org/t/button-name-line-break/19619 "2022-12-06T17:26:02Z")

</div>

If have a button that's made with the help of a ui\_template in the dashboard. That works perfect. \<md-button class="vibrate filled touched smallfont rounded" style={{msg.payload}} ng-click="send({payload: 'Click'})"\> …

---

## [Node-Red instance suddenly not starting on boot](https://discourse.nodered.org/t/node-red-instance-suddenly-not-starting-on-boot/71722)

<div class="topic-metadata">

**Author:** [@aams](https://discourse.nodered.org/u/aams)\
**Replies:** 23\
**Last updated:** [6 December 2022 16:42 UTC](https://discourse.nodered.org/t/node-red-instance-suddenly-not-starting-on-boot/71722 "2022-12-06T16:42:36Z")

</div>

I have a device that I am working on remotely, and do not have physical access to. I do have ability to interact with it via ip address. All has been working fine for the past several weeks, but today after a reboot, I a…

---

## [Icon Color - Output Text Box](https://discourse.nodered.org/t/icon-color-output-text-box/71734)

<div class="topic-metadata">

**Author:** [@Joaovitor](https://discourse.nodered.org/u/Joaovitor)\
**Replies:** 2\
**Last updated:** [6 December 2022 16:08 UTC](https://discourse.nodered.org/t/icon-color-output-text-box/71734 "2022-12-06T16:08:39Z")

</div>

I was working with Node-RED and had a little problem when adding icons to a text output node. With some research I solved my problems. Now I want to be able to define, in addition to the icon, the color of the icon, all…

---

## [Central Heating/Home Control schedule. Suggestions please](https://discourse.nodered.org/t/central-heating-home-control-schedule-suggestions-please/71552)

<div class="topic-metadata">

**Author:** [@mudwalker](https://discourse.nodered.org/u/mudwalker)\
**Replies:** 20\
**Last updated:** [6 December 2022 15:39 UTC](https://discourse.nodered.org/t/central-heating-home-control-schedule-suggestions-please/71552 "2022-12-06T15:39:36Z")

</div>

I have been thinking about this for (quite) a while, and getting nowhere fast. I am trying to move away from using a file with a temperature for each hour of the week (basically a .csv file) to a more readable format, i…

---

## [Call service data number](https://discourse.nodered.org/t/call-service-data-number/71772)

<div class="topic-metadata">

**Author:** [@dowermyr](https://discourse.nodered.org/u/dowermyr)\
**Replies:** 1\
**Last updated:** [6 December 2022 15:16 UTC](https://discourse.nodered.org/t/call-service-data-number/71772 "2022-12-06T15:16:38Z")

</div>

Hi! How do I set the payload to a data value number? Se below:

---

## [Conditional iptus for data from MQTT to inserst into a new database table](https://discourse.nodered.org/t/conditional-iptus-for-data-from-mqtt-to-inserst-into-a-new-database-table/71766)

<div class="topic-metadata">

**Author:** [@Deh89](https://discourse.nodered.org/u/Deh89)\
**Replies:** 1\
**Last updated:** [6 December 2022 14:50 UTC](https://discourse.nodered.org/t/conditional-iptus-for-data-from-mqtt-to-inserst-into-a-new-database-table/71766 "2022-12-06T14:50:15Z")

</div>

Hello community members, I'm not familiar with Node Red and javascript but I decided to start this challenge. I want to collect data from a MQTT and insert the data into a new posgresql database. This data has this st…

---

## [Problem connected MySQL](https://discourse.nodered.org/t/problem-connected-mysql/71729)

<div class="topic-metadata">

**Author:** [@Misiek](https://discourse.nodered.org/u/Misiek)\
**Replies:** 1\
**Last updated:** [6 December 2022 14:10 UTC](https://discourse.nodered.org/t/problem-connected-mysql/71729 "2022-12-06T14:10:18Z")

</div>

I have problem connected with my database server I use QNAP storage My Node Red installed in Docker MariaDb in sytem Qnap How config my flow mysql - IP adress my flow answer me --\> Error: connect ECONNREFUSED 127.…

---

## [Advice on how to approach my use case](https://discourse.nodered.org/t/advice-on-how-to-approach-my-use-case/71727)

<div class="topic-metadata">

**Author:** [@TomkinsG](https://discourse.nodered.org/u/TomkinsG)\
**Replies:** 4\
**Last updated:** [6 December 2022 13:47 UTC](https://discourse.nodered.org/t/advice-on-how-to-approach-my-use-case/71727 "2022-12-06T13:47:47Z")

</div>

I am working on a project with n (n is approx 9 in this case) wood working tools in a woodshop where each of them has a vacuum hose to suck away the sawdust. There is a central vacuum where the pipes return to through a…

---

## [Selectable appearance for node status](https://discourse.nodered.org/t/selectable-appearance-for-node-status/71751)

<div class="topic-metadata">

**Author:** [@michaelblight](https://discourse.nodered.org/u/michaelblight)\
**Replies:** 4\
**Last updated:** [6 December 2022 13:23 UTC](https://discourse.nodered.org/t/selectable-appearance-for-node-status/71751 "2022-12-06T13:23:01Z")

</div>

Some nodes, like those integrating Home Assistant, include a fairly lengthy status message. I seem to spend too much time arranging nodes so they don't overlap. In some cases this results in a creeping ladder of nodes, t…

---

## [Possible minor restructure of settings.js?](https://discourse.nodered.org/t/possible-minor-restructure-of-settings-js/71762)

<div class="topic-metadata">

**Author:** [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Replies:** 0\
**Last updated:** [6 December 2022 12:16 UTC](https://discourse.nodered.org/t/possible-minor-restructure-of-settings-js/71762 "2022-12-06T12:16:26Z")

</div>

In a previous release of Node-RED, Nick was kind enough to restructure the comments in settings.js to make it easier for people to read when using something like VSCode (being able to collapse long comments). My proposa…

---

## [Monitoring of change of value via colors](https://discourse.nodered.org/t/monitoring-of-change-of-value-via-colors/71705)

<div class="topic-metadata">

**Author:** [@HilalAbuSaleh](https://discourse.nodered.org/u/HilalAbuSaleh)\
**Replies:** 4\
**Last updated:** [6 December 2022 11:15 UTC](https://discourse.nodered.org/t/monitoring-of-change-of-value-via-colors/71705 "2022-12-06T11:15:25Z")

</div>

Hi all, I am sending values with MQTT broker and receiving them (with network: mqtt in-nodes) and showing them in the dashboard using text input...what i want is to monitor the values. the first value should get the def…

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

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