# General

**URL:** https://discourse.nodered.org/c/general/7.md?page=863

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

**Page:** 864

---

## [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?

---

## [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…

---

## [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 …

---

## [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.…

---

## [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…

---

## [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 …

---

## [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":"…

---

## [How to send data of wireless sensor to google sheets](https://discourse.nodered.org/t/how-to-send-data-of-wireless-sensor-to-google-sheets/13644)

<div class="topic-metadata">

**Author:** [@adamf](https://discourse.nodered.org/u/adamf)\
**Replies:** 5\
**Last updated:** [24 July 2019 12:07 UTC](https://discourse.nodered.org/t/how-to-send-data-of-wireless-sensor-to-google-sheets/13644 "2019-07-24T12:07:44Z")

</div>

Hi, I am working with wireless temperature and humidity sensor I want to send its data to google sheets. I have searched on google and found thislink. From this link I have created the google sheet but I am not get…

---

## [Node-Red problem with messages in node.send(msg)](https://discourse.nodered.org/t/node-red-problem-with-messages-in-node-send-msg/13607)

<div class="topic-metadata">

**Author:** [@stamer](https://discourse.nodered.org/u/stamer)\
**Replies:** 2\
**Last updated:** [24 July 2019 08:44 UTC](https://discourse.nodered.org/t/node-red-problem-with-messages-in-node-send-msg/13607 "2019-07-24T08:44:54Z")

</div>

Hey, I have problems with the call: node.send(msg). When I call node.send(msg) within node.on('input', function(msg){}), it works, but this call within function Test(n) {} does not work always (sometimes, if the flow a…

---

## [Error when reinstalling freeboard node](https://discourse.nodered.org/t/error-when-reinstalling-freeboard-node/13627)

<div class="topic-metadata">

**Author:** [@3amWednesday](https://discourse.nodered.org/u/3amWednesday)\
**Replies:** 1\
**Last updated:** [24 July 2019 05:05 UTC](https://discourse.nodered.org/t/error-when-reinstalling-freeboard-node/13627 "2019-07-24T05:05:28Z")

</div>

A while back I installed node-red-contrib-freeboard through the palette manager. Then I uninstalled it also through palette manager after realising the node I wanted wasn't it. Now I am trying to install it again, but i…

---

## [Editing settings.js before starting node-RED first time](https://discourse.nodered.org/t/editing-settings-js-before-starting-node-red-first-time/13623)

<div class="topic-metadata">

**Author:** [@kolban](https://discourse.nodered.org/u/kolban)\
**Replies:** 3\
**Last updated:** [24 July 2019 04:26 UTC](https://discourse.nodered.org/t/editing-settings-js-before-starting-node-red-first-time/13623 "2019-07-24T04:26:06Z")

</div>

I'm writing up a recipe for colleagues to follow. One of the things that our environment needs is for the users to create their own passwords ... we can't allow non-password protected environments. To achieve this, we …

---

## ["Wifi scan" (python scrpit) different outputs from different machines](https://discourse.nodered.org/t/wifi-scan-python-scrpit-different-outputs-from-different-machines/13343)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 30\
**Last updated:** [24 July 2019 04:06 UTC](https://discourse.nodered.org/t/wifi-scan-python-scrpit-different-outputs-from-different-machines/13343 "2019-07-24T04:06:19Z")

</div>

I have two RPIs scanning for available WAPs. One is showing me this: {"payload":"\[\\"TelstraCA5E31\\", \\"Fon WiFi\\", \\"Telstra Air\\", \\"BigPond121C\\", \\"Telstra6C2C0D\\", \\"Telstra6C2C0D\\", \\"PiNet\\", \\"Tango2\\", \\"Telstr…

---

## [Node-Red Configuration for Tello Drone (Unable to take pictures)](https://discourse.nodered.org/t/node-red-configuration-for-tello-drone-unable-to-take-pictures/10959)

<div class="topic-metadata">

**Author:** [@DroneNewbie](https://discourse.nodered.org/u/DroneNewbie)\
**Replies:** 3\
**Last updated:** [24 July 2019 04:02 UTC](https://discourse.nodered.org/t/node-red-configuration-for-tello-drone-unable-to-take-pictures/10959 "2019-07-24T04:02:56Z")

</div>

Hi all ! First of all, I am a beginner in using Node-Red, and am trying to follow a tutorial to take photos with my Tello drone - https://github.com/johnwalicki/Node-RED-Tello-Control/blob/master/flows/solutions/part7\_s…

---

## [\[Solved\] Node-red-node-ui\_list vrs node-red-contrib-ui\_list](https://discourse.nodered.org/t/solved-node-red-node-ui-list-vrs-node-red-contrib-ui-list/13621)

<div class="topic-metadata">

**Author:** [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Replies:** 3\
**Last updated:** [24 July 2019 02:20 UTC](https://discourse.nodered.org/t/solved-node-red-node-ui-list-vrs-node-red-contrib-ui-list/13621 "2019-07-24T02:20:57Z")

</div>

There are two ui\_list nodes: node-red-node-ui\_list v0.1.5 node-red-contrib-ui\_list v0.1.4 From the flows library, the GitHub link for both takes you to node-red-node-ui\_list the npm links take you to the proper node. …

---

## [The input TCP component in node-red shows that the connection is connected and occasionally the data is not received. What's the solution?](https://discourse.nodered.org/t/the-input-tcp-component-in-node-red-shows-that-the-connection-is-connected-and-occasionally-the-data-is-not-received-whats-the-solution/13601)

<div class="topic-metadata">

**Author:** [@liuxuetan](https://discourse.nodered.org/u/liuxuetan)\
**Replies:** 4\
**Last updated:** [24 July 2019 01:21 UTC](https://discourse.nodered.org/t/the-input-tcp-component-in-node-red-shows-that-the-connection-is-connected-and-occasionally-the-data-is-not-received-whats-the-solution/13601 "2019-07-24T01:21:42Z")

</div>

The input TCP component in node-red shows that the connection is connected and occasionally the data is not received. What's the solution?

---

## [MQTT & POSTGRESQL on Raspberry](https://discourse.nodered.org/t/mqtt-postgresql-on-raspberry/13412)

<div class="topic-metadata">

**Author:** [@bert2713d](https://discourse.nodered.org/u/bert2713d)\
**Replies:** 7\
**Last updated:** [23 July 2019 21:59 UTC](https://discourse.nodered.org/t/mqtt-postgresql-on-raspberry/13412 "2019-07-23T21:59:15Z")

</div>

Hello I have a project to be able to view the data of a home temperature sensor by internet. Here the main way used : DS18BS20 Temperature sensor ------\> ESP8266 NODEMCU --------\> MQTT MOSQQUITTO Broker on a Raspberr…

---

## [Trigger Node: external reset](https://discourse.nodered.org/t/trigger-node-external-reset/13566)

<div class="topic-metadata">

**Author:** [@Symonn](https://discourse.nodered.org/u/Symonn)\
**Replies:** 4\
**Last updated:** [23 July 2019 18:02 UTC](https://discourse.nodered.org/t/trigger-node-external-reset/13566 "2019-07-23T18:02:55Z")

</div>

Hi, i was wondering if someone has some ideas about how to reset the Trigger node in a given flow using an external component, for example: an api that resets the node based on a specific flow and node id. My goal is to…

---

## [Deployment through FTP](https://discourse.nodered.org/t/deployment-through-ftp/13603)

<div class="topic-metadata">

**Author:** [@GregorR1](https://discourse.nodered.org/u/GregorR1)\
**Replies:** 4\
**Last updated:** [23 July 2019 12:10 UTC](https://discourse.nodered.org/t/deployment-through-ftp/13603 "2019-07-23T12:10:28Z")

</div>

Hi, I'm having a few issues with the chromium-browser on one of my remote devices, meaning I cannot access the node-red to make much-needed changes to the code. Is there a possible way that I can deploy the flows etc b…

[Previous page](https://discourse.nodered.org/c/general/7.md?page=862)

[Next page](https://discourse.nodered.org/c/general/7.md?page=864)