# General

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

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

**Page:** 771

---

## [Stop interval trigger with msg.reset](https://discourse.nodered.org/t/stop-interval-trigger-with-msg-reset/24305)

<div class="topic-metadata">

**Author:** [@mansahlgren](https://discourse.nodered.org/u/mansahlgren)\
**Replies:** 15\
**Last updated:** [6 April 2020 15:26 UTC](https://discourse.nodered.org/t/stop-interval-trigger-with-msg-reset/24305 "2020-04-06T15:26:11Z")

</div>

I have a function node, f1, which triggers a trigger node so that it (the trigger node) starts generating pulses according to an interval. The pulses trigger another function node, f2, which simulates data for a given t…

---

## [Using global variables in a paragraph / template](https://discourse.nodered.org/t/using-global-variables-in-a-paragraph-template/24299)

<div class="topic-metadata">

**Author:** [@mixnode](https://discourse.nodered.org/u/mixnode)\
**Replies:** 3\
**Last updated:** [6 April 2020 14:20 UTC](https://discourse.nodered.org/t/using-global-variables-in-a-paragraph-template/24299 "2020-04-06T14:20:36Z")

</div>

Hi, I have some global variables set. Like sun.rise. Seems to be in the context data. I'd like to retrieve them and use them in a dashboard template, or in a function that is crafted to output to a template. I've name…

---

## [Anybody knows how to use predictor node in machine learning node package?](https://discourse.nodered.org/t/anybody-knows-how-to-use-predictor-node-in-machine-learning-node-package/24323)

<div class="topic-metadata">

**Author:** [@Phil](https://discourse.nodered.org/u/Phil)\
**Replies:** 0\
**Last updated:** [6 April 2020 15:02 UTC](https://discourse.nodered.org/t/anybody-knows-how-to-use-predictor-node-in-machine-learning-node-package/24323 "2020-04-06T15:02:00Z")

</div>

I am trying to build a project with node-red-contrib-machine-learning. the example given on the page is working till the last sample . when I try to input my own value there seems to be some error. does anybody know the…

---

## [Basic url works fine in browser not in node-red HTTP request](https://discourse.nodered.org/t/basic-url-works-fine-in-browser-not-in-node-red-http-request/24316)

<div class="topic-metadata">

**Author:** [@rwmingis](https://discourse.nodered.org/u/rwmingis)\
**Replies:** 2\
**Last updated:** [6 April 2020 13:45 UTC](https://discourse.nodered.org/t/basic-url-works-fine-in-browser-not-in-node-red-http-request/24316 "2020-04-06T13:45:30Z")

</div>

Hi there, I'm trying to access Sydney airport json data at: http://www.bom.gov.au/fwo/IDN60801/IDN60801.94767.json When I navigate there in chrome, it works fine and I get a page full of JSON data. When I access it f…

---

## [Node-red for web-based simulations](https://discourse.nodered.org/t/node-red-for-web-based-simulations/19285)

<div class="topic-metadata">

**Author:** [@Federico](https://discourse.nodered.org/u/Federico)\
**Replies:** 4\
**Last updated:** [6 April 2020 13:25 UTC](https://discourse.nodered.org/t/node-red-for-web-based-simulations/19285 "2020-04-06T13:25:06Z")

</div>

Hello everyone, do you think is possible to use Node-red and its node wiring editor for discrete event / agent based simulation with the OESjs simulation framework? In principle it should be viable, by using the OESjs …

---

## [UI-SVG - elementid](https://discourse.nodered.org/t/ui-svg-elementid/24004)

<div class="topic-metadata">

**Author:** [@greenembrace](https://discourse.nodered.org/u/greenembrace)\
**Replies:** 14\
**Last updated:** [6 April 2020 08:36 UTC](https://discourse.nodered.org/t/ui-svg-elementid/24004 "2020-04-06T08:36:59Z")

</div>

Hi, dashboard SVG Node: Events Property: Selector field: I have created a selector to access multiple id's as per Christmas lights example. my selector field -\> \[id^=Output-5\] does select correctly all Id's starti…

---

## [Occur error when run command \`sudo npm install -g node-red-admin\`](https://discourse.nodered.org/t/occur-error-when-run-command-sudo-npm-install-g-node-red-admin/24271)

<div class="topic-metadata">

**Author:** [@lingzhongli](https://discourse.nodered.org/u/lingzhongli)\
**Replies:** 7\
**Last updated:** [6 April 2020 07:55 UTC](https://discourse.nodered.org/t/occur-error-when-run-command-sudo-npm-install-g-node-red-admin/24271 "2020-04-06T07:55:44Z")

</div>

How to solve this problem?

---

## [Inserting to mySql database](https://discourse.nodered.org/t/inserting-to-mysql-database/24294)

<div class="topic-metadata">

**Author:** [@iankillz](https://discourse.nodered.org/u/iankillz)\
**Replies:** 2\
**Last updated:** [6 April 2020 07:36 UTC](https://discourse.nodered.org/t/inserting-to-mysql-database/24294 "2020-04-06T07:36:22Z")

</div>

Hello guys, I need help inserting the value from a function to my MySql database but every time I deploy, it says "Error: ER\_BAD\_FIELD\_ERROR: Unknown column 'available' in 'field list'" " This is my flow so the change n…

---

## [Bitcoin wallet set nodes?](https://discourse.nodered.org/t/bitcoin-wallet-set-nodes/24292)

<div class="topic-metadata">

**Author:** [@lizzardguki](https://discourse.nodered.org/u/lizzardguki)\
**Replies:** 2\
**Last updated:** [6 April 2020 06:12 UTC](https://discourse.nodered.org/t/bitcoin-wallet-set-nodes/24292 "2020-04-06T06:12:10Z")

</div>

Why no one of the contributors built a node-red node/nodes for use with bitcoin ?

---

## [Run a function if I receive a direct message or a mention in Slack?](https://discourse.nodered.org/t/run-a-function-if-i-receive-a-direct-message-or-a-mention-in-slack/24266)

<div class="topic-metadata">

**Author:** [@mversion](https://discourse.nodered.org/u/mversion)\
**Replies:** 1\
**Last updated:** [6 April 2020 00:12 UTC](https://discourse.nodered.org/t/run-a-function-if-i-receive-a-direct-message-or-a-mention-in-slack/24266 "2020-04-06T00:12:45Z")

</div>

I'm sure this is doable, but don't know where to start. So, my idea is to switch on a tp-link light, if I have an unread direct message or a @mention of my username in Slack and then turn it off if I clear my unread cou…

---

## [Excel: how to write in desired cell](https://discourse.nodered.org/t/excel-how-to-write-in-desired-cell/24291)

<div class="topic-metadata">

**Author:** [@rromele](https://discourse.nodered.org/u/rromele)\
**Replies:** 3\
**Last updated:** [5 April 2020 23:47 UTC](https://discourse.nodered.org/t/excel-how-to-write-in-desired-cell/24291 "2020-04-05T23:47:15Z")

</div>

Hi, should I write this message in cell "C3", how can this be done with the node "file"? \[{"id":"2735b2c2.710b4e","type":"file","z":"9c807128.5de97","name":"","filename":"c:\\\\a\\\\12345.xls","appendNewline":true,"create…

---

## [Node red flows seem to be slowing down](https://discourse.nodered.org/t/node-red-flows-seem-to-be-slowing-down/24116)

<div class="topic-metadata">

**Author:** [@Troypearce](https://discourse.nodered.org/u/Troypearce)\
**Replies:** 43\
**Last updated:** [5 April 2020 19:27 UTC](https://discourse.nodered.org/t/node-red-flows-seem-to-be-slowing-down/24116 "2020-04-05T19:27:08Z")

</div>

Hello all, Node red newbie here. I have two flows that are working and control an esp8266 spa controller(client) and an esp32 fishtank/grow area aquaponic(client). This used to have very low latency.... dashboard has…

---

## [Node-red-contrib particle](https://discourse.nodered.org/t/node-red-contrib-particle/24174)

<div class="topic-metadata">

**Author:** [@NODE777](https://discourse.nodered.org/u/NODE777)\
**Replies:** 2\
**Last updated:** [5 April 2020 18:36 UTC](https://discourse.nodered.org/t/node-red-contrib-particle/24174 "2020-04-05T18:36:01Z")

</div>

Hi there ! I was wondering if currently is there anybody running this node and is experiencing some kind of interruption getting response from particle cloud ? Thank you.

---

## [Audio comparing](https://discourse.nodered.org/t/audio-comparing/24218)

<div class="topic-metadata">

**Author:** [@cpaolojo](https://discourse.nodered.org/u/cpaolojo)\
**Replies:** 7\
**Last updated:** [5 April 2020 15:23 UTC](https://discourse.nodered.org/t/audio-comparing/24218 "2020-04-05T15:23:34Z")

</div>

Hi all, I have a question for you. I would realize a project able to compare the MIC input with an audio file used as reference. Do you have any idea? Any project or node to suggest me? Thanks in advance Paolo

---

## [JSONata - assign value as property name](https://discourse.nodered.org/t/jsonata-assign-value-as-property-name/24272)

<div class="topic-metadata">

**Author:** [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Replies:** 1\
**Last updated:** [5 April 2020 14:35 UTC](https://discourse.nodered.org/t/jsonata-assign-value-as-property-name/24272 "2020-04-05T14:35:24Z")

</div>

Lets say i have an array of objects: \[{"Datum":"2020-03-25", "value":32}\] I want to use the value of "Datum" as key/prop name, is this possible in jsonata ? Expected output: \[{"2020-03-25":32}\]

---

## [Get number from output mysql](https://discourse.nodered.org/t/get-number-from-output-mysql/24212)

<div class="topic-metadata">

**Author:** [@warnert](https://discourse.nodered.org/u/warnert)\
**Replies:** 2\
**Last updated:** [5 April 2020 11:48 UTC](https://discourse.nodered.org/t/get-number-from-output-mysql/24212 "2020-04-05T11:48:11Z")

</div>

I am creating the clock part for my roomthermostat. I have a database with times and temp's. I have a flow where a mysql query gives back one row with the temp that should be sent to the thermostat at a certain time. Th…

---

## [Anyone done much work with the Smooth Node?](https://discourse.nodered.org/t/anyone-done-much-work-with-the-smooth-node/3159)

<div class="topic-metadata">

**Author:** [@craigcurtin](https://discourse.nodered.org/u/craigcurtin)\
**Replies:** 20\
**Last updated:** [5 April 2020 11:45 UTC](https://discourse.nodered.org/t/anyone-done-much-work-with-the-smooth-node/3159 "2020-04-05T11:45:19Z")

</div>

Guys, Still moving my heating project forward - currently on my picaxe system which does the temperature measurement, i have a rolling average of 10 temperatures, i do this by testing the incoming values against the ave…

---

## [How can I scrape Wunderground historic data](https://discourse.nodered.org/t/how-can-i-scrape-wunderground-historic-data/24224)

<div class="topic-metadata">

**Author:** [@djash55](https://discourse.nodered.org/u/djash55)\
**Replies:** 5\
**Last updated:** [5 April 2020 11:42 UTC](https://discourse.nodered.org/t/how-can-i-scrape-wunderground-historic-data/24224 "2020-04-05T11:42:15Z")

</div>

I'm trying to scrape the day average temperature from here: https://www.wunderground.com/history/daily/us/pa/easton/KPAEASTO22/date/2020-3-28 Each day day I'd like to get the previous day's Day average temperature. I tr…

---

## [Connetion error node ibmiot](https://discourse.nodered.org/t/connetion-error-node-ibmiot/24263)

<div class="topic-metadata">

**Author:** [@ivo815](https://discourse.nodered.org/u/ivo815)\
**Replies:** 0\
**Last updated:** [5 April 2020 10:19 UTC](https://discourse.nodered.org/t/connetion-error-node-ibmiot/24263 "2020-04-05T10:19:56Z")

</div>

Hello Trying hardly to get the node ibmiot connected.. As "Authentification" I have to chose "API Key". I have to insert an API Key which I am generating on the IBM platform (is there anything I can do wrong there?) …

---

## [Day/Night Device Duty Cycle](https://discourse.nodered.org/t/day-night-device-duty-cycle/23936)

<div class="topic-metadata">

**Author:** [@napalm99](https://discourse.nodered.org/u/napalm99)\
**Replies:** 11\
**Last updated:** [5 April 2020 09:08 UTC](https://discourse.nodered.org/t/day-night-device-duty-cycle/23936 "2020-04-05T09:08:05Z")

</div>

Hi there, I've got Node Red running on a Raspi 3B+ and a couple ESP8266s connected to the network. I'm using these ESP8266 to turn ON and OFF devices via MQTT. I'm pretty new to Node Red and I am struggling to achieve th…

---

## [How to use the Event log](https://discourse.nodered.org/t/how-to-use-the-event-log/14549)

<div class="topic-metadata">

**Author:** [@ab73863](https://discourse.nodered.org/u/ab73863)\
**Replies:** 5\
**Last updated:** [5 April 2020 08:17 UTC](https://discourse.nodered.org/t/how-to-use-the-event-log/14549 "2020-04-05T08:17:05Z")

</div>

Hello , I was trying to explore the event log option in node-red ( View -\> Event Log). I am not able to see any events on the view panel even though I tried log using node.log or node.send option from a function node. I…

---

## [Fail open node red in browser using ip address](https://discourse.nodered.org/t/fail-open-node-red-in-browser-using-ip-address/24219)

<div class="topic-metadata">

**Author:** [@lingzhongli](https://discourse.nodered.org/u/lingzhongli)\
**Replies:** 15\
**Last updated:** [5 April 2020 05:33 UTC](https://discourse.nodered.org/t/fail-open-node-red-in-browser-using-ip-address/24219 "2020-04-05T05:33:38Z")

</div>

my node red is fail to open using browser... it show cookies(0 in use)...i think this is the problem... any solution ? why it show 0 cookies in use? i using google chrome ... but it avaliable open when i using browser …

---

## [Reload of credential file](https://discourse.nodered.org/t/reload-of-credential-file/24204)

<div class="topic-metadata">

**Author:** [@crackytsi](https://discourse.nodered.org/u/crackytsi)\
**Replies:** 3\
**Last updated:** [5 April 2020 04:20 UTC](https://discourse.nodered.org/t/reload-of-credential-file/24204 "2020-04-05T04:20:26Z")

</div>

Hi, I have 2 node-red instances. Using the Admin-API I'm able to sync the flows and using scp I'm also able to copy the credential file from one node instance to the other. Unfortunately they are not directly applied, …

---

## [Monitoring IoT by Ping](https://discourse.nodered.org/t/monitoring-iot-by-ping/23718)

<div class="topic-metadata">

**Author:** [@edstobi](https://discourse.nodered.org/u/edstobi)\
**Replies:** 28\
**Last updated:** [4 April 2020 22:57 UTC](https://discourse.nodered.org/t/monitoring-iot-by-ping/23718 "2020-04-04T22:57:36Z")

</div>

Hello I monitor some IoT by ping. These are then displayed in green or red on the dashboard if they are alive or not. The more there are the more work and maintenance there is. Is there a way where I read a comma or s…

---

## [Coronavirus Quarantine - Node-RED Games?](https://discourse.nodered.org/t/coronavirus-quarantine-node-red-games/23817)

<div class="topic-metadata">

**Author:** [@nodecentral](https://discourse.nodered.org/u/nodecentral)\
**Replies:** 13\
**Last updated:** [4 April 2020 21:26 UTC](https://discourse.nodered.org/t/coronavirus-quarantine-node-red-games/23817 "2020-04-04T21:26:09Z")

</div>

Hi all, a bit of a long shot, but has anyone created any Node-Red games, that could help the lockdown hours pass (especially for those with kids) Ideally it would be nothing hugely complex that requires additional nodes…

---

## [Function for Hysteresi on analog signal](https://discourse.nodered.org/t/function-for-hysteresi-on-analog-signal/24195)

<div class="topic-metadata">

**Author:** [@rromele](https://discourse.nodered.org/u/rromele)\
**Replies:** 2\
**Last updated:** [4 April 2020 21:12 UTC](https://discourse.nodered.org/t/function-for-hysteresi-on-analog-signal/24195 "2020-04-04T21:12:39Z")

</div>

Hi, I would like to implement a function for the control of an analog signal, with the operation indicated below: I don't know how to memorize the fact that the input signal has exceeded the setpoint inside the funct…

---

## [Help me stay in touch with the family!](https://discourse.nodered.org/t/help-me-stay-in-touch-with-the-family/24211)

<div class="topic-metadata">

**Author:** [@PeteS](https://discourse.nodered.org/u/PeteS)\
**Replies:** 10\
**Last updated:** [4 April 2020 20:35 UTC](https://discourse.nodered.org/t/help-me-stay-in-touch-with-the-family/24211 "2020-04-04T20:35:34Z")

</div>

Hello everyone. Many thanks in advance for any help. I've got some experience with electronics and programming, but none in JavaScript or HTML code. I recently managed to write a flow that controlled (input and output) …

---

## [Recover my information in settings.js file](https://discourse.nodered.org/t/recover-my-information-in-settings-js-file/24232)

<div class="topic-metadata">

**Author:** [@lingzhongli](https://discourse.nodered.org/u/lingzhongli)\
**Replies:** 3\
**Last updated:** [4 April 2020 19:50 UTC](https://discourse.nodered.org/t/recover-my-information-in-settings-js-file/24232 "2020-04-04T19:50:15Z")

</div>

there have ways to recover information in settings.js file? i think i have uncarefully delete..... or who can share your information in settings.js file...then i copy... thanksss

---

## [Unable to get "source" from ewelink device](https://discourse.nodered.org/t/unable-to-get-source-from-ewelink-device/24231)

<div class="topic-metadata">

**Author:** [@demokedes](https://discourse.nodered.org/u/demokedes)\
**Replies:** 0\
**Last updated:** [4 April 2020 19:14 UTC](https://discourse.nodered.org/t/unable-to-get-source-from-ewelink-device/24231 "2020-04-04T19:14:55Z")

</div>

Hey, I have another question regarding ewelink devices in nodered. I would like to get user that forced specific action. In application I can see which user perfomed particular action. In node-red I only see either dev…

---

## [Response to tcp subscription?](https://discourse.nodered.org/t/response-to-tcp-subscription/24229)

<div class="topic-metadata">

**Author:** [@knoepsche](https://discourse.nodered.org/u/knoepsche)\
**Replies:** 0\
**Last updated:** [4 April 2020 17:48 UTC](https://discourse.nodered.org/t/response-to-tcp-subscription/24229 "2020-04-04T17:48:41Z")

</div>

I use aTCP-IN NODE to listen for a client at port 8250. If the client connects it sends me a subscription message with this message i get session-id, ip and port of the connection: CasparCG Client : msg : Object obj…

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

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