# Latest

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

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

**Page:** 1163

---

## [From data picker node to UTC](https://discourse.nodered.org/t/from-data-picker-node-to-utc/21026)

<div class="topic-metadata">

**Author:** [@NODE777](https://discourse.nodered.org/u/NODE777)\
**Replies:** 10\
**Last updated:** [6 February 2020 04:50 UTC](https://discourse.nodered.org/t/from-data-picker-node-to-utc/21026 "2020-02-06T04:50:42Z")

</div>

Hi I would need to convert to ms UTC from the selected data with the date selector node in order to make a sqlite query using the SELECT clause to my db. The db only includes the UTC time. I'm using the data picker no…

---

## [Execute java script file from node red](https://discourse.nodered.org/t/execute-java-script-file-from-node-red/21313)

<div class="topic-metadata">

**Author:** [@akhtar321h](https://discourse.nodered.org/u/akhtar321h)\
**Replies:** 4\
**Last updated:** [6 February 2020 04:31 UTC](https://discourse.nodered.org/t/execute-java-script-file-from-node-red/21313 "2020-02-06T04:31:06Z")

</div>

I want to execute a java script file from node red. how can i execute the file from node red. Please help me out for executing the file from node red.

---

## [Page Reload on value highlight](https://discourse.nodered.org/t/page-reload-on-value-highlight/21325)

<div class="topic-metadata">

**Author:** [@spyder0552](https://discourse.nodered.org/u/spyder0552)\
**Replies:** 1\
**Last updated:** [5 February 2020 21:27 UTC](https://discourse.nodered.org/t/page-reload-on-value-highlight/21325 "2020-02-05T21:27:20Z")

</div>

I have a text box (as an example) on the dashboard. When I use my mouse to highlight the contents of that text box (going to try to copy it), the entire dashboard site reloads and returns me to the starting tab. Anyone …

---

## [How to reset a MSSQL node from an error state](https://discourse.nodered.org/t/how-to-reset-a-mssql-node-from-an-error-state/21263)

<div class="topic-metadata">

**Author:** [@l.matera](https://discourse.nodered.org/u/l.matera)\
**Replies:** 10\
**Last updated:** [5 February 2020 21:22 UTC](https://discourse.nodered.org/t/how-to-reset-a-mssql-node-from-an-error-state/21263 "2020-02-05T21:22:12Z")

</div>

Hello, I have a problem with MSSQL nodes. When I can't connect to a database through an MSSQL node, after the timeout, the node goes into an "Failed to connect to ... in 15000 ms" error state. At the next attempt, tri…

---

## [Postgres and postgresdb nodes missing](https://discourse.nodered.org/t/postgres-and-postgresdb-nodes-missing/21323)

<div class="topic-metadata">

**Author:** [@Damorck](https://discourse.nodered.org/u/Damorck)\
**Replies:** 0\
**Last updated:** [5 February 2020 20:01 UTC](https://discourse.nodered.org/t/postgres-and-postgresdb-nodes-missing/21323 "2020-02-05T20:01:41Z")

</div>

Hi there I´ve been struggling with this and read related topics, but no one with a working solution. I´m on a rasbbery pi 4 model B, Node-RED v. 1.03 and Node.js v.12.14.1. After multiple reinstalls same errors occurs…

---

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

<div class="topic-metadata">

**Author:** [@pvanklink](https://discourse.nodered.org/u/pvanklink)\
**Replies:** 27\
**Last updated:** [5 February 2020 15:16 UTC](https://discourse.nodered.org/t/node-node-red-node-ui-list/20202 "2020-02-05T15:16:35Z")

</div>

I use node-red-node-ui-list within my dashboard, and i think its great and easy! Only thing i cant find is how to define a default for the specified list... Somebody else has got this working, or is this isnt available…

---

## [How to trigger a node-red flow from shell script process or from systemctl service](https://discourse.nodered.org/t/how-to-trigger-a-node-red-flow-from-shell-script-process-or-from-systemctl-service/21300)

<div class="topic-metadata">

**Author:** [@Jasper](https://discourse.nodered.org/u/Jasper)\
**Replies:** 10\
**Last updated:** [5 February 2020 14:19 UTC](https://discourse.nodered.org/t/how-to-trigger-a-node-red-flow-from-shell-script-process-or-from-systemctl-service/21300 "2020-02-05T14:19:24Z")

</div>

hello everyone, I would like to know if is possible trigger a node-red flow from a shell script process or from a systemctl service when the server is started up. Could you help me? Thank you in advance

---

## ["Reference error: require is not defined (line1,col 13)](https://discourse.nodered.org/t/reference-error-require-is-not-defined-line1-col-13/21310)

<div class="topic-metadata">

**Author:** [@akhtar321h](https://discourse.nodered.org/u/akhtar321h)\
**Replies:** 3\
**Last updated:** [5 February 2020 14:17 UTC](https://discourse.nodered.org/t/reference-error-require-is-not-defined-line1-col-13/21310 "2020-02-05T14:17:18Z")

</div>

var redis = require('redis');var client = redis.createClient(6379,'localhost'); //creates a new client client.on('connect', function() { console.log('connected'); }); client.hget("Hash","key", function(err, reply) { …

---

## [Node Red printing bank statement](https://discourse.nodered.org/t/node-red-printing-bank-statement/21294)

<div class="topic-metadata">

**Author:** [@sokomm](https://discourse.nodered.org/u/sokomm)\
**Replies:** 6\
**Last updated:** [5 February 2020 13:56 UTC](https://discourse.nodered.org/t/node-red-printing-bank-statement/21294 "2020-02-05T13:56:01Z")

</div>

Hello Is it possible in NR to make a flow that checks for mails whit PDF attached files and print them out? I have a dedicated email adres for bank statements. And a network attached printer. Thanks

---

## [Extract value from message](https://discourse.nodered.org/t/extract-value-from-message/21305)

<div class="topic-metadata">

**Author:** [@Abigor](https://discourse.nodered.org/u/Abigor)\
**Replies:** 3\
**Last updated:** [5 February 2020 13:40 UTC](https://discourse.nodered.org/t/extract-value-from-message/21305 "2020-02-05T13:40:30Z")

</div>

Hi, I'm trying to figure out how to extract the value from following message: "a100=16974\\x03" The value I want is the digits after the "=", but excluding the "\\x03". The value can be 0 - 65535 (2byte) I've tried to …

---

## [Node RED receive email](https://discourse.nodered.org/t/node-red-receive-email/21309)

<div class="topic-metadata">

**Author:** [@calimero](https://discourse.nodered.org/u/calimero)\
**Replies:** 0\
**Last updated:** [5 February 2020 13:26 UTC](https://discourse.nodered.org/t/node-red-receive-email/21309 "2020-02-05T13:26:28Z")

</div>

Hi, I'm using the node-red-node-email npm to receive emails from a mailbox. When set on automatically every 5 seconds it works fine. Unfortunatelly when I want to trigger it after a switch I get a connect error. Normal…

---

## [Copy to clipboard on client in Node-Red dashboard](https://discourse.nodered.org/t/copy-to-clipboard-on-client-in-node-red-dashboard/21306)

<div class="topic-metadata">

**Author:** [@Dalbyte](https://discourse.nodered.org/u/Dalbyte)\
**Replies:** 1\
**Last updated:** [5 February 2020 13:23 UTC](https://discourse.nodered.org/t/copy-to-clipboard-on-client-in-node-red-dashboard/21306 "2020-02-05T13:23:09Z")

</div>

\#Copy string to Clipboard on client I'm trying to build a button that automatically saves a dashboard string to the the clipboard of the client. That means that the client with an open dashboard should be able, to get …

---

## [Settings.js moved to root](https://discourse.nodered.org/t/settings-js-moved-to-root/21250)

<div class="topic-metadata">

**Author:** [@muggins](https://discourse.nodered.org/u/muggins)\
**Replies:** 12\
**Last updated:** [5 February 2020 11:31 UTC](https://discourse.nodered.org/t/settings-js-moved-to-root/21250 "2020-02-05T11:31:28Z")

</div>

Can anyone help please I have been backing up my node-red flows regularly, but something strange has changed and my backup files are now being ignored. I deleted settings.js and it is not being re-created. Does this me…

---

## [Issues with creating different projects](https://discourse.nodered.org/t/issues-with-creating-different-projects/21303)

<div class="topic-metadata">

**Author:** [@Unikumet](https://discourse.nodered.org/u/Unikumet)\
**Replies:** 1\
**Last updated:** [5 February 2020 10:44 UTC](https://discourse.nodered.org/t/issues-with-creating-different-projects/21303 "2020-02-05T10:44:52Z")

</div>

Hi, I'm currently trying to understand how to create separate node-red projects, but as of now I'm stuck in place. I have read the https://nodered.org/docs/user-guide/projects/ guide and followed the instructions up un…

---

## [Fetching data from redis database](https://discourse.nodered.org/t/fetching-data-from-redis-database/21292)

<div class="topic-metadata">

**Author:** [@Iliyas](https://discourse.nodered.org/u/Iliyas)\
**Replies:** 17\
**Last updated:** [5 February 2020 10:34 UTC](https://discourse.nodered.org/t/fetching-data-from-redis-database/21292 "2020-02-05T10:34:36Z")

</div>

Hello, I have some data in redis stored in database, how can I fetch that data from that redis in node-red please help me out...

---

## [Send several messages to a single MQTT output for a matrix display](https://discourse.nodered.org/t/send-several-messages-to-a-single-mqtt-output-for-a-matrix-display/21298)

<div class="topic-metadata">

**Author:** [@foskolo](https://discourse.nodered.org/u/foskolo)\
**Replies:** 5\
**Last updated:** [5 February 2020 10:16 UTC](https://discourse.nodered.org/t/send-several-messages-to-a-single-mqtt-output-for-a-matrix-display/21298 "2020-02-05T10:16:34Z")

</div>

Hi, I'm trying to send some values from sensors in my house (temperatures, door switches...) to a single line matrix display (1x8) which is connected to a Wemos (ESP8266). For single sensor all works fine. Now I want…

---

## [INA219 install woes](https://discourse.nodered.org/t/ina219-install-woes/21267)

<div class="topic-metadata">

**Author:** [@muggins](https://discourse.nodered.org/u/muggins)\
**Replies:** 11\
**Last updated:** [5 February 2020 09:32 UTC](https://discourse.nodered.org/t/ina219-install-woes/21267 "2020-02-05T09:32:41Z")

</div>

I have a fresh install of Buster + node red (RPI 3b+) and am building up my system again from scratch. All my modules install fine except for ...npm install ina219 It fails every time with error messages too nume…

---

## [HueMagic: How to query states (and get rid of a feedback-loop)?](https://discourse.nodered.org/t/huemagic-how-to-query-states-and-get-rid-of-a-feedback-loop/21301)

<div class="topic-metadata">

**Author:** [@Spampunk](https://discourse.nodered.org/u/Spampunk)\
**Replies:** 0\
**Last updated:** [5 February 2020 09:09 UTC](https://discourse.nodered.org/t/huemagic-how-to-query-states-and-get-rid-of-a-feedback-loop/21301 "2020-02-05T09:09:24Z")

</div>

Hello everybody, I have built a flow to increase the color temperature of a Hue group. The point is that this flow is increasing the ct automatically, somehow I have got a feedback. The HueMagic Group Node: The JS…

---

## [Node-js with Redis](https://discourse.nodered.org/t/node-js-with-redis/15708)

<div class="topic-metadata">

**Author:** [@Sanjaycoder-r](https://discourse.nodered.org/u/Sanjaycoder-r)\
**Replies:** 11\
**Last updated:** [5 February 2020 09:14 UTC](https://discourse.nodered.org/t/node-js-with-redis/15708 "2020-02-05T09:14:03Z")

</div>

var redis = context.global.get('redis'); client = redis.createClient(6379,'localhost'); var test=client.hget('hash key','hashtest 1', function(err, results) { if (err) { } else { // do something with results consol…

---

## [Zoom-in and Zoom-out of Charts](https://discourse.nodered.org/t/zoom-in-and-zoom-out-of-charts/21293)

<div class="topic-metadata">

**Author:** [@Henjoe](https://discourse.nodered.org/u/Henjoe)\
**Replies:** 2\
**Last updated:** [5 February 2020 09:08 UTC](https://discourse.nodered.org/t/zoom-in-and-zoom-out-of-charts/21293 "2020-02-05T09:08:01Z")

</div>

Dear Node-red Experts, Will it be possible that the Dashboard Chart can be Zoom-in and Zoom-out ?

---

## [Node red wont't start - erro](https://discourse.nodered.org/t/node-red-wontt-start-erro/21287)

<div class="topic-metadata">

**Author:** [@Bonzo](https://discourse.nodered.org/u/Bonzo)\
**Replies:** 0\
**Last updated:** [5 February 2020 00:34 UTC](https://discourse.nodered.org/t/node-red-wontt-start-erro/21287 "2020-02-05T00:34:41Z")

</div>

Hi all - new to the forum and node red. I installed node red last night and it a working fine. I wanted to use a gauge so tonight I installed node-red-dashboard. I must have done something wrong cause now I can't get …

---

## [Color-coded Debugger entries](https://discourse.nodered.org/t/color-coded-debugger-entries/21274)

<div class="topic-metadata">

**Author:** [@neil.lindberg](https://discourse.nodered.org/u/neil.lindberg)\
**Replies:** 2\
**Last updated:** [4 February 2020 19:06 UTC](https://discourse.nodered.org/t/color-coded-debugger-entries/21274 "2020-02-04T19:06:02Z")

</div>

I'd like to color code debug levels and/or put a flag to say, "My color." Scenario: QA guy is hitting NodeRED app while I'm trying to squash bugs reported by QA guy. However, in my testing I'm attempting to watch while …

---

## [Basic send data to firebase have problem](https://discourse.nodered.org/t/basic-send-data-to-firebase-have-problem/21144)

<div class="topic-metadata">

**Author:** [@Yortz](https://discourse.nodered.org/u/Yortz)\
**Replies:** 1\
**Last updated:** [4 February 2020 17:51 UTC](https://discourse.nodered.org/t/basic-send-data-to-firebase-have-problem/21144 "2020-02-04T17:51:07Z")

</div>

I try to send basic number to Firebase. I choose this node for send data to Firebase (https://flows.nodered.org/node/node-red-firebase) I just try to send bassic timestamp to my firebase and the error appear as shown in…

---

## [Problem with number converting from mqtt retained messages](https://discourse.nodered.org/t/problem-with-number-converting-from-mqtt-retained-messages/21077)

<div class="topic-metadata">

**Author:** [@Ragnarre](https://discourse.nodered.org/u/Ragnarre)\
**Replies:** 20\
**Last updated:** [4 February 2020 17:35 UTC](https://discourse.nodered.org/t/problem-with-number-converting-from-mqtt-retained-messages/21077 "2020-02-04T17:35:56Z")

</div>

Hello. Im having difficulties converting data i think. node named "juhtimine" does not output numbers as i think it should. I have no previous experiences with javascript. Heres the flow, i hope real programmers underst…

---

## [Run multiple projects at the same time](https://discourse.nodered.org/t/run-multiple-projects-at-the-same-time/4883)

<div class="topic-metadata">

**Author:** [@James1976](https://discourse.nodered.org/u/James1976)\
**Replies:** 9\
**Last updated:** [4 February 2020 17:02 UTC](https://discourse.nodered.org/t/run-multiple-projects-at-the-same-time/4883 "2020-02-04T17:02:03Z")

</div>

Guys, I would like to run multiple projects at the same time. Could you please guide me to implement this? Thanks

---

## [Python node passing data to mqtt/debug](https://discourse.nodered.org/t/python-node-passing-data-to-mqtt-debug/21203)

<div class="topic-metadata">

**Author:** [@krizniq](https://discourse.nodered.org/u/krizniq)\
**Replies:** 14\
**Last updated:** [4 February 2020 15:59 UTC](https://discourse.nodered.org/t/python-node-passing-data-to-mqtt-debug/21203 "2020-02-04T15:59:32Z")

</div>

Hello, I'm trying to use python function which will be triggered each x minutes ... (mainly because of learning experience, as I have it crontabed anyways) I'm using node-red-contrib-python-function but I'm having diffi…

---

## [Automatic trigger from 0 to 12](https://discourse.nodered.org/t/automatic-trigger-from-0-to-12/21256)

<div class="topic-metadata">

**Author:** [@MKaiser96](https://discourse.nodered.org/u/MKaiser96)\
**Replies:** 3\
**Last updated:** [4 February 2020 15:47 UTC](https://discourse.nodered.org/t/automatic-trigger-from-0-to-12/21256 "2020-02-04T15:47:21Z")

</div>

Hi, I have a new problem. I want to automatically trigger numbers from 0 to 12 (step size 1). I want to get the forecast from the dwdweather node. 0 means the actual weather. 1 means the weather in 1 hour. And so on. So…

---

## [Example for home assistant sensor node?](https://discourse.nodered.org/t/example-for-home-assistant-sensor-node/21264)

<div class="topic-metadata">

**Author:** [@kanke](https://discourse.nodered.org/u/kanke)\
**Replies:** 0\
**Last updated:** [4 February 2020 14:36 UTC](https://discourse.nodered.org/t/example-for-home-assistant-sensor-node/21264 "2020-02-04T14:36:49Z")

</div>

I can't figure out how to use sensor node from home assistant node, anyone can give some examples? thank you.

---

## [Dashboard Chart different Y Axis per Topic](https://discourse.nodered.org/t/dashboard-chart-different-y-axis-per-topic/21258)

<div class="topic-metadata">

**Author:** [@Henjoe](https://discourse.nodered.org/u/Henjoe)\
**Replies:** 4\
**Last updated:** [4 February 2020 14:13 UTC](https://discourse.nodered.org/t/dashboard-chart-different-y-axis-per-topic/21258 "2020-02-04T14:13:17Z")

</div>

Hello Gentlemen, May I know if it is possible to make our Dashboard Chart having different YAxis per topic? I have 2 topics that has a big difference on the values, and my chart doesn't look good for that. That is why …

---

## [Replace a heavily wired node](https://discourse.nodered.org/t/replace-a-heavily-wired-node/21259)

<div class="topic-metadata">

**Author:** [@ronsum](https://discourse.nodered.org/u/ronsum)\
**Replies:** 2\
**Last updated:** [4 February 2020 14:05 UTC](https://discourse.nodered.org/t/replace-a-heavily-wired-node/21259 "2020-02-04T14:05:27Z")

</div>

I have found myself in the situation a few times where I would like to insert a node right before or after a heavily wired node, or the heavily wired node has to be replaced with another node altogether. Unless my searc…

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

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