# Latest

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

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

**Page:** 1250

---

## [Philips Hue Brightness + Milight](https://discourse.nodered.org/t/philips-hue-brightness-milight/13518)

<div class="topic-metadata">

**Author:** [@NR-Beginner](https://discourse.nodered.org/u/NR-Beginner)\
**Replies:** 8\
**Last updated:** [28 July 2019 07:40 UTC](https://discourse.nodered.org/t/philips-hue-brightness-milight/13518 "2019-07-28T07:40:16Z")

</div>

Hello, I'm a beginner and can't go on with a flow. I have a Philips Hue motion detector, this should only start the flow at a certain brightness. In the current flow I have the following in it: Motion is detected, Payl…

---

## [Alexa, \[do something with this\] \[database query term\]](https://discourse.nodered.org/t/alexa-do-something-with-this-database-query-term/13762)

<div class="topic-metadata">

**Author:** [@OctavioMasomenos](https://discourse.nodered.org/u/OctavioMasomenos)\
**Replies:** 1\
**Last updated:** [27 July 2019 22:59 UTC](https://discourse.nodered.org/t/alexa-do-something-with-this-database-query-term/13762 "2019-07-27T22:59:40Z")

</div>

Is there a way to do this? I want to give Alexa a command that triggers a Node-RED flow, passing it a phrase to be used for a database query. As an example, if Alexa hears me say, “let’s hear some Fat Freddy’s Drop”, th…

---

## [KNX \> ABB USB Gateway connection to Node-RED PC dashboard](https://discourse.nodered.org/t/knx-abb-usb-gateway-connection-to-node-red-pc-dashboard/13757)

<div class="topic-metadata">

**Author:** [@Dudek](https://discourse.nodered.org/u/Dudek)\
**Replies:** 3\
**Last updated:** [27 July 2019 22:55 UTC](https://discourse.nodered.org/t/knx-abb-usb-gateway-connection-to-node-red-pc-dashboard/13757 "2019-07-27T22:55:07Z")

</div>

Hi, I am totally green in a NODE RED. It is my first time. I have some KNX modules and i would like to make a small visualisation on a PC with it. Some buttons/status. I saw that it is easy with KNX/IP converter but i …

---

## [How to use a random number to play a random playlist?](https://discourse.nodered.org/t/how-to-use-a-random-number-to-play-a-random-playlist/13760)

<div class="topic-metadata">

**Author:** [@OctavioMasomenos](https://discourse.nodered.org/u/OctavioMasomenos)\
**Replies:** 1\
**Last updated:** [27 July 2019 22:12 UTC](https://discourse.nodered.org/t/how-to-use-a-random-number-to-play-a-random-playlist/13760 "2019-07-27T22:12:00Z")

</div>

I found a node for generating a random number. I’d like to use it to play a random playlist. I assume I’d need to use some sort of a lookup table but I’m not sure how to go about it. Suggestions, please?

---

## [Creating custom form on dashborad](https://discourse.nodered.org/t/creating-custom-form-on-dashborad/13758)

<div class="topic-metadata">

**Author:** [@happytm](https://discourse.nodered.org/u/happytm)\
**Replies:** 2\
**Last updated:** [27 July 2019 19:16 UTC](https://discourse.nodered.org/t/creating-custom-form-on-dashborad/13758 "2019-07-27T19:16:26Z")

</div>

I am trying to recreate following form on dashbord: \<!DOCTYPE html\>\<html lang='en'\>\<head\>\<meta charset='utf-8'/\>\<title\>RPIEasy\</title\>\<meta name='viewport' content='width=device-width, initial-scale=1.0'\>\<script\>\<!-- fu…

---

## [Ring Doorbell not verry stable](https://discourse.nodered.org/t/ring-doorbell-not-verry-stable/4394)

<div class="topic-metadata">

**Author:** [@NickB](https://discourse.nodered.org/u/NickB)\
**Replies:** 11\
**Last updated:** [27 July 2019 18:41 UTC](https://discourse.nodered.org/t/ring-doorbell-not-verry-stable/4394 "2019-07-27T18:41:18Z")

</div>

Hi, I just purchased a ring doorbell just to have node red possibilities :slight\_smile: the node-red-contrib-ringdoorbell is quite easy. Just login and whenever there is action on the doorbell, a msg is passed in node …

---

## [Error: connect ECONNREFUSED while connecting to MYSQL](https://discourse.nodered.org/t/error-connect-econnrefused-while-connecting-to-mysql/13743)

<div class="topic-metadata">

**Author:** [@anisha](https://discourse.nodered.org/u/anisha)\
**Replies:** 5\
**Last updated:** [27 July 2019 16:28 UTC](https://discourse.nodered.org/t/error-connect-econnrefused-while-connecting-to-mysql/13743 "2019-07-27T16:28:14Z")

</div>

I am using IOT 2040 connect with energy meter running in node-red server it's perfectly working but I want to pass this data to local server MYSQL Give me a solution please

---

## [Which protocol does Node RED get data from Firebase](https://discourse.nodered.org/t/which-protocol-does-node-red-get-data-from-firebase/13736)

<div class="topic-metadata">

**Author:** [@quangminh.le0701](https://discourse.nodered.org/u/quangminh.le0701)\
**Replies:** 3\
**Last updated:** [27 July 2019 14:01 UTC](https://discourse.nodered.org/t/which-protocol-does-node-red-get-data-from-firebase/13736 "2019-07-27T14:01:58Z")

</div>

I'm using Node RED to get data from Firebase Realtime Database now. As i know, unlike typycal HTTP, Firebase using "something" to remain a connection with a client, so data will be updated realtime (like websocket). So…

---

## [Integration of a State Machine](https://discourse.nodered.org/t/integration-of-a-state-machine/13740)

<div class="topic-metadata">

**Author:** [@rayy](https://discourse.nodered.org/u/rayy)\
**Replies:** 2\
**Last updated:** [27 July 2019 06:28 UTC](https://discourse.nodered.org/t/integration-of-a-state-machine/13740 "2019-07-27T06:28:46Z")

</div>

How do you integrate a final state machine into Node Red?

---

## [Change the amount of time before TCP node throws error](https://discourse.nodered.org/t/change-the-amount-of-time-before-tcp-node-throws-error/13729)

<div class="topic-metadata">

**Author:** [@jovee](https://discourse.nodered.org/u/jovee)\
**Replies:** 2\
**Last updated:** [27 July 2019 01:30 UTC](https://discourse.nodered.org/t/change-the-amount-of-time-before-tcp-node-throws-error/13729 "2019-07-27T01:30:29Z")

</div>

Hi! Waiting for a TCP request node to throw a "connect failed" error is part of my flow, but it takes around 1min 15sec. I know that if there's no connect in the first 15 seconds of attempting, there's not going to be an…

---

## [Does Node-Red have the ability to make a requester?](https://discourse.nodered.org/t/does-node-red-have-the-ability-to-make-a-requester/13711)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 11\
**Last updated:** [26 July 2019 21:29 UTC](https://discourse.nodered.org/t/does-node-red-have-the-ability-to-make-a-requester/13711 "2019-07-26T21:29:58Z")

</div>

Although there is the text input node. I'm just wondering if there is a way to make a requester pop up? I know that would be after a button is pressed so really I could change things around and put a text input node th…

---

## [Parsing serial data](https://discourse.nodered.org/t/parsing-serial-data/13731)

<div class="topic-metadata">

**Author:** [@HereToLearn](https://discourse.nodered.org/u/HereToLearn)\
**Replies:** 2\
**Last updated:** [26 July 2019 19:23 UTC](https://discourse.nodered.org/t/parsing-serial-data/13731 "2019-07-26T19:23:14Z")

</div>

I'm working on a project where I have serial data coming into node-red and want to parse it so that I can use pieces of it for various tasks (ie displaying on a chart or saving the data). My thought is to use one serial …

---

## [Size of groups and images in a widget](https://discourse.nodered.org/t/size-of-groups-and-images-in-a-widget/13721)

<div class="topic-metadata">

**Author:** [@Andrei](https://discourse.nodered.org/u/Andrei)\
**Replies:** 2\
**Last updated:** [26 July 2019 18:57 UTC](https://discourse.nodered.org/t/size-of-groups-and-images-in-a-widget/13721 "2019-07-26T18:57:30Z")

</div>

Hello, A couple of questions about the size of a group in the dashboard. Adding only one widget (ui\_template) with dimensions of 5 x 14 to a group Chrome inspector shows that Card (group) size is 5 x 14 with dimensions…

---

## [Unsure on how to configure app.min.less](https://discourse.nodered.org/t/unsure-on-how-to-configure-app-min-less/13718)

<div class="topic-metadata">

**Author:** [@UberChio](https://discourse.nodered.org/u/UberChio)\
**Replies:** 1\
**Last updated:** [26 July 2019 16:23 UTC](https://discourse.nodered.org/t/unsure-on-how-to-configure-app-min-less/13718 "2019-07-26T16:23:23Z")

</div>

Dear all, I am currently trying to build an executable program using electron-packager as mentioned in my previous post on General: https://discourse.nodered.org/t/using-credentials-on-http-request-nodes-causes-flow-to-…

---

## [Single line chart displaying MySql-data](https://discourse.nodered.org/t/single-line-chart-displaying-mysql-data/13620)

<div class="topic-metadata">

**Author:** [@solano8](https://discourse.nodered.org/u/solano8)\
**Replies:** 5\
**Last updated:** [26 July 2019 14:31 UTC](https://discourse.nodered.org/t/single-line-chart-displaying-mysql-data/13620 "2019-07-26T14:31:45Z")

</div>

I have this output from a MySQL query: \[{"time":"2019-07-23T18:13:24.000Z","voltage":3.26},{"time":"2019-07-23T18:13:04.000Z","voltage":3.26},{"time":"2019-07-23T18:12:44.000Z","voltage":3.26},{"time":"2019-07-23T18:12:…

---

## [Using Credentials on HTTP Request Nodes causes flow to not work on startup](https://discourse.nodered.org/t/using-credentials-on-http-request-nodes-causes-flow-to-not-work-on-startup/13559)

<div class="topic-metadata">

**Author:** [@UberChio](https://discourse.nodered.org/u/UberChio)\
**Replies:** 5\
**Last updated:** [26 July 2019 09:22 UTC](https://discourse.nodered.org/t/using-credentials-on-http-request-nodes-causes-flow-to-not-work-on-startup/13559 "2019-07-26T09:22:51Z")

</div>

Dear all, I am currently trying to port my flow into an executable using electron-node-red: https://github.com/dceejay/electron-node-red. I am compiling/building for a windows x64 system using electron packager within …

---

## [Problem with connection between Node-Red and Universal Robot](https://discourse.nodered.org/t/problem-with-connection-between-node-red-and-universal-robot/13706)

<div class="topic-metadata">

**Author:** [@Miniu](https://discourse.nodered.org/u/Miniu)\
**Replies:** 1\
**Last updated:** [26 July 2019 08:52 UTC](https://discourse.nodered.org/t/problem-with-connection-between-node-red-and-universal-robot/13706 "2019-07-26T08:52:31Z")

</div>

Hi, Does anybody figure it out how to connect with UR through NODE-RED? I am trying to make with Modbus, and TCP/IP communication but I didn’t receive any good result. Modbus is still loosing connection. I am no able…

---

## [Filtering with Jsonata](https://discourse.nodered.org/t/filtering-with-jsonata/13693)

<div class="topic-metadata">

**Author:** [@ventzitt](https://discourse.nodered.org/u/ventzitt)\
**Replies:** 3\
**Last updated:** [25 July 2019 16:50 UTC](https://discourse.nodered.org/t/filtering-with-jsonata/13693 "2019-07-25T16:50:03Z")

</div>

For the last hours, I've been trying to filter some JSON messages and almost succeeded. However I can't get rid of (drop out) a msg that comes from the device occasionally and reports it's status. This is it: A pictu…

---

## [Seperating multiple values from Message Payload](https://discourse.nodered.org/t/seperating-multiple-values-from-message-payload/13675)

<div class="topic-metadata">

**Author:** [@ebnerjoh](https://discourse.nodered.org/u/ebnerjoh)\
**Replies:** 2\
**Last updated:** [25 July 2019 16:13 UTC](https://discourse.nodered.org/t/seperating-multiple-values-from-message-payload/13675 "2019-07-25T16:13:34Z")

</div>

Hi, I have the following message payload: {"Header":{"Version":5,"Device":"80","Timestamp":1564041835},"Data":{"Inputs":\[{"Number":1,"AD":"A","Value":{"Value":32.4,"Unit":"1"}},{"Number":2,"AD":"A","Value":{"Value":27.…

---

## [Change Page Background When Button is Pressed](https://discourse.nodered.org/t/change-page-background-when-button-is-pressed/13689)

<div class="topic-metadata">

**Author:** [@learning](https://discourse.nodered.org/u/learning)\
**Replies:** 0\
**Last updated:** [25 July 2019 13:31 UTC](https://discourse.nodered.org/t/change-page-background-when-button-is-pressed/13689 "2019-07-25T13:31:25Z")

</div>

When I press a button on the dashboard, I would like the entire page background to change color. i.e. when I press the stop button, the background changes to a red. I am able to do it if I use javascript with the followi…

---

## [How many serial requests blocs for one serial port](https://discourse.nodered.org/t/how-many-serial-requests-blocs-for-one-serial-port/13687)

<div class="topic-metadata">

**Author:** [@Charlotte](https://discourse.nodered.org/u/Charlotte)\
**Replies:** 1\
**Last updated:** [25 July 2019 12:59 UTC](https://discourse.nodered.org/t/how-many-serial-requests-blocs-for-one-serial-port/13687 "2019-07-25T12:59:31Z")

</div>

Hello, I'm working on serial ports with a stirrer. I want to be able to start it, stop it and ask for the speed each 5 seconds. For each use case I have different commands to send and a different way to manage the answe…

---

## [📕 Big documentation update](https://discourse.nodered.org/t/big-documentation-update/12657)

<div class="topic-metadata">

**Author:** [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Replies:** 30\
**Last updated:** [25 July 2019 09:23 UTC](https://discourse.nodered.org/t/big-documentation-update/12657 "2019-07-25T09:23:29Z")

</div>

Hi, I've just pushed a big update to the documentation. The Getting Started is (hopefully) clearer for what to do depending on where you want to run Node-RED. The main User Guide has had a bit of a reorganisation. I'v…

---

## [SQLite "Error: SQLITE\_ERROR: no such column:"](https://discourse.nodered.org/t/sqlite-error-sqlite-error-no-such-column/13655)

<div class="topic-metadata">

**Author:** [@YT2310](https://discourse.nodered.org/u/YT2310)\
**Replies:** 14\
**Last updated:** [25 July 2019 08:43 UTC](https://discourse.nodered.org/t/sqlite-error-sqlite-error-no-such-column/13655 "2019-07-25T08:43:54Z")

</div>

Hello, I just try a hunderet times but I can't fix it.. I created a new table: CREATE TABLE 'erfassungsbeleg' ('id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 'personal' INTEGER, 'name' CHAR,'kostentraeger' INTEGER,'s…

---

## [How to use the response TCP in the TCP node in node-red](https://discourse.nodered.org/t/how-to-use-the-response-tcp-in-the-tcp-node-in-node-red/13677)

<div class="topic-metadata">

**Author:** [@liuxuetan](https://discourse.nodered.org/u/liuxuetan)\
**Replies:** 2\
**Last updated:** [25 July 2019 07:56 UTC](https://discourse.nodered.org/t/how-to-use-the-response-tcp-in-the-tcp-node-in-node-red/13677 "2019-07-25T07:56:46Z")

</div>

How to use the response TCP in the TCP node in node-red and under what circumstances

---

## [Dockerized node-red](https://discourse.nodered.org/t/dockerized-node-red/13597)

<div class="topic-metadata">

**Author:** [@braous](https://discourse.nodered.org/u/braous)\
**Replies:** 2\
**Last updated:** [25 July 2019 06:12 UTC](https://discourse.nodered.org/t/dockerized-node-red/13597 "2019-07-25T06:12:44Z")

</div>

Hi, I have created a new node where it connects to Mosquitto (local MQTT broker) on port 1883. Everything is fine with node-red running outside the docker, but a dockerized node-red, will not able to establish the MQTT …

---

## [Unable to install Node-Red Dashboard](https://discourse.nodered.org/t/unable-to-install-node-red-dashboard/13672)

<div class="topic-metadata">

**Author:** [@JohnAPA](https://discourse.nodered.org/u/JohnAPA)\
**Replies:** 1\
**Last updated:** [25 July 2019 06:01 UTC](https://discourse.nodered.org/t/unable-to-install-node-red-dashboard/13672 "2019-07-25T06:01:05Z")

</div>

Hello Just starting out and following tutorials on installing node red dashboard. I went to Manage Palettes \> Install \> Node Red dashboard MacBook:.node-red cube$ npm i node-red-dashboard Unhandled rejection Error: E…

---

## [Delay message until a specific time](https://discourse.nodered.org/t/delay-message-until-a-specific-time/13667)

<div class="topic-metadata">

**Author:** [@pendlet](https://discourse.nodered.org/u/pendlet)\
**Replies:** 7\
**Last updated:** [25 July 2019 02:00 UTC](https://discourse.nodered.org/t/delay-message-until-a-specific-time/13667 "2019-07-25T02:00:52Z")

</div>

I am trying to delay a message in my sequence until a certain time of day. I thought i would be a bale to use the delay node to have it hold the message payload it receives until a certain time is reached, but i don't se…

---

## [Cosmos DB with Partition Key](https://discourse.nodered.org/t/cosmos-db-with-partition-key/13087)

<div class="topic-metadata">

**Author:** [@awsteve](https://discourse.nodered.org/u/awsteve)\
**Replies:** 1\
**Last updated:** [24 July 2019 16:57 UTC](https://discourse.nodered.org/t/cosmos-db-with-partition-key/13087 "2019-07-24T16:57:26Z")

</div>

I am trying to use Node-Red with Azure Cosmos DB through the node-red-contrib-azure-documentdb - Documents v0.0.3 node. I had this working, but created a new Cosmos container in the Azure Portal. Azure now require all …

---

## [Change Node issue with JSONata](https://discourse.nodered.org/t/change-node-issue-with-jsonata/13648)

<div class="topic-metadata">

**Author:** [@nomi](https://discourse.nodered.org/u/nomi)\
**Replies:** 3\
**Last updated:** [24 July 2019 16:02 UTC](https://discourse.nodered.org/t/change-node-issue-with-jsonata/13648 "2019-07-24T16:02:03Z")

</div>

Hi, I have a issue with the following Node-Red flow :slight\_smile: \[{"id":"5f0904d0.61fd5c","type":"tab","label":"tests","disabled":false,"info":""},{"id":"21d27fc5.dbd3c","type":"inject","z":"5f0904d0.61fd5c","name":"…

---

## [Twitter timeline Viewer on Dashboard´s](https://discourse.nodered.org/t/twitter-timeline-viewer-on-dashboard-s/13659)

<div class="topic-metadata">

**Author:** [@Agrotar](https://discourse.nodered.org/u/Agrotar)\
**Replies:** 2\
**Last updated:** [24 July 2019 15:03 UTC](https://discourse.nodered.org/t/twitter-timeline-viewer-on-dashboard-s/13659 "2019-07-24T15:03:05Z")

</div>

Hello, can someone help me and tell me how to insert a Twitter timeline viewer on my Dashboard? I'd like to have the tweets displayed on the dashboard. Many Thanks. Agrotar

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

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