# Latest

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

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

**Page:** 1377

---

## [Sqlite Vs InfluxDB & Grafana](https://discourse.nodered.org/t/sqlite-vs-influxdb-grafana/2009)

<div class="topic-metadata">

**Author:** [@JoseGodinho](https://discourse.nodered.org/u/JoseGodinho)\
**Replies:** 7\
**Last updated:** [3 August 2018 13:41 UTC](https://discourse.nodered.org/t/sqlite-vs-influxdb-grafana/2009 "2018-08-03T13:41:58Z")

</div>

Hello All I have implemented SQLite in my project, using the excellent examples from Csongor Varga My question is this is most effective way to record time series? A drawback from sqlite is the connection to grafana, …

---

## [Create simple if then flow](https://discourse.nodered.org/t/create-simple-if-then-flow/2002)

<div class="topic-metadata">

**Author:** [@hermann1514](https://discourse.nodered.org/u/hermann1514)\
**Replies:** 11\
**Last updated:** [3 August 2018 13:41 UTC](https://discourse.nodered.org/t/create-simple-if-then-flow/2002 "2018-08-03T13:41:56Z")

</div>

Hello, I've been trying to build a simple IF THEN logic for a few days now. But do not get it. The idea is that if one value is over 40 and the other value is "ON" something should be done. Somewhere is still the worm i…

---

## [IoT Candy Grabber](https://discourse.nodered.org/t/iot-candy-grabber/2025)

<div class="topic-metadata">

**Author:** [@makkelaig](https://discourse.nodered.org/u/makkelaig)\
**Replies:** 1\
**Last updated:** [3 August 2018 13:21 UTC](https://discourse.nodered.org/t/iot-candy-grabber/2025 "2018-08-03T13:21:32Z")

</div>

For my bachelor project in mechatronics I had to remotely control a toy candy grabber via network. For this purpose I connected the hardware of the candy grabber to a Raspberry Pi3 Modell B+ and modified it slightly so I…

---

## [Coding functions](https://discourse.nodered.org/t/coding-functions/2028)

<div class="topic-metadata">

**Author:** [@kaffikanne](https://discourse.nodered.org/u/kaffikanne)\
**Replies:** 4\
**Last updated:** [3 August 2018 12:40 UTC](https://discourse.nodered.org/t/coding-functions/2028 "2018-08-03T12:40:54Z")

</div>

Hi i am trying to get at timer function to work, i have tried something like this: var a = msg.payload; var myVar; if ( a === true){ myFunction(); } function myFunction() { myVar = setTimeout(alertFunc, 3000); } …

---

## [Wipe and re-install NodeRed on windows](https://discourse.nodered.org/t/wipe-and-re-install-nodered-on-windows/2016)

<div class="topic-metadata">

**Author:** [@cymplecy](https://discourse.nodered.org/u/cymplecy)\
**Replies:** 3\
**Last updated:** [3 August 2018 12:10 UTC](https://discourse.nodered.org/t/wipe-and-re-install-nodered-on-windows/2016 "2018-08-03T12:10:31Z")

</div>

I seem to be having issues updating a node (Blocky) on my Win10 machine so I'd like to nuke it from orbit and start again What to I need to do to remove it? Simply delete c:\\users\\Simon.node-red folder ? (having made …

---

## [HTTP Response Node Use, Sigfox Downlink](https://discourse.nodered.org/t/http-response-node-use-sigfox-downlink/2001)

<div class="topic-metadata">

**Author:** [@svi](https://discourse.nodered.org/u/svi)\
**Replies:** 8\
**Last updated:** [3 August 2018 11:34 UTC](https://discourse.nodered.org/t/http-response-node-use-sigfox-downlink/2001 "2018-08-03T11:34:03Z")

</div>

I receive an HTTP Post, depending of the packet type received I should send back a packet. HTTP Response is thought to send this packet, or only is an automatic answer with code type 200? I have tried this node in my …

---

## [Re-use connections for http-request](https://discourse.nodered.org/t/re-use-connections-for-http-request/1956)

<div class="topic-metadata">

**Author:** [@Archness](https://discourse.nodered.org/u/Archness)\
**Replies:** 3\
**Last updated:** [3 August 2018 07:27 UTC](https://discourse.nodered.org/t/re-use-connections-for-http-request/1956 "2018-08-03T07:27:18Z")

</div>

Hi, I'm working on building out some flows using the http-request nodes to download JSON payloads from an API. This API has data that changes every ~5 minutes and it takes ~2500-5000 calls to download all of the data (…

---

## [Help with some use of the SWITCH node](https://discourse.nodered.org/t/help-with-some-use-of-the-switch-node/2023)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 2\
**Last updated:** [3 August 2018 06:50 UTC](https://discourse.nodered.org/t/help-with-some-use-of-the-switch-node/2023 "2018-08-03T06:50:11Z")

</div>

The switch node allows you to switch the output depending on the input stream. I have found there is an "If all else" which is used if none of the parameters are met. But the situation has now arisen that I want a mess…

---

## [Node Red on PI. Improving reliability and recoverability](https://discourse.nodered.org/t/node-red-on-pi-improving-reliability-and-recoverability/2020)

<div class="topic-metadata">

**Author:** [@Erbachm](https://discourse.nodered.org/u/Erbachm)\
**Replies:** 1\
**Last updated:** [3 August 2018 05:12 UTC](https://discourse.nodered.org/t/node-red-on-pi-improving-reliability-and-recoverability/2020 "2018-08-03T05:12:24Z")

</div>

I'm at the point where I am looking for ways to improve the reliability and reduce time to recover Node Red on my Pi. Here's what I'm thinking of as a starting point. Move the userDir and nodesDir directories onto USB …

---

## [Query Editor not updating query](https://discourse.nodered.org/t/query-editor-not-updating-query/1940)

<div class="topic-metadata">

**Author:** [@TomMcAvoy](https://discourse.nodered.org/u/TomMcAvoy)\
**Replies:** 14\
**Last updated:** [3 August 2018 01:06 UTC](https://discourse.nodered.org/t/query-editor-not-updating-query/1940 "2018-08-03T01:06:00Z")

</div>

Hi Guys - brand new node red use I intsalled ODBC driver UNixODBC and it works using node-odbc I wanted to use node-red-contrib-odbc to connect to sybase and run a query However I have the following l- the query canno…

---

## [TCS34725 On Raspberry Pi](https://discourse.nodered.org/t/tcs34725-on-raspberry-pi/1949)

<div class="topic-metadata">

**Author:** [@bbpogul](https://discourse.nodered.org/u/bbpogul)\
**Replies:** 7\
**Last updated:** [3 August 2018 01:00 UTC](https://discourse.nodered.org/t/tcs34725-on-raspberry-pi/1949 "2018-08-03T01:00:30Z")

</div>

I am having issues pulling data from RGB sensor using Raspberry pi Zero. can anyone help me out with a sample code . this is my first post sorry for any wrong posting issues. \[{"id":"466a72cc.9b04fc","type":"tab","lab…

---

## [Create a flow to export a flow to github](https://discourse.nodered.org/t/create-a-flow-to-export-a-flow-to-github/2017)

<div class="topic-metadata">

**Author:** [@BlinkScooby](https://discourse.nodered.org/u/BlinkScooby)\
**Replies:** 3\
**Last updated:** [2 August 2018 23:45 UTC](https://discourse.nodered.org/t/create-a-flow-to-export-a-flow-to-github/2017 "2018-08-02T23:45:20Z")

</div>

Hey guys. I have been trying to workout a way to backup my flows. I know there is a way where you can backup the files off the filesystem. However I do not want that just incase of a crash. I would like to have them bac…

---

## [Access Node "Name" property to use in a ui\_template](https://discourse.nodered.org/t/access-node-name-property-to-use-in-a-ui-template/1928)

<div class="topic-metadata">

**Author:** [@tree-frog](https://discourse.nodered.org/u/tree-frog)\
**Replies:** 10\
**Last updated:** [2 August 2018 19:05 UTC](https://discourse.nodered.org/t/access-node-name-property-to-use-in-a-ui-template/1928 "2018-08-02T19:05:53Z")

</div>

I'm using ui\_templates to set color background to text boxes. They also have a label which I would like to use the "Name" property of the node to display the label for easy setup and since the name is a blank in the ui\_…

---

## [Unable to use nodes after install](https://discourse.nodered.org/t/unable-to-use-nodes-after-install/2005)

<div class="topic-metadata">

**Author:** [@E.Strobel](https://discourse.nodered.org/u/E.Strobel)\
**Replies:** 12\
**Last updated:** [2 August 2018 15:45 UTC](https://discourse.nodered.org/t/unable-to-use-nodes-after-install/2005 "2018-08-02T15:45:55Z")

</div>

After installing a few new nodes, I am unable to use them. When I go into "Manage Palette", I can see they are installed but the small box to the left of their title is grayed out. I have rebooted my pi after the install…

---

## [Data Poll Flicker](https://discourse.nodered.org/t/data-poll-flicker/1992)

<div class="topic-metadata">

**Author:** [@manfacro](https://discourse.nodered.org/u/manfacro)\
**Replies:** 3\
**Last updated:** [2 August 2018 15:38 UTC](https://discourse.nodered.org/t/data-poll-flicker/1992 "2018-08-02T15:38:37Z")

</div>

I'm having a little issues with trying to figure out how to stop a dashboard text node from flickering. I am sending a command to the EXEC node to get some data, and the string is returned to a text node on the dashboard…

---

## [Using AngularJs for node interface](https://discourse.nodered.org/t/using-angularjs-for-node-interface/1966)

<div class="topic-metadata">

**Author:** [@CatalinFetoiu](https://discourse.nodered.org/u/CatalinFetoiu)\
**Replies:** 8\
**Last updated:** [2 August 2018 14:11 UTC](https://discourse.nodered.org/t/using-angularjs-for-node-interface/1966 "2018-08-02T14:11:53Z")

</div>

Hello, Is there an example of how to use AngularJs for building the UI of a node? I am talking about using it in the .html file associated with a node, because I did not manage to find an example about this. Thank you …

---

## [Allow only one instance of a config node \[solved\]](https://discourse.nodered.org/t/allow-only-one-instance-of-a-config-node-solved/2004)

<div class="topic-metadata">

**Author:** [@Dr.legendaddy](https://discourse.nodered.org/u/Dr.legendaddy)\
**Replies:** 2\
**Last updated:** [2 August 2018 12:21 UTC](https://discourse.nodered.org/t/allow-only-one-instance-of-a-config-node-solved/2004 "2018-08-02T12:21:22Z")

</div>

Hello everybody! I was wondering if it was somehow possible to build a config node that allows only one instance of itself at any time. Maybe there is some obvious way but my google and forum research did'nt yield anyth…

---

## [Read from cloudant db last documents](https://discourse.nodered.org/t/read-from-cloudant-db-last-documents/1927)

<div class="topic-metadata">

**Author:** [@Ahd](https://discourse.nodered.org/u/Ahd)\
**Replies:** 2\
**Last updated:** [2 August 2018 09:26 UTC](https://discourse.nodered.org/t/read-from-cloudant-db-last-documents/1927 "2018-08-02T09:26:39Z")

</div>

Hi all I am new to node red, I will appreciate your help and guidance, please. I am working on flow in node red, this flow has three function nodes: founction1 received data from temp a sensor and function 2 is recei…

---

## [Stuck with delay node](https://discourse.nodered.org/t/stuck-with-delay-node/1987)

<div class="topic-metadata">

**Author:** [@dystechnic](https://discourse.nodered.org/u/dystechnic)\
**Replies:** 2\
**Last updated:** [2 August 2018 08:26 UTC](https://discourse.nodered.org/t/stuck-with-delay-node/1987 "2018-08-02T08:26:51Z")

</div>

Hi, I am running into an issue with a function i thought was rather simple. But it drives me mad :wink: I am trying to change the state of a lamp, and that works fine until I add a delay node. This is my function (sim…

---

## [More button colour control - a whole new saga](https://discourse.nodered.org/t/more-button-colour-control-a-whole-new-saga/1989)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 0\
**Last updated:** [1 August 2018 23:27 UTC](https://discourse.nodered.org/t/more-button-colour-control-a-whole-new-saga/1989 "2018-08-01T23:27:39Z")

</div>

Well, I'm not sure Dashboard is the right thing, but..... I've recently posted a flow with buttons that change colour as you press them with indicator LEDs to show what is happening and if there is a difference. That w…

---

## [Exec node error when running terminal commands](https://discourse.nodered.org/t/exec-node-error-when-running-terminal-commands/1839)

<div class="topic-metadata">

**Author:** [@mshaz](https://discourse.nodered.org/u/mshaz)\
**Replies:** 19\
**Last updated:** [1 August 2018 23:13 UTC](https://discourse.nodered.org/t/exec-node-error-when-running-terminal-commands/1839 "2018-08-01T23:13:49Z")

</div>

i have error when using exec node to run commands . It works on the terminal. It streams video to youtube. Can anyone help me how to run commands from nodered? Thank you

---

## [\[new node\]: node-red-contrib-cheerio-function](https://discourse.nodered.org/t/new-node-node-red-contrib-cheerio-function/1982)

<div class="topic-metadata">

**Author:** [@t4skforce1337](https://discourse.nodered.org/u/t4skforce1337)\
**Replies:** 8\
**Last updated:** [1 August 2018 21:38 UTC](https://discourse.nodered.org/t/new-node-node-red-contrib-cheerio-function/1982 "2018-08-01T21:38:21Z")

</div>

New node to be added to https://flows.nodered.org: https://www.npmjs.com/package/node-red-contrib-cheerio-function

---

## [iNSERT CSV DATA IN MS ACCESS](https://discourse.nodered.org/t/insert-csv-data-in-ms-access/1985)

<div class="topic-metadata">

**Author:** [@rbauwens3263](https://discourse.nodered.org/u/rbauwens3263)\
**Replies:** 2\
**Last updated:** [1 August 2018 20:32 UTC](https://discourse.nodered.org/t/insert-csv-data-in-ms-access/1985 "2018-08-01T20:32:53Z")

</div>

I am trying to insert an CSV string into an MS ACCESS DB-Base - any idea which NODE to use ?

---

## [Debug Window Control](https://discourse.nodered.org/t/debug-window-control/1973)

<div class="topic-metadata">

**Author:** [@jfehl](https://discourse.nodered.org/u/jfehl)\
**Replies:** 1\
**Last updated:** [1 August 2018 15:28 UTC](https://discourse.nodered.org/t/debug-window-control/1973 "2018-08-01T15:28:33Z")

</div>

Looking for help on controlling my debug window. If I have a message in the debug window and am trying to investigate it, sometimes it will just disappear. Is there a way to freeze the pane so messages can't escape fro…

---

## [Password Change and Profile Facility and User Accounts](https://discourse.nodered.org/t/password-change-and-profile-facility-and-user-accounts/1974)

<div class="topic-metadata">

**Author:** [@anwarbashir](https://discourse.nodered.org/u/anwarbashir)\
**Replies:** 0\
**Last updated:** [1 August 2018 15:18 UTC](https://discourse.nodered.org/t/password-change-and-profile-facility-and-user-accounts/1974 "2018-08-01T15:18:11Z")

</div>

I have Node-RED applications on CF Bluemix. I can create additional applications using ToolChain and Git. At the moment I create an application and then run it to configure with username and password. To change the pass…

---

## [NR no longer works on some remote machines](https://discourse.nodered.org/t/nr-no-longer-works-on-some-remote-machines/1967)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 7\
**Last updated:** [1 August 2018 11:16 UTC](https://discourse.nodered.org/t/nr-no-longer-works-on-some-remote-machines/1967 "2018-08-01T11:16:47Z")

</div>

Now quite as bad as my other post where I thought I had killed the remote machine. I was going through updating the machines and NR. (Too many different versions to be nice.) Some/most updated nicely. A few didn't. …

---

## [Overall Data Display](https://discourse.nodered.org/t/overall-data-display/1899)

<div class="topic-metadata">

**Author:** [@rishanaziz](https://discourse.nodered.org/u/rishanaziz)\
**Replies:** 11\
**Last updated:** [1 August 2018 11:25 UTC](https://discourse.nodered.org/t/overall-data-display/1899 "2018-08-01T11:25:47Z")

</div>

Hi, I tried to display the data from the database in table. The following is the flow: \[{"id":"6e94e3b6.53c1ec","type":"mui\_template","z":"ada4ecf1.32178","group":"119d1a72.024226","name":"","order":2,"width":"30","h…

---

## [The most basic of questions](https://discourse.nodered.org/t/the-most-basic-of-questions/1961)

<div class="topic-metadata">

**Author:** [@TheRiddler](https://discourse.nodered.org/u/TheRiddler)\
**Replies:** 7\
**Last updated:** [1 August 2018 09:24 UTC](https://discourse.nodered.org/t/the-most-basic-of-questions/1961 "2018-08-01T09:24:58Z")

</div>

I'm sure the answer to this is so simple yet my lack of programming knowledge is letting me down. I want to build a flow that collects the bollean status from the Switch component on a dashboard and passes that status, …

---

## [Switching tabs issue](https://discourse.nodered.org/t/switching-tabs-issue/1964)

<div class="topic-metadata">

**Author:** [@realjax](https://discourse.nodered.org/u/realjax)\
**Replies:** 0\
**Last updated:** [1 August 2018 08:15 UTC](https://discourse.nodered.org/t/switching-tabs-issue/1964 "2018-08-01T08:15:32Z")

</div>

Hi, I have a ui-template containing this: \<div id="{{'my\_'+$id}}"\>no data\</div\> \<script\> (function(scope) { scope.$watch('msg.payload', function(data) { if (data) { // Do something when msg arrives c…

---

## [Using "moment" node. Not quite there](https://discourse.nodered.org/t/using-moment-node-not-quite-there/1962)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 2\
**Last updated:** [1 August 2018 07:51 UTC](https://discourse.nodered.org/t/using-moment-node-not-quite-there/1962 "2018-08-01T07:51:09Z")

</div>

The MOMENT node is supposed to help with date/time formatting. I am wanting to Human readable timestamp a message and write it to a file with other data. This is the flow, and it nearly gets the right time: Local date…

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

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