# Latest **URL:** https://discourse.nodered.org/latest.md?page=1076 [Latest](https://discourse.nodered.org/latest.md) · [Categories](https://discourse.nodered.org/categories.md) · [Tags](https://discourse.nodered.org/tags.md) **Page:** 1077 --- ## [Date Time Join for SQL Query](https://discourse.nodered.org/t/date-time-join-for-sql-query/27768)
**Author:** [@farcry](https://discourse.nodered.org/u/farcry)\ **Replies:** 2\ **Last updated:** [4 June 2020 16:00 UTC](https://discourse.nodered.org/t/date-time-join-for-sql-query/27768 "2020-06-04T16:00:24Z")
Hello. I'm trying to combine Date & Time using using ui\_text\_input and ui\_date\_picker. What I'm trying to do is: Input Date and Time to get string like 2020-06-03 12:15:30.000 I wold like to use this string to QUERY … --- ## [Email subject not populating](https://discourse.nodered.org/t/email-subject-not-populating/27772)
**Author:** [@whitecider](https://discourse.nodered.org/u/whitecider)\ **Replies:** 7\ **Last updated:** [4 June 2020 14:42 UTC](https://discourse.nodered.org/t/email-subject-not-populating/27772 "2020-06-04T14:42:39Z")
i am using the email node but for some reason the msg.topic value is not showing up in the subject line of the emails. does anyone know how to make it work? \[{"id":"f01171f6.f07ad","type":"status","z":"8dc4cb03.fcb688",… --- ## [Github Oauth authentication](https://discourse.nodered.org/t/github-oauth-authentication/27766)
**Author:** [@lizzardguki](https://discourse.nodered.org/u/lizzardguki)\ **Replies:** 4\ **Last updated:** [4 June 2020 14:10 UTC](https://discourse.nodered.org/t/github-oauth-authentication/27766 "2020-06-04T14:10:25Z")
I am trying to use GitHub to authenticate users in node-red, I tried following the documentation, but there is not a lot of info. I created a file named user-authentication.js, copied the OAuth strategy, and in setings.… --- ## [Node-red connection lost in google chrome](https://discourse.nodered.org/t/node-red-connection-lost-in-google-chrome/27568)
**Author:** [@damiangiacone](https://discourse.nodered.org/u/damiangiacone)\ **Replies:** 21\ **Last updated:** [4 June 2020 13:45 UTC](https://discourse.nodered.org/t/node-red-connection-lost-in-google-chrome/27568 "2020-06-04T13:45:21Z")
Hello my node-red installation started to fail with google chrome. Every 5 second show the messa "connection Lost". I started to work 7 months ago normally and two day ago started to fail. I have instaled node-red 1.0.… --- ## [Node selection while sidebar is hidden](https://discourse.nodered.org/t/node-selection-while-sidebar-is-hidden/27636)
**Author:** [@bakman2](https://discourse.nodered.org/u/bakman2)\ **Replies:** 3\ **Last updated:** [4 June 2020 11:52 UTC](https://discourse.nodered.org/t/node-selection-while-sidebar-is-hidden/27636 "2020-06-04T11:52:03Z")
When the left sidebar is hidden, there is no direct way to get a node(s) in the workspace, other than the ctrl+click. Would it be an idea (useful for small screens) to add a small icon when the sidebar is hidden and whe… --- ## [Pi 64 bit OS on PI 3B+](https://discourse.nodered.org/t/pi-64-bit-os-on-pi-3b/27738)
**Author:** [@gerry](https://discourse.nodered.org/u/gerry)\ **Replies:** 9\ **Last updated:** [4 June 2020 11:41 UTC](https://discourse.nodered.org/t/pi-64-bit-os-on-pi-3b/27738 "2020-06-04T11:41:31Z")
Rotated a Pi 3 B+ out of my "production" and put in a Pi 4 so I had this one for toying with. Downloaded the 64 bit OS, flashed and installed it. This is completely without any "scientific" methodology but the install fe… --- ## [Is there a way to set context properties dynamically?](https://discourse.nodered.org/t/is-there-a-way-to-set-context-properties-dynamically/27760)
**Author:** [@AAAAnT](https://discourse.nodered.org/u/AAAAnT)\ **Replies:** 5\ **Last updated:** [4 June 2020 11:16 UTC](https://discourse.nodered.org/t/is-there-a-way-to-set-context-properties-dynamically/27760 "2020-06-04T11:16:01Z")
Hello I am working with a flow where I have multiple identification key saved in a JSON flow variable, as in the following example: { "info": { "id\_1": { "previous": "value\_1", "key\_2": "value\_2", … --- ## [Smooth module not a number: nan](https://discourse.nodered.org/t/smooth-module-not-a-number-nan/27756)
**Author:** [@hathemi](https://discourse.nodered.org/u/hathemi)\ **Replies:** 4\ **Last updated:** [4 June 2020 10:52 UTC](https://discourse.nodered.org/t/smooth-module-not-a-number-nan/27756 "2020-06-04T10:52:19Z")
i'am using smooth module connected to mqtt node. when i run the flow this error appears on terminal, but nothing showing in node-red. it causes too much troubles. my dashboard starts running too slowely. any help! --- ## [How to Redirect Tab using UI Control Node without timeout](https://discourse.nodered.org/t/how-to-redirect-tab-using-ui-control-node-without-timeout/27717)
**Author:** [@novski](https://discourse.nodered.org/u/novski)\ **Replies:** 6\ **Last updated:** [4 June 2020 06:36 UTC](https://discourse.nodered.org/t/how-to-redirect-tab-using-ui-control-node-without-timeout/27717 "2020-06-04T06:36:49Z")
My flow has a template node with this: \
\floorplan missing \ \ **Author:** [@bayesey](https://discourse.nodered.org/u/bayesey)\ **Replies:** 10\ **Last updated:** [4 June 2020 09:53 UTC](https://discourse.nodered.org/t/ftp-static-dashboard-to-web-server/27755 "2020-06-04T09:53:23Z")
Hi Is it possible to regularly send either a static version of the web page or an image of a node red dashboard to my web host? This means I could display my dashboard to the public without exposing my internal network… --- ## [Every hour on the hour](https://discourse.nodered.org/t/every-hour-on-the-hour/6992)
**Author:** [@JoseGodinho](https://discourse.nodered.org/u/JoseGodinho)\ **Replies:** 8\ **Last updated:** [4 June 2020 09:40 UTC](https://discourse.nodered.org/t/every-hour-on-the-hour/6992 "2020-06-04T09:40:35Z")
Hello All What is the best node to have an hourly inject on the hour inject. Thank you JLG --- ## [How can I make a website page in the main node-red adress](https://discourse.nodered.org/t/how-can-i-make-a-website-page-in-the-main-node-red-adress/27742)
**Author:** [@RyuunosukeDS3](https://discourse.nodered.org/u/RyuunosukeDS3)\ **Replies:** 7\ **Last updated:** [4 June 2020 09:30 UTC](https://discourse.nodered.org/t/how-can-i-make-a-website-page-in-the-main-node-red-adress/27742 "2020-06-04T09:30:44Z")
I switched the flow editor to localhost:1880/admin, how can I make a website in localhost:1880? --- ## [Total meltdown - All Node-red work lost](https://discourse.nodered.org/t/total-meltdown-all-node-red-work-lost/27431)
**Author:** [@Jonoffun](https://discourse.nodered.org/u/Jonoffun)\ **Replies:** 29\ **Last updated:** [4 June 2020 08:03 UTC](https://discourse.nodered.org/t/total-meltdown-all-node-red-work-lost/27431 "2020-06-04T08:03:25Z")
I prefer to spend months working out how to use software from YouTube videos and websites like this one - but I am stuck. All deployed on Synology DS213j Installed node-red, developed 15 flows had a great time! Install… --- ## [Custom config node](https://discourse.nodered.org/t/custom-config-node/27753)
**Author:** [@mitch85](https://discourse.nodered.org/u/mitch85)\ **Replies:** 1\ **Last updated:** [4 June 2020 07:43 UTC](https://discourse.nodered.org/t/custom-config-node/27753 "2020-06-04T07:43:36Z")
Hi Guys, i'm starting to create some custom nodes. Now i want to make a config node. I saw the example in the docs here. But do i create new Projekt like node-red-contrib-testNode-config? Or do i implements the config h… --- ## [Convert HEX) to Decimal](https://discourse.nodered.org/t/convert-hex-to-decimal/27750)
**Author:** [@droidblast](https://discourse.nodered.org/u/droidblast)\ **Replies:** 6\ **Last updated:** [4 June 2020 07:31 UTC](https://discourse.nodered.org/t/convert-hex-to-decimal/27750 "2020-06-04T07:31:31Z")
Need to covert EnergyToday (HEX) to Decimal. What is the best way to do this? \ \00BB\ \02EC\ \00283FDE\ \ **Author:** [@jan-k](https://discourse.nodered.org/u/jan-k)\ **Replies:** 6\ **Last updated:** [4 June 2020 05:35 UTC](https://discourse.nodered.org/t/openssl-certificate-not-working/27701 "2020-06-04T05:35:35Z") --- ## [Use Node-RED as reverse proxy](https://discourse.nodered.org/t/use-node-red-as-reverse-proxy/13017)
**Author:** [@BartButenaers](https://discourse.nodered.org/u/BartButenaers)\ **Replies:** 36\ **Last updated:** [4 June 2020 05:27 UTC](https://discourse.nodered.org/t/use-node-red-as-reverse-proxy/13017 "2020-06-04T05:27:24Z")
Hi folks, During development of my camera-viewer, I'm having some security issues (concerning CORS). Summarized: when I show a camera Mjpeg stream from host X on my Node-RED dashboard (from host Y), I cannot get access… --- ## [Smooth node question re objects](https://discourse.nodered.org/t/smooth-node-question-re-objects/27692)
**Author:** [@craigcurtin](https://discourse.nodered.org/u/craigcurtin)\ **Replies:** 10\ **Last updated:** [3 June 2020 23:08 UTC](https://discourse.nodered.org/t/smooth-node-question-re-objects/27692 "2020-06-03T23:08:41Z")
Guys, I have a tasmota feeding in multiple temperature values from DS18B20. In order i am Converting JSON to JS Object Splitting into what i am interested in Switching to retrieve the different values Now - i want … --- ## [Allow for names in the link nodes](https://discourse.nodered.org/t/allow-for-names-in-the-link-nodes/27734)
**Author:** [@SteveMann](https://discourse.nodered.org/u/SteveMann)\ **Replies:** 8\ **Last updated:** [3 June 2020 23:03 UTC](https://discourse.nodered.org/t/allow-for-names-in-the-link-nodes/27734 "2020-06-03T23:03:45Z")
Allow for names in the link nodes. Why should I have to double-click just to see where it goes if I could put it in the node "Name" field? If you want to keep the links anonymous for some reason, just don't put anything… --- ## [Cannot GET /ui/loading.html](https://discourse.nodered.org/t/cannot-get-ui-loading-html/27719)
**Author:** [@Andrei](https://discourse.nodered.org/u/Andrei)\ **Replies:** 13\ **Last updated:** [3 June 2020 22:57 UTC](https://discourse.nodered.org/t/cannot-get-ui-loading-html/27719 "2020-06-03T22:57:43Z")
I wonder what is causing below error message in the Dev tools console for a Node-RED application that uses the dashboard. My environment: Raspberry PI Node-RED version: v1.0.6 Node.js version: v12.16.3 Dashboard ve… --- ## [treeList widget ... dynamically check (parent) items](https://discourse.nodered.org/t/treelist-widget-dynamically-check-parent-items/27737)
**Author:** [@Christian-Me](https://discourse.nodered.org/u/Christian-Me)\ **Replies:** 0\ **Last updated:** [3 June 2020 22:48 UTC](https://discourse.nodered.org/t/treelist-widget-dynamically-check-parent-items/27737 "2020-06-03T22:48:06Z")
Hello, I have a small question regarding the tree list widget. I have a list with child items. If a child is checked I like that the parents are checked dynamically. I have done a event function which changes the da… --- ## [Include mathematical functions](https://discourse.nodered.org/t/include-mathematical-functions/27641)
**Author:** [@Becker](https://discourse.nodered.org/u/Becker)\ **Replies:** 11\ **Last updated:** [3 June 2020 20:54 UTC](https://discourse.nodered.org/t/include-mathematical-functions/27641 "2020-06-03T20:54:21Z")
Hi, i have a special node from a project called NibePi, that reads out modbus data: I want to make the difference from two values (spread) and multiply this value by a third, multiply the result by a constant and ou… --- ## [adminAuth TOTP for MFA](https://discourse.nodered.org/t/adminauth-totp-for-mfa/27732)
**Author:** [@electron23](https://discourse.nodered.org/u/electron23)\ **Replies:** 0\ **Last updated:** [3 June 2020 19:13 UTC](https://discourse.nodered.org/t/adminauth-totp-for-mfa/27732 "2020-06-03T19:13:30Z")
Hey guys, is anybody using TOTP strategies for adminAuth? I couldn´t find any related informations about that feature except some stuff with Keycloak. But I will use it plain with passport-totp or something. Thanks. --- ## [Payload: Float64array](https://discourse.nodered.org/t/payload-float64array/27727)
**Author:** [@rowen826](https://discourse.nodered.org/u/rowen826)\ **Replies:** 1\ **Last updated:** [3 June 2020 18:23 UTC](https://discourse.nodered.org/t/payload-float64array/27727 "2020-06-03T18:23:43Z")
Hello everyone, I have a CNC reporting some torque data using OPC UA. The problems is that the data format(?) is in Float64Array and the reported value (debugging) shows double quotes. How do I convert this to a usable … --- ## [How to add custom icon(from url) in world map for node-red](https://discourse.nodered.org/t/how-to-add-custom-icon-from-url-in-world-map-for-node-red/8470)
**Author:** [@VIKRAMAS](https://discourse.nodered.org/u/VIKRAMAS)\ **Replies:** 13\ **Last updated:** [3 June 2020 18:19 UTC](https://discourse.nodered.org/t/how-to-add-custom-icon-from-url-in-world-map-for-node-red/8470 "2020-06-03T18:19:17Z")
In node-red dashboard I want to add a custom icon(from a api), but the node-red uses font-awesome icons by default. Is there any way we can change the icon which I will fetch from a http endpoint. --- ## [Create an event scheduler, like cron, time](https://discourse.nodered.org/t/create-an-event-scheduler-like-cron-time/20767)
**Author:** [@henriquemartelli](https://discourse.nodered.org/u/henriquemartelli)\ **Replies:** 28\ **Last updated:** [3 June 2020 17:37 UTC](https://discourse.nodered.org/t/create-an-event-scheduler-like-cron-time/20767 "2020-06-03T17:37:57Z")
flows.json (23.4 KB) Friends, I would like some help to finish my code. I am creating this event scheduler (time type), where I will select the days of the week, and times for the operation of a greenhouse that will cont… --- ## [Zigbee data transmission through arduino](https://discourse.nodered.org/t/zigbee-data-transmission-through-arduino/27614)
**Author:** [@Iliyas](https://discourse.nodered.org/u/Iliyas)\ **Replies:** 6\ **Last updated:** [3 June 2020 15:32 UTC](https://discourse.nodered.org/t/zigbee-data-transmission-through-arduino/27614 "2020-06-03T15:32:56Z")
Hello everyone, I need to transfer data from zigbee(router) to zigbee(coordinator) which is connected with arduino UNO, I need to work with this please help me out with this --- ## [Modbus contrib optimization for energy storage control](https://discourse.nodered.org/t/modbus-contrib-optimization-for-energy-storage-control/27710)
**Author:** [@Sasko](https://discourse.nodered.org/u/Sasko)\ **Replies:** 6\ **Last updated:** [3 June 2020 14:47 UTC](https://discourse.nodered.org/t/modbus-contrib-optimization-for-energy-storage-control/27710 "2020-06-03T14:47:03Z")
At the moment I'm building an ui for a solar energy storage with node red modbus contrib. The problem is, that the browser starts getting very lame, when I combine the nodes with a lot of gauges, I think I used about 9 t… --- ## [Error: Deploy failed: {"code":"EPERM","message":"EPERM: operation not permitted, open 'C:\\\\v'"}](https://discourse.nodered.org/t/error-deploy-failed-code-eperm-message-eperm-operation-not-permitted-open-c-v/27712)
**Author:** [@Cheese](https://discourse.nodered.org/u/Cheese)\ **Replies:** 1\ **Last updated:** [3 June 2020 13:35 UTC](https://discourse.nodered.org/t/error-deploy-failed-code-eperm-message-eperm-operation-not-permitted-open-c-v/27712 "2020-06-03T13:35:47Z")
Hi all, I have 2 issues that appeared with my Node-red today. After 12 months of flawlessly working, I'm suddenly getting 2 issues. When I open the UI, all of the flows are missing and only a single new default view… --- ## [Link out , return to flow](https://discourse.nodered.org/t/link-out-return-to-flow/27711)
**Author:** [@crester](https://discourse.nodered.org/u/crester)\ **Replies:** 2\ **Last updated:** [3 June 2020 13:05 UTC](https://discourse.nodered.org/t/link-out-return-to-flow/27711 "2020-06-03T13:05:52Z")
Hello. I have same task, in this case is a login to get a hash in a website and use it in different flows. Something like this: But, how can I return to origin from the link out? [Previous page](https://discourse.nodered.org/latest.md?page=1075) [Next page](https://discourse.nodered.org/latest.md?page=1077)