# Latest

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

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

**Page:** 748

---

## [MSSQL-Plus - Appending the Query output to incoming payload.msg](https://discourse.nodered.org/t/mssql-plus-appending-the-query-output-to-incoming-payload-msg/49926)

<div class="topic-metadata">

**Author:** [@tusharacc](https://discourse.nodered.org/u/tusharacc)\
**Replies:** 2\
**Last updated:** [24 August 2021 19:29 UTC](https://discourse.nodered.org/t/mssql-plus-appending-the-query-output-to-incoming-payload-msg/49926 "2021-08-24T19:29:06Z")

</div>

I am building a simple workflow using Node-Red and Ms-SQL. The MS-SQL Node receives an dictionary object with multiple key-value. MS-SQL node is executing in query mode, and returns value from database. My requirement is…

---

## [GPS and GPRS on one serial port](https://discourse.nodered.org/t/gps-and-gprs-on-one-serial-port/50108)

<div class="topic-metadata">

**Author:** [@John\_Barry](https://discourse.nodered.org/u/John_Barry)\
**Replies:** 3\
**Last updated:** [24 August 2021 18:44 UTC](https://discourse.nodered.org/t/gps-and-gprs-on-one-serial-port/50108 "2021-08-24T18:44:10Z")

</div>

Hi All, I have a waveshare GSM/GPRS/GNSS hat I can send and receive AT commands in node red but i also need internet connectivity from the hat. The problem seems to be that these are two conflicting process on the sam…

---

## [NodeRed OPC UA Client always "Closed"](https://discourse.nodered.org/t/nodered-opc-ua-client-always-closed/50106)

<div class="topic-metadata">

**Author:** [@SE\_Val](https://discourse.nodered.org/u/SE_Val)\
**Replies:** 0\
**Last updated:** [24 August 2021 09:58 UTC](https://discourse.nodered.org/t/nodered-opc-ua-client-always-closed/50106 "2021-08-24T09:58:07Z")

</div>

Hello, I have some problems connecting the NodeRed OPC UA client to my OPC UA server. As you can see, my OPC UA Client is closed but I dont understand why... I'm sure of the address (I can connect myself to the s…

---

## [Stack trace for SyntaxError hides the actual point of failure](https://discourse.nodered.org/t/stack-trace-for-syntaxerror-hides-the-actual-point-of-failure/50117)

<div class="topic-metadata">

**Author:** [@lowlyocean](https://discourse.nodered.org/u/lowlyocean)\
**Replies:** 1\
**Last updated:** [24 August 2021 16:45 UTC](https://discourse.nodered.org/t/stack-trace-for-syntaxerror-hides-the-actual-point-of-failure/50117 "2021-08-24T16:45:44Z")

</div>

Hi all, I've reported an issue for node-red-contrib-alexa-remote2-applestrudel where Debug panel shows me a generic error "Invalid or unexpected token" which I'm not then able to trace back to point of failure. Even if …

---

## [Google Sheet - Multiple Cells](https://discourse.nodered.org/t/google-sheet-multiple-cells/50075)

<div class="topic-metadata">

**Author:** [@DoubleDutch](https://discourse.nodered.org/u/DoubleDutch)\
**Replies:** 2\
**Last updated:** [24 August 2021 16:40 UTC](https://discourse.nodered.org/t/google-sheet-multiple-cells/50075 "2021-08-24T16:40:00Z")

</div>

Apologies for this very basic question but - Using Home Assistant, I’m trying to store temperature data in a google sheet. It works but the flow below only puts the temperature in the sheet and I would like the current d…

---

## [Remote observation of published MQTT values](https://discourse.nodered.org/t/remote-observation-of-published-mqtt-values/50115)

<div class="topic-metadata">

**Author:** [@CanadianTesla](https://discourse.nodered.org/u/CanadianTesla)\
**Replies:** 4\
**Last updated:** [24 August 2021 16:10 UTC](https://discourse.nodered.org/t/remote-observation-of-published-mqtt-values/50115 "2021-08-24T16:10:35Z")

</div>

I am new at both node-red and MQTT protocol. I use mosquito as a broker in my local computer. I want to observe my values remotely. By saying remotely, i mean outside of node-red dashboard. I guess i need to use a web s…

---

## [Add quotes to Json Value](https://discourse.nodered.org/t/add-quotes-to-json-value/50096)

<div class="topic-metadata">

**Author:** [@Le-bo2d9](https://discourse.nodered.org/u/Le-bo2d9)\
**Replies:** 2\
**Last updated:** [24 August 2021 14:27 UTC](https://discourse.nodered.org/t/add-quotes-to-json-value/50096 "2021-08-24T14:27:45Z")

</div>

Hi I'm totally new to node-red and need some help I'm getting values of a flow sensor via MQTT {"FlowRate":0.19,"TotalVolume":11354.25,"KValues":\[{"Item1":19.0,"Item2":24.0},{"Item1":38.0,"Item2":61.0},{"Item1":57.0,"I…

---

## [BACnet-Read - Problem](https://discourse.nodered.org/t/bacnet-read-problem/50050)

<div class="topic-metadata">

**Author:** [@projecttwo](https://discourse.nodered.org/u/projecttwo)\
**Replies:** 15\
**Last updated:** [24 August 2021 14:22 UTC](https://discourse.nodered.org/t/bacnet-read-problem/50050 "2021-08-24T14:22:31Z")

</div>

Hey, can anybody help here:

---

## [Keyboard repeat behavior](https://discourse.nodered.org/t/keyboard-repeat-behavior/50113)

<div class="topic-metadata">

**Author:** [@simcop2387](https://discourse.nodered.org/u/simcop2387)\
**Replies:** 1\
**Last updated:** [24 August 2021 14:04 UTC](https://discourse.nodered.org/t/keyboard-repeat-behavior/50113 "2021-08-24T14:04:52Z")

</div>

I'm making a flow that takes user input (in this case from an IR remote ultimately). I can get about 10 events per second from holding down a button on the remote, so what I want to do is implement some kind of hold dow…

---

## [Dashboard template led array problems](https://discourse.nodered.org/t/dashboard-template-led-array-problems/50022)

<div class="topic-metadata">

**Author:** [@ozpos](https://discourse.nodered.org/u/ozpos)\
**Replies:** 36\
**Last updated:** [24 August 2021 14:00 UTC](https://discourse.nodered.org/t/dashboard-template-led-array-problems/50022 "2021-08-24T14:00:05Z")

</div>

The conversation began here https://discourse.nodered.org/t/led-icon-changed/656/16?u=ozpos I have made significant progress but still have a couple of problems. \[ { "id": "77b9551a682cccf9", "…

---

## [Node-red interface](https://discourse.nodered.org/t/node-red-interface/50099)

<div class="topic-metadata">

**Author:** [@snowbot](https://discourse.nodered.org/u/snowbot)\
**Replies:** 2\
**Last updated:** [24 August 2021 13:54 UTC](https://discourse.nodered.org/t/node-red-interface/50099 "2021-08-24T13:54:04Z")

</div>

Hi All on my dashboard node-red the filters node input is not present who can help me for this problem Thank you

---

## [Calculate unbalanced load](https://discourse.nodered.org/t/calculate-unbalanced-load/50110)

<div class="topic-metadata">

**Author:** [@Becker](https://discourse.nodered.org/u/Becker)\
**Replies:** 1\
**Last updated:** [24 August 2021 12:59 UTC](https://discourse.nodered.org/t/calculate-unbalanced-load/50110 "2021-08-24T12:59:21Z")

</div>

Hi, I´ve made a function which is calculating the "unbalanced load" from grid ("Schieflast"). but in the case, when 2 values are the same I get "0". example: I1 = 12A I2 = -15A I3 = -15A \[ { "id": "bc9…

---

## [Dashboard Title Color change](https://discourse.nodered.org/t/dashboard-title-color-change/50084)

<div class="topic-metadata">

**Author:** [@dpatel2016](https://discourse.nodered.org/u/dpatel2016)\
**Replies:** 6\
**Last updated:** [24 August 2021 13:03 UTC](https://discourse.nodered.org/t/dashboard-title-color-change/50084 "2021-08-24T13:03:11Z")

</div>

I have a custom theme for my dashboard and I want to change the color of the main title of the dashboard. Does anyone have a solution? Thank you!

---

## [How to parse the tags of influxdb in nodered?](https://discourse.nodered.org/t/how-to-parse-the-tags-of-influxdb-in-nodered/50103)

<div class="topic-metadata">

**Author:** [@Nathanli](https://discourse.nodered.org/u/Nathanli)\
**Replies:** 1\
**Last updated:** [24 August 2021 10:09 UTC](https://discourse.nodered.org/t/how-to-parse-the-tags-of-influxdb-in-nodered/50103 "2021-08-24T10:09:01Z")

</div>

{"host": "test0", "latitude":25, "longitude":111, "temperature":28} I want to import the uploaded JSON data into the database and set the host as a tag, how can I do that?

---

## [Tcp request node does not always throw on error](https://discourse.nodered.org/t/tcp-request-node-does-not-always-throw-on-error/50060)

<div class="topic-metadata">

**Author:** [@r0ller](https://discourse.nodered.org/u/r0ller)\
**Replies:** 12\
**Last updated:** [24 August 2021 09:59 UTC](https://discourse.nodered.org/t/tcp-request-node-does-not-always-throw-on-error/50060 "2021-08-24T09:59:05Z")

</div>

Hi All, It seems that the tcp request node does not always throw on error. I don't know how it's possible but if I use only a catch node to catch its errors, it mostly works but from time to time it fails. The workaroun…

---

## [Node-red-contrib-image-tools - combining images](https://discourse.nodered.org/t/node-red-contrib-image-tools-combining-images/50081)

<div class="topic-metadata">

**Author:** [@RaptorUK](https://discourse.nodered.org/u/RaptorUK)\
**Replies:** 2\
**Last updated:** [24 August 2021 07:01 UTC](https://discourse.nodered.org/t/node-red-contrib-image-tools-combining-images/50081 "2021-08-24T07:01:08Z")

</div>

Hi folks, the node red project I'm currently working on in my day job is at the point of being usable but I have to make an adjustment to my label (printed on a Dymo 450 thermal printer). The label is attached to a PCB…

---

## [Russian and French translations needed for the Blockly node](https://discourse.nodered.org/t/russian-and-french-translations-needed-for-the-blockly-node/49905)

<div class="topic-metadata">

**Author:** [@BartButenaers](https://discourse.nodered.org/u/BartButenaers)\
**Replies:** 5\
**Last updated:** [24 August 2021 06:56 UTC](https://discourse.nodered.org/t/russian-and-french-translations-needed-for-the-blockly-node/49905 "2021-08-24T06:56:40Z")

</div>

Hi folks, @cymplecy and I want to publish version 2.0.0 of the node-red-contrib-blockly node on NPM. However we still need Russian and French translations for some sentences, since we got no response from the original …

---

## [Build @node-red/editor-client](https://discourse.nodered.org/t/build-node-red-editor-client/50049)

<div class="topic-metadata">

**Author:** [@chiche](https://discourse.nodered.org/u/chiche)\
**Replies:** 3\
**Last updated:** [24 August 2021 05:54 UTC](https://discourse.nodered.org/t/build-node-red-editor-client/50049 "2021-08-24T05:54:41Z")

</div>

I have some changes in deploy.js @node-red/editor-client. How can I build it and work with the node-red system?

---

## [Calculating the intersection of spheres \[Trilateration Calculation\]](https://discourse.nodered.org/t/calculating-the-intersection-of-spheres-trilateration-calculation/50005)

<div class="topic-metadata">

**Author:** [@ScheepersJohan](https://discourse.nodered.org/u/ScheepersJohan)\
**Replies:** 8\
**Last updated:** [24 August 2021 05:01 UTC](https://discourse.nodered.org/t/calculating-the-intersection-of-spheres-trilateration-calculation/50005 "2021-08-24T05:01:17Z")

</div>

Hi Everyone, I have a mathematical calculation I needed solved, to do with the intersection of spheres. I have a node transmitting a message and it is received by 3 or more gateways (base stations). The location of the…

---

## [Help to auto refresh page after tab\`s transition](https://discourse.nodered.org/t/help-to-auto-refresh-page-after-tab-s-transition/50090)

<div class="topic-metadata">

**Author:** [@luisof16](https://discourse.nodered.org/u/luisof16)\
**Replies:** 0\
**Last updated:** [24 August 2021 03:48 UTC](https://discourse.nodered.org/t/help-to-auto-refresh-page-after-tab-s-transition/50090 "2021-08-24T03:48:49Z")

</div>

Hello everyone , I newbie in node red, I try to make auto refresh web page after self transition of tabs, I try with ui\_template using "location.reload()" but was cycling in reload process , also try using function…

---

## [Set Auto Focus in text\_ui in dashboard](https://discourse.nodered.org/t/set-auto-focus-in-text-ui-in-dashboard/49894)

<div class="topic-metadata">

**Author:** [@luisof16](https://discourse.nodered.org/u/luisof16)\
**Replies:** 2\
**Last updated:** [24 August 2021 03:34 UTC](https://discourse.nodered.org/t/set-auto-focus-in-text-ui-in-dashboard/49894 "2021-08-24T03:34:53Z")

</div>

Hello everyone I ´m newbie in Node Red , I try to set autofocus in text\_ui in dashboard, I was reading this forum: UI Text Input Focus - #3 by coffeegoat but isn´t working maybe I don´t understand how do it, I att…

---

## [Ui control empty payload refreshes all sessions](https://discourse.nodered.org/t/ui-control-empty-payload-refreshes-all-sessions/49957)

<div class="topic-metadata">

**Author:** [@Sean-McG](https://discourse.nodered.org/u/Sean-McG)\
**Replies:** 7\
**Last updated:** [23 August 2021 23:56 UTC](https://discourse.nodered.org/t/ui-control-empty-payload-refreshes-all-sessions/49957 "2021-08-23T23:56:35Z")

</div>

Is it normal operation that an empty payload refreshes ALL sessions even if it has a socket id ? payload: "" socketid: "Nkflidq9yLTqULbUAAJb"

---

## [Dashboard access tab by name instead of id](https://discourse.nodered.org/t/dashboard-access-tab-by-name-instead-of-id/50056)

<div class="topic-metadata">

**Author:** [@Simon01011](https://discourse.nodered.org/u/Simon01011)\
**Replies:** 2\
**Last updated:** [23 August 2021 22:35 UTC](https://discourse.nodered.org/t/dashboard-access-tab-by-name-instead-of-id/50056 "2021-08-23T22:35:10Z")

</div>

Hello everybody! I know I can access my dashboard with localhost:1880/ui/!#/ and I can access a specific tab by attaching its id at the end. What I'd like to do: access a tab by its name, so that I don't have to adjust…

---

## [Installing Node red on Raspberry PI with Windows OS](https://discourse.nodered.org/t/installing-node-red-on-raspberry-pi-with-windows-os/50078)

<div class="topic-metadata">

**Author:** [@AlanConti161](https://discourse.nodered.org/u/AlanConti161)\
**Replies:** 5\
**Last updated:** [23 August 2021 19:01 UTC](https://discourse.nodered.org/t/installing-node-red-on-raspberry-pi-with-windows-os/50078 "2021-08-23T19:01:05Z")

</div>

Hello, I'm a newbye in Node red. I have here a Raspberry PI with Windows OS installed in it and I would like to install node red in it. My question is whether I should follow installation instructions for when you need t…

---

## [How add button in each rows of table](https://discourse.nodered.org/t/how-add-button-in-each-rows-of-table/50065)

<div class="topic-metadata">

**Author:** [@oualid](https://discourse.nodered.org/u/oualid)\
**Replies:** 1\
**Last updated:** [23 August 2021 17:21 UTC](https://discourse.nodered.org/t/how-add-button-in-each-rows-of-table/50065 "2021-08-23T17:21:23Z")

</div>

hi, could you please help me to add button in each row of table. i already googled, but i did not find any example. please find in the below my html code. \<table class= "content-table" \> \<tr\> …

---

## [Not able to access nodered.org](https://discourse.nodered.org/t/not-able-to-access-nodered-org/50069)

<div class="topic-metadata">

**Author:** [@anilsagar](https://discourse.nodered.org/u/anilsagar)\
**Replies:** 2\
**Last updated:** [23 August 2021 16:10 UTC](https://discourse.nodered.org/t/not-able-to-access-nodered-org/50069 "2021-08-23T16:10:50Z")

</div>

Not able to access nodered.org from any browser. Even other people from other locations not able to access the website. Is there any issue with nodered server? Also, not able to install new contrib nodes from the palette…

---

## [BACnet data read, write, release from Node Red via Rest](https://discourse.nodered.org/t/bacnet-data-read-write-release-from-node-red-via-rest/50068)

<div class="topic-metadata">

**Author:** [@bbartling](https://discourse.nodered.org/u/bbartling)\
**Replies:** 0\
**Last updated:** [23 August 2021 15:40 UTC](https://discourse.nodered.org/t/bacnet-data-read-write-release-from-node-red-via-rest/50068 "2021-08-23T15:40:10Z")

</div>

Hi, I made a rest interface with Python and Flask to take advantage of the Python based BACnet stacks. The Python based BACnet stacks are well supported and used in industry, versus I think the javascript BACnet stacks …

---

## [How to do multiple http get request for every 10 seconds without inject node](https://discourse.nodered.org/t/how-to-do-multiple-http-get-request-for-every-10-seconds-without-inject-node/49748)

<div class="topic-metadata">

**Author:** [@cenbek53](https://discourse.nodered.org/u/cenbek53)\
**Replies:** 15\
**Last updated:** [23 August 2021 15:37 UTC](https://discourse.nodered.org/t/how-to-do-multiple-http-get-request-for-every-10-seconds-without-inject-node/49748 "2021-08-23T15:37:47Z")

</div>

Hi there, i am working on a project where i make a get request to a server which returns me the connection state of systems and machines as JSON. i use this return value to visualize the connection states in node red: …

---

## [InfluxDB query returning no results](https://discourse.nodered.org/t/influxdb-query-returning-no-results/49849)

<div class="topic-metadata">

**Author:** [@bkenobi](https://discourse.nodered.org/u/bkenobi)\
**Replies:** 18\
**Last updated:** [23 August 2021 14:55 UTC](https://discourse.nodered.org/t/influxdb-query-returning-no-results/49849 "2021-08-23T14:55:53Z")

</div>

This is a question of how to properly construct an InfluxDB query which is out of scope of NR. If there are no experts here I will submit to the InfluxDB forum instead. I generally find this forum awesome and figured I…

---

## [Cannot authenticate to Github](https://discourse.nodered.org/t/cannot-authenticate-to-github/50026)

<div class="topic-metadata">

**Author:** [@solarslurpie](https://discourse.nodered.org/u/solarslurpie)\
**Replies:** 2\
**Last updated:** [23 August 2021 12:48 UTC](https://discourse.nodered.org/t/cannot-authenticate-to-github/50026 "2021-08-23T12:48:43Z")

</div>

I just started using projects because I want to use Github. When I enter my username and password, the dialog box keeps asking me to retry. I know I am entering the right username and password. Why isn't node-red acce…

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

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