# Latest

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

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

**Page:** 364

---

## [User Input start date and stop date, and how to extract data from the sql according to dates](https://discourse.nodered.org/t/user-input-start-date-and-stop-date-and-how-to-extract-data-from-the-sql-according-to-dates/77378)

<div class="topic-metadata">

**Author:** [@ksthar](https://discourse.nodered.org/u/ksthar)\
**Replies:** 8\
**Last updated:** [9 April 2023 10:54 UTC](https://discourse.nodered.org/t/user-input-start-date-and-stop-date-and-how-to-extract-data-from-the-sql-according-to-dates/77378 "2023-04-09T10:54:25Z")

</div>

Hello everyone, I would like to ask something regarding to take out the data from the mySQL database. I took the start date and stop date with the date picker node. ///////////////////////////////////////////////////…

---

## [How to determine if a dashboard tab is active](https://discourse.nodered.org/t/how-to-determine-if-a-dashboard-tab-is-active/77284)

<div class="topic-metadata">

**Author:** [@Moosbueffel](https://discourse.nodered.org/u/Moosbueffel)\
**Replies:** 6\
**Last updated:** [9 April 2023 09:54 UTC](https://discourse.nodered.org/t/how-to-determine-if-a-dashboard-tab-is-active/77284 "2023-04-09T09:54:58Z")

</div>

Is there a way to see in a flow, if a dashboard tab is visible? Somthing like a gate, to only continue flow, if tab is visible.

---

## [Yet another dropdown list Q](https://discourse.nodered.org/t/yet-another-dropdown-list-q/77281)

<div class="topic-metadata">

**Author:** [@znetsixe](https://discourse.nodered.org/u/znetsixe)\
**Replies:** 14\
**Last updated:** [9 April 2023 09:21 UTC](https://discourse.nodered.org/t/yet-another-dropdown-list-q/77281 "2023-04-09T09:21:56Z")

</div>

Hey hey, Been searching the forum but havent found the answer I was searching for. Appologies in advance if it is in here some where but havent seen it. I want to generate a custom dropdown box from an existing object …

---

## [\[Flexdash\]: dark theme and b/w text / value color](https://discourse.nodered.org/t/flexdash-dark-theme-and-b-w-text-value-color/77355)

<div class="topic-metadata">

**Author:** [@PLCMercenary](https://discourse.nodered.org/u/PLCMercenary)\
**Replies:** 2\
**Last updated:** [9 April 2023 04:10 UTC](https://discourse.nodered.org/t/flexdash-dark-theme-and-b-w-text-value-color/77355 "2023-04-09T04:10:58Z")

</div>

Hello All, I have tried reading all of the threads and I have been through the flexdash docs several times, and I havent found any discussion about how to either 1) detect that dark mode is selected on client so that wid…

---

## [WYSIWYG Editor for Dashboard](https://discourse.nodered.org/t/wysiwyg-editor-for-dashboard/41701)

<div class="topic-metadata">

**Author:** [@linhtranvu](https://discourse.nodered.org/u/linhtranvu)\
**Replies:** 4\
**Last updated:** [9 April 2023 04:09 UTC](https://discourse.nodered.org/t/wysiwyg-editor-for-dashboard/41701 "2023-04-09T04:09:10Z")

</div>

This project start as a side-project of mobile app client for Node-RED. At first, it is an experiment with a "hack" to real dashboard. However, I have decided to rework and make a real WYSIWYG Editor in Admin, with stabl…

---

## [Best Practices - Subflow versionning between multiple NR instances](https://discourse.nodered.org/t/best-practices-subflow-versionning-between-multiple-nr-instances/77344)

<div class="topic-metadata">

**Author:** [@Barbudor](https://discourse.nodered.org/u/Barbudor)\
**Replies:** 6\
**Last updated:** [8 April 2023 19:28 UTC](https://discourse.nodered.org/t/best-practices-subflow-versionning-between-multiple-nr-instances/77344 "2023-04-08T19:28:00Z")

</div>

Hi everyone We are using multiple NR instances and we have designed a few tenth of subflows to manage API calls to our system + other re-usable pieces of flows. We now have a lot of trouble to manage coherency and vers…

---

## [https://www.reddit.com/r/nodered/comments/bw6o84/gnuroot\_debian/](https://discourse.nodered.org/t/https-www-reddit-com-r-nodered-comments-bw6o84-gnuroot-debian/11785)

<div class="topic-metadata">

**Author:** [@SoumyadeepChatterjee](https://discourse.nodered.org/u/SoumyadeepChatterjee)\
**Replies:** 4\
**Last updated:** [7 April 2023 11:54 UTC](https://discourse.nodered.org/t/https-www-reddit-com-r-nodered-comments-bw6o84-gnuroot-debian/11785 "2023-04-07T11:54:42Z")

</div>

I have got a android device running 4.1.2 and I wanted to use it as a Node-Red server and for that i rooted it and installed GNURoot Debian and now that I ran the commands the nodejs version is not updated enough for the…

---

## [IR Device and Tuya Local](https://discourse.nodered.org/t/ir-device-and-tuya-local/75772)

<div class="topic-metadata">

**Author:** [@meccip](https://discourse.nodered.org/u/meccip)\
**Replies:** 1\
**Last updated:** [7 April 2023 17:18 UTC](https://discourse.nodered.org/t/ir-device-and-tuya-local/75772 "2023-04-07T17:18:35Z")

</div>

Hello, I have a S06ProWB3S IR Device with temperature and humidity. I use it with Tuya and i control my air conditioner and tv from tuya app. I try to use it with nodered to start my AC when I get to much power from my …

---

## [Uibuilder quick update](https://discourse.nodered.org/t/uibuilder-quick-update/77366)

<div class="topic-metadata">

**Author:** [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Replies:** 0\
**Last updated:** [8 April 2023 15:18 UTC](https://discourse.nodered.org/t/uibuilder-quick-update/77366 "2023-04-08T15:18:06Z")

</div>

For folk following the ongoing progress of uibuilder development. v6.4 is in development. So far with just a few improvements baked in. The big one so far being that I've added VSCode links if you are running Node-RE…

---

## [How to properly handle node.done()](https://discourse.nodered.org/t/how-to-properly-handle-node-done/77315)

<div class="topic-metadata">

**Author:** [@thalesmaoa](https://discourse.nodered.org/u/thalesmaoa)\
**Replies:** 19\
**Last updated:** [8 April 2023 14:17 UTC](https://discourse.nodered.org/t/how-to-properly-handle-node-done/77315 "2023-04-08T14:17:39Z")

</div>

I'm a little confused about node.done() function and how to use it after a for loop. Let's suppose that I have 10 messages to send async. I must tell nodered the that it has finished due to timeout issues. In my exampl…

---

## [Settings.js httpStatic feature to pass options to express.static (non-breaking)](https://discourse.nodered.org/t/settings-js-httpstatic-feature-to-pass-options-to-express-static-non-breaking/76688)

<div class="topic-metadata">

**Author:** [@kevinGodell](https://discourse.nodered.org/u/kevinGodell)\
**Replies:** 2\
**Last updated:** [8 April 2023 13:27 UTC](https://discourse.nodered.org/t/settings-js-httpstatic-feature-to-pass-options-to-express-static-non-breaking/76688 "2023-04-08T13:27:02Z")

</div>

I would like to extend the functionality of httpStatic in settings.js to receive an options object and have that passed to express.static(filePath, options). The change would be non-breaking and give a finer control ove…

---

## [Dashboard widgets, msg.className should append to not replace widget's Class](https://discourse.nodered.org/t/dashboard-widgets-msg-classname-should-append-to-not-replace-widgets-class/77363)

<div class="topic-metadata">

**Author:** [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Replies:** 2\
**Last updated:** [8 April 2023 12:41 UTC](https://discourse.nodered.org/t/dashboard-widgets-msg-classname-should-append-to-not-replace-widgets-class/77363 "2023-04-08T12:41:49Z")

</div>

Dashboard widgets eg switches can defined as Class "STEAM" in the editor. Now groups of widgets can be styled alike across dashboard tabs and groups The CSS path is ... md-card.nr-dashboard-switch.\[blah\].STEAM.visible…

---

## [There are no new node posts in Mastodon Node-RED Nodes](https://discourse.nodered.org/t/there-are-no-new-node-posts-in-mastodon-node-red-nodes/77334)

<div class="topic-metadata">

**Author:** [@Folgore](https://discourse.nodered.org/u/Folgore)\
**Replies:** 6\
**Last updated:** [7 April 2023 20:33 UTC](https://discourse.nodered.org/t/there-are-no-new-node-posts-in-mastodon-node-red-nodes/77334 "2023-04-07T20:33:36Z")

</div>

Hi @knolleary and @cymplecy(for knowledge) , there is a problem with a new posts @nodes@social.nodered.org Mastodon channel. I receive the news only from twitter. For help, I have used a rss node with certificate expir…

---

## [Accessing external libraries](https://discourse.nodered.org/t/accessing-external-libraries/77340)

<div class="topic-metadata">

**Author:** [@bwims](https://discourse.nodered.org/u/bwims)\
**Replies:** 15\
**Last updated:** [7 April 2023 20:23 UTC](https://discourse.nodered.org/t/accessing-external-libraries/77340 "2023-04-07T20:23:01Z")

</div>

Hello! One for the JS programmers... I can gain access to an external library using the setup tab of the function node and this works well in the case where access is gained either by a "require (module)" or an "import…

---

## [DOMParser https stream](https://discourse.nodered.org/t/domparser-https-stream/77350)

<div class="topic-metadata">

**Author:** [@niclas.w82](https://discourse.nodered.org/u/niclas.w82)\
**Replies:** 2\
**Last updated:** [7 April 2023 19:48 UTC](https://discourse.nodered.org/t/domparser-https-stream/77350 "2023-04-07T19:48:47Z")

</div>

Hi. I have a http Connection that needs to be open and listen to events in realtime. (http stream) Today i use the reuest function to connect to the stream but my problem is that sometimes the xml comes in chunks and i…

---

## [Tuya Smart Device wont hold dps values](https://discourse.nodered.org/t/tuya-smart-device-wont-hold-dps-values/75205)

<div class="topic-metadata">

**Author:** [@Jsimon003](https://discourse.nodered.org/u/Jsimon003)\
**Replies:** 9\
**Last updated:** [7 April 2023 17:44 UTC](https://discourse.nodered.org/t/tuya-smart-device-wont-hold-dps-values/75205 "2023-04-07T17:44:23Z")

</div>

I'm attempting to change the color of my light from its current setting to blue. When i try to set it to blue it sets dps 21 to "colour", then it sets dps 21 to "white", then it sets dps 24 to "333303E803E8" which is blu…

---

## [Dashboard 'button' label normal/capital text](https://discourse.nodered.org/t/dashboard-button-label-normal-capital-text/77339)

<div class="topic-metadata">

**Author:** [@gNeandr](https://discourse.nodered.org/u/gNeandr)\
**Replies:** 2\
**Last updated:** [7 April 2023 17:16 UTC](https://discourse.nodered.org/t/dashboard-button-label-normal-capital-text/77339 "2023-04-07T17:16:25Z")

</div>

The label of a button in the dashboard always seems to use capital letters ... afais!? Need to change the 'label' dynamically with {{msg.payload}}. The generated string has "kWh", but the button on the dashboard shows "…

---

## [Modbus Serial - Best way to request data](https://discourse.nodered.org/t/modbus-serial-best-way-to-request-data/76721)

<div class="topic-metadata">

**Author:** [@thalesmaoa](https://discourse.nodered.org/u/thalesmaoa)\
**Replies:** 4\
**Last updated:** [7 April 2023 16:43 UTC](https://discourse.nodered.org/t/modbus-serial-best-way-to-request-data/76721 "2023-04-07T16:43:39Z")

</div>

Hi, I'm using NodeRed v3.0.2 and node-red-contrib-modbus (last version). My modbus hardware uses a RS485 RTU. After some reading, I noticed that best practice to request data is to make a single request with a higher nu…

---

## [Onkyo volume +5 or -5](https://discourse.nodered.org/t/onkyo-volume-5-or-5/77282)

<div class="topic-metadata">

**Author:** [@schorrie](https://discourse.nodered.org/u/schorrie)\
**Replies:** 10\
**Last updated:** [7 April 2023 15:25 UTC](https://discourse.nodered.org/t/onkyo-volume-5-or-5/77282 "2023-04-07T15:25:51Z")

</div>

I use eiscp out and managed to make a button controlling my volume of the onkyo receiver. I want to make buttons in home assistant for volume up or down, When clicking on it, it first has to read the current volume and…

---

## [IOT server: LAMP + node-red with autostart on Android 11](https://discourse.nodered.org/t/iot-server-lamp-node-red-with-autostart-on-android-11/77338)

<div class="topic-metadata">

**Author:** [@msillano](https://discourse.nodered.org/u/msillano)\
**Replies:** 0\
**Last updated:** [7 April 2023 12:53 UTC](https://discourse.nodered.org/t/iot-server-lamp-node-red-with-autostart-on-android-11/77338 "2023-04-07T12:53:01Z")

</div>

I like, for my dedicated IOT servers that work 24/7, to use a Tv Box (not rooted). Why? They are small, ready to use, with a good case, and require little power (5V, 2A) that is easily upgradable to UPS. The last HW is …

---

## [Node-red is not letting me work with Simatic Manager online](https://discourse.nodered.org/t/node-red-is-not-letting-me-work-with-simatic-manager-online/76845)

<div class="topic-metadata">

**Author:** [@romenger](https://discourse.nodered.org/u/romenger)\
**Replies:** 3\
**Last updated:** [7 April 2023 13:45 UTC](https://discourse.nodered.org/t/node-red-is-not-letting-me-work-with-simatic-manager-online/76845 "2023-04-07T13:45:20Z")

</div>

While connected with Node-red on my PLC s7-300, I cannot connect with the simatic manager on this plc (192.168.9.30) but I can connect to another plc (192.168.9.12) on the same network and it is using the one flow differ…

---

## [How do I get the time from the last point in a Node-red dashboard chart](https://discourse.nodered.org/t/how-do-i-get-the-time-from-the-last-point-in-a-node-red-dashboard-chart/77318)

<div class="topic-metadata">

**Author:** [@alveron](https://discourse.nodered.org/u/alveron)\
**Replies:** 7\
**Last updated:** [7 April 2023 13:09 UTC](https://discourse.nodered.org/t/how-do-i-get-the-time-from-the-last-point-in-a-node-red-dashboard-chart/77318 "2023-04-07T13:09:43Z")

</div>

I have a chart being populated from a datalogger. Sometimes the connection goes bad, so I would like to publish the time of the last plotted point so I can monitor it and potentially act if I have not received data for a…

---

## [Use MQTT for Shelly Thermostatic Radiator Valves](https://discourse.nodered.org/t/use-mqtt-for-shelly-thermostatic-radiator-valves/72368)

<div class="topic-metadata">

**Author:** [@BartButenaers](https://discourse.nodered.org/u/BartButenaers)\
**Replies:** 64\
**Last updated:** [7 April 2023 09:31 UTC](https://discourse.nodered.org/t/use-mqtt-for-shelly-thermostatic-radiator-valves/72368 "2023-04-07T09:31:25Z")

</div>

Hi folks, Continuing the discussion from New smart wifi radiator valves from Shelly Thought it would never happen again, but finally I have ordered a Shelly TRV to experiment. But not quite sure what is the best way t…

---

## [Write values to excel from two real variable, when a boolean is true](https://discourse.nodered.org/t/write-values-to-excel-from-two-real-variable-when-a-boolean-is-true/77332)

<div class="topic-metadata">

**Author:** [@cornelmarius](https://discourse.nodered.org/u/cornelmarius)\
**Replies:** 2\
**Last updated:** [7 April 2023 09:26 UTC](https://discourse.nodered.org/t/write-values-to-excel-from-two-real-variable-when-a-boolean-is-true/77332 "2023-04-07T09:26:10Z")

</div>

Hello, I am trying to write an CSV, with the data from two real variables, but only when a boolean is true or when I change a variable status. It doesn't work. If I put in the flow a boolean, it will write but with the …

---

## [Student in need of help Setting up Weather API](https://discourse.nodered.org/t/student-in-need-of-help-setting-up-weather-api/77328)

<div class="topic-metadata">

**Author:** [@JamesIoTStudent](https://discourse.nodered.org/u/JamesIoTStudent)\
**Replies:** 7\
**Last updated:** [7 April 2023 05:54 UTC](https://discourse.nodered.org/t/student-in-need-of-help-setting-up-weather-api/77328 "2023-04-07T05:54:54Z")

</div>

Hello would someone be willing to help me figure out how to add the weather service api so I can see it in a dashboard?

---

## [Mustache Template to create array of objects](https://discourse.nodered.org/t/mustache-template-to-create-array-of-objects/77326)

<div class="topic-metadata">

**Author:** [@KSum](https://discourse.nodered.org/u/KSum)\
**Replies:** 6\
**Last updated:** [6 April 2023 21:53 UTC](https://discourse.nodered.org/t/mustache-template-to-create-array-of-objects/77326 "2023-04-06T21:53:55Z")

</div>

Hello, I have the need to take data from the array, msg.payload.devices and reformat it to msg.options as an array of objects. I am trying to use a Template node and mustache template to do so, but am having an issue. …

---

## [Job Opening: Node-RED Programming for Entertainment Technology](https://discourse.nodered.org/t/job-opening-node-red-programming-for-entertainment-technology/76769)

<div class="topic-metadata">

**Author:** [@jpontius](https://discourse.nodered.org/u/jpontius)\
**Replies:** 3\
**Last updated:** [6 April 2023 21:19 UTC](https://discourse.nodered.org/t/job-opening-node-red-programming-for-entertainment-technology/76769 "2023-04-06T21:19:13Z")

</div>

Smart Monkeys is hiring a programmer for entertainment technology projects for A/V device control and automation. Node-RED is a common tool used in our services. Smart Monkeys provides control solutions to various marke…

---

## [Trouble sending data to TTN Device Downlink via MQTT Out](https://discourse.nodered.org/t/trouble-sending-data-to-ttn-device-downlink-via-mqtt-out/77288)

<div class="topic-metadata">

**Author:** [@NewToNodeRed](https://discourse.nodered.org/u/NewToNodeRed)\
**Replies:** 1\
**Last updated:** [6 April 2023 20:22 UTC](https://discourse.nodered.org/t/trouble-sending-data-to-ttn-device-downlink-via-mqtt-out/77288 "2023-04-06T20:22:20Z")

</div>

I a looking to troubleshoot sending commands to my downlink of my device on the TTN network. In the TTN console I do this and it works: But from Node Red I have the following in a function feeding into a MQTT Out and…

---

## [Can not input the openweather API key in the node](https://discourse.nodered.org/t/can-not-input-the-openweather-api-key-in-the-node/77304)

<div class="topic-metadata">

**Author:** [@Percy](https://discourse.nodered.org/u/Percy)\
**Replies:** 3\
**Last updated:** [6 April 2023 18:57 UTC](https://discourse.nodered.org/t/can-not-input-the-openweather-api-key-in-the-node/77304 "2023-04-06T18:57:10Z")

</div>

Hi, I am working on a project that using openweather node to display the weather. I have got a problem which is there is no space to input the API key so I can't display the weather in the dashboard. I have re-downloade…

---

## [Feature Request node-red-contrib-ui-list enable per item](https://discourse.nodered.org/t/feature-request-node-red-contrib-ui-list-enable-per-item/77323)

<div class="topic-metadata">

**Author:** [@novski](https://discourse.nodered.org/u/novski)\
**Replies:** 0\
**Last updated:** [6 April 2023 18:14 UTC](https://discourse.nodered.org/t/feature-request-node-red-contrib-ui-list-enable-per-item/77323 "2023-04-06T18:14:01Z")

</div>

It would be nice to be able to disable/enable on switch in the list while the others still can be used. Currently it is blocking all.

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

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