# Latest

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

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

**Page:** 780

---

## [Manage planning by node-red-contrib-google-oauth-calendar](https://discourse.nodered.org/t/manage-planning-by-node-red-contrib-google-oauth-calendar/47903)

<div class="topic-metadata">

**Author:** [@grandautism](https://discourse.nodered.org/u/grandautism)\
**Replies:** 4\
**Last updated:** [5 July 2021 13:13 UTC](https://discourse.nodered.org/t/manage-planning-by-node-red-contrib-google-oauth-calendar/47903 "2021-07-05T13:13:58Z")

</div>

Hello community I am wondering if I can manage the planning via node-red for example for the reservation of rooms. can I use node-red-contrib-google-oauth-calendar and instead of events using rooms

---

## [Installation Error: Security Settings](https://discourse.nodered.org/t/installation-error-security-settings/48047)

<div class="topic-metadata">

**Author:** [@niviolin](https://discourse.nodered.org/u/niviolin)\
**Replies:** 4\
**Last updated:** [5 July 2021 13:09 UTC](https://discourse.nodered.org/t/installation-error-security-settings/48047 "2021-07-05T13:09:43Z")

</div>

Hello, I tried to install node.js through the Window Installer. But I get the following error: It's the first time installation on this device. The operating system is Windows 10 Pro. I have tried 14.17.2 LTS and 16.…

---

## [Delete lines from the csv file](https://discourse.nodered.org/t/delete-lines-from-the-csv-file/48042)

<div class="topic-metadata">

**Author:** [@achrefnajjar](https://discourse.nodered.org/u/achrefnajjar)\
**Replies:** 6\
**Last updated:** [5 July 2021 12:52 UTC](https://discourse.nodered.org/t/delete-lines-from-the-csv-file/48042 "2021-07-05T12:52:35Z")

</div>

hello, i'm having a csv file where to save data in and then ploting it on chart i'm having this functionality to record data received from sensors to the csv file and showing these data on charts but the thing is that i…

---

## [Uibuilder question](https://discourse.nodered.org/t/uibuilder-question/48045)

<div class="topic-metadata">

**Author:** [@andrei12323](https://discourse.nodered.org/u/andrei12323)\
**Replies:** 3\
**Last updated:** [5 July 2021 12:48 UTC](https://discourse.nodered.org/t/uibuilder-question/48045 "2021-07-05T12:48:26Z")

</div>

Can i use some server side programming languages (php,node.js) in the uibuilder node somehow?

---

## [Google Calendar](https://discourse.nodered.org/t/google-calendar/2295)

<div class="topic-metadata">

**Author:** [@leomozzer](https://discourse.nodered.org/u/leomozzer)\
**Replies:** 8\
**Last updated:** [5 July 2021 10:21 UTC](https://discourse.nodered.org/t/google-calendar/2295 "2021-07-05T10:21:35Z")

</div>

How create events in google calendar using the node-red? I make the download of the nodes from the google calendar and already have the credentials of google calendar.

---

## [Node-red-contrib-coap (Error)](https://discourse.nodered.org/t/node-red-contrib-coap-error/48030)

<div class="topic-metadata">

**Author:** [@saeidiot](https://discourse.nodered.org/u/saeidiot)\
**Replies:** 1\
**Last updated:** [5 July 2021 09:26 UTC](https://discourse.nodered.org/t/node-red-contrib-coap-error/48030 "2021-07-05T09:26:34Z")

</div>

hello everyone, I have problem with the use of (node-red-contrib-coap ) and when I want to use coap request node, I have an error with this message Flows stopped due to missing node types. coap request

---

## [Python shell to msg.Topic for OPCUA client](https://discourse.nodered.org/t/python-shell-to-msg-topic-for-opcua-client/48040)

<div class="topic-metadata">

**Author:** [@Niente](https://discourse.nodered.org/u/Niente)\
**Replies:** 0\
**Last updated:** [5 July 2021 09:13 UTC](https://discourse.nodered.org/t/python-shell-to-msg-topic-for-opcua-client/48040 "2021-07-05T09:13:56Z")

</div>

Hello, I am experimenting a little with OPCUA in Node Red and would like to read a variable from a Python script in Node Red and transfer it to the OPCUA client in order to write a variable on the OPC server. I know how…

---

## [Time delay with persistence?](https://discourse.nodered.org/t/time-delay-with-persistence/47393)

<div class="topic-metadata">

**Author:** [@hazymat](https://discourse.nodered.org/u/hazymat)\
**Replies:** 16\
**Last updated:** [5 July 2021 08:15 UTC](https://discourse.nodered.org/t/time-delay-with-persistence/47393 "2021-07-05T08:15:38Z")

</div>

Hi All I'm upgrading my light scene controller to support being triggered by presence sensors. Eventually I will have about 12 lighting zones in the home, each with one or more presence sensors. The idea is that when s…

---

## [How to change page with ui\_builder depending on the decision?](https://discourse.nodered.org/t/how-to-change-page-with-ui-builder-depending-on-the-decision/47993)

<div class="topic-metadata">

**Author:** [@WeeSeong](https://discourse.nodered.org/u/WeeSeong)\
**Replies:** 3\
**Last updated:** [5 July 2021 08:03 UTC](https://discourse.nodered.org/t/how-to-change-page-with-ui-builder-depending-on-the-decision/47993 "2021-07-05T08:03:00Z")

</div>

Hi, so I've been trying to work on setting up a log in page using the ui\_builder node. I've managed to get the form and such ready but I'm stuck at making the decision since I havea few nodes connected to it. Should I be…

---

## [How to hold data in node function](https://discourse.nodered.org/t/how-to-hold-data-in-node-function/48027)

<div class="topic-metadata">

**Author:** [@PNWw](https://discourse.nodered.org/u/PNWw)\
**Replies:** 6\
**Last updated:** [5 July 2021 07:46 UTC](https://discourse.nodered.org/t/how-to-hold-data-in-node-function/48027 "2021-07-05T07:46:35Z")

</div>

Hi In my project, I have sensor that can send 2 data. Height and Profile number height when have object it have value but don't have object it = 0 Profile number it counted values indefinitely when start sensor. I wa…

---

## [High availability login/auth issue](https://discourse.nodered.org/t/high-availability-login-auth-issue/48023)

<div class="topic-metadata">

**Author:** [@bubus](https://discourse.nodered.org/u/bubus)\
**Replies:** 3\
**Last updated:** [5 July 2021 07:29 UTC](https://discourse.nodered.org/t/high-availability-login-auth-issue/48023 "2021-07-05T07:29:37Z")

</div>

Hello, I have node-red hosted on openshift with high avalibilty (2 pods parallel) and i have issue with login: When i access node-red directly and login everything works fine. The problem is when i want to login this …

---

## [.git/Object file is corrupt](https://discourse.nodered.org/t/git-object-file-is-corrupt/47997)

<div class="topic-metadata">

**Author:** [@pranavthakkar](https://discourse.nodered.org/u/pranavthakkar)\
**Replies:** 14\
**Last updated:** [5 July 2021 07:14 UTC](https://discourse.nodered.org/t/git-object-file-is-corrupt/47997 "2021-07-05T07:14:20Z")

</div>

I started NR in the virtual box after some time. and After creating flow when I try to deploy I got this error. What can be done? Error: error: object file .git/objects/4d/b2a0367fbacc3376b2a2d94b6f65fc5bccf95d is empty…

---

## [Min, Max & Avg in single message](https://discourse.nodered.org/t/min-max-avg-in-single-message/48033)

<div class="topic-metadata">

**Author:** [@dmac101](https://discourse.nodered.org/u/dmac101)\
**Replies:** 4\
**Last updated:** [5 July 2021 06:30 UTC](https://discourse.nodered.org/t/min-max-avg-in-single-message/48033 "2021-07-05T06:30:57Z")

</div>

Hi All, I am working on a project that involves monitoring and logging analogue data using MCP3008. To save logging every second, I plan to use the calculate node to provide minimum, maximum and average over a 1 minute t…

---

## [About a5=a0+a1+a2+a3+a4?](https://discourse.nodered.org/t/about-a5-a0-a1-a2-a3-a4/48028)

<div class="topic-metadata">

**Author:** [@jlian168](https://discourse.nodered.org/u/jlian168)\
**Replies:** 2\
**Last updated:** [5 July 2021 06:14 UTC](https://discourse.nodered.org/t/about-a5-a0-a1-a2-a3-a4/48028 "2021-07-05T06:14:36Z")

</div>

Dear All : var a0=0xCD; var a1=0x64; var a2=0x01; var a3=0x04; var a4=0x00; a5=a0+a1+a2+a3+a4; msg.payload=a5; return msg; Why in debug window its show NaN? Thank u.

---

## [Stupid beginner question about repeated flows/ intervals](https://discourse.nodered.org/t/stupid-beginner-question-about-repeated-flows-intervals/47869)

<div class="topic-metadata">

**Author:** [@kavemang](https://discourse.nodered.org/u/kavemang)\
**Replies:** 13\
**Last updated:** [4 July 2021 22:41 UTC](https://discourse.nodered.org/t/stupid-beginner-question-about-repeated-flows-intervals/47869 "2021-07-04T22:41:52Z")

</div>

Hi folks, I have a mildy goofy setup where I find myself passing certain sensor values from Smartthings to home assistant. I have my flow setup 1:1 ST sensor -\> HA entity ST sensor -\> HA entity ST sensor -\> HA entity …

---

## [Node-red-contrib-open-protocol full or half duplex](https://discourse.nodered.org/t/node-red-contrib-open-protocol-full-or-half-duplex/48019)

<div class="topic-metadata">

**Author:** [@DamianAdams](https://discourse.nodered.org/u/DamianAdams)\
**Replies:** 1\
**Last updated:** [4 July 2021 21:46 UTC](https://discourse.nodered.org/t/node-red-contrib-open-protocol-full-or-half-duplex/48019 "2021-07-04T21:46:00Z")

</div>

Hi, I have been having problems with the node-red-contrib-open-protocol dropping last tightening rundown being dropped by the tooling for type 6000 tools, Atlas is telling me the comms must be full-duplex not half-duplex…

---

## [Is there an event which is raised when node-red finished deploying?](https://discourse.nodered.org/t/is-there-an-event-which-is-raised-when-node-red-finished-deploying/48015)

<div class="topic-metadata">

**Author:** [@windkh](https://discourse.nodered.org/u/windkh)\
**Replies:** 3\
**Last updated:** [4 July 2021 21:05 UTC](https://discourse.nodered.org/t/is-there-an-event-which-is-raised-when-node-red-finished-deploying/48015 "2021-07-04T21:05:50Z")

</div>

I searched the forum but could not find anything that could solve my problem: Use Case: I would like to do execute some code after all nodes in one of my libs were successfully initialized. All my nodes register themse…

---

## [SIMPLE way to restart flows within Node-Red](https://discourse.nodered.org/t/simple-way-to-restart-flows-within-node-red/47989)

<div class="topic-metadata">

**Author:** [@RonMa](https://discourse.nodered.org/u/RonMa)\
**Replies:** 16\
**Last updated:** [4 July 2021 20:07 UTC](https://discourse.nodered.org/t/simple-way-to-restart-flows-within-node-red/47989 "2021-07-04T20:07:40Z")

</div>

Latest since making use of the Alexa integration, I found that some flows just ain't quite stable working and, unfortunately, need to be restarted regularly. Therefore I´m looking for an easy way, how to restart all and/…

---

## [Download ui-table command](https://discourse.nodered.org/t/download-ui-table-command/47991)

<div class="topic-metadata">

**Author:** [@trust](https://discourse.nodered.org/u/trust)\
**Replies:** 2\
**Last updated:** [4 July 2021 18:23 UTC](https://discourse.nodered.org/t/download-ui-table-command/47991 "2021-07-04T18:23:57Z")

</div>

ui-table seems like an incredibly powerful way to interact with data. I've got it reading from my various databases, and want to be able to modify cells in the table, then send a command to download the table to a csv fi…

---

## [Function to check input and output](https://discourse.nodered.org/t/function-to-check-input-and-output/48011)

<div class="topic-metadata">

**Author:** [@sfedo](https://discourse.nodered.org/u/sfedo)\
**Replies:** 4\
**Last updated:** [4 July 2021 16:39 UTC](https://discourse.nodered.org/t/function-to-check-input-and-output/48011 "2021-07-04T16:39:53Z")

</div>

Hello guys, I'm using mqtt to send data to arduino. I use ui\_switch to set my device on and off, and after arduino received my message, it send another message to confirm. With this message I set the ui switch to on and…

---

## [How can i change the css of my dashboard via js?](https://discourse.nodered.org/t/how-can-i-change-the-css-of-my-dashboard-via-js/48000)

<div class="topic-metadata">

**Author:** [@TimoB2005](https://discourse.nodered.org/u/TimoB2005)\
**Replies:** 3\
**Last updated:** [4 July 2021 16:29 UTC](https://discourse.nodered.org/t/how-can-i-change-the-css-of-my-dashboard-via-js/48000 "2021-07-04T16:29:49Z")

</div>

Hey, i want to change my css via js in nodered to set a color dynamic. But when i do it like me in raw js with document.getElementyById... bla bla it says "document is not defined". How can i change css in js with noder…

---

## [Example flow: Actionable notification iOS](https://discourse.nodered.org/t/example-flow-actionable-notification-ios/48013)

<div class="topic-metadata">

**Author:** [@dmertens](https://discourse.nodered.org/u/dmertens)\
**Replies:** 0\
**Last updated:** [4 July 2021 15:46 UTC](https://discourse.nodered.org/t/example-flow-actionable-notification-ios/48013 "2021-07-04T15:46:41Z")

</div>

Hi, Someone, an example for an actionable notification flow (iOS) Thanks!

---

## [Dashboard in / and not in /ui](https://discourse.nodered.org/t/dashboard-in-and-not-in-ui/48003)

<div class="topic-metadata">

**Author:** [@QRO](https://discourse.nodered.org/u/QRO)\
**Replies:** 1\
**Last updated:** [4 July 2021 10:17 UTC](https://discourse.nodered.org/t/dashboard-in-and-not-in-ui/48003 "2021-07-04T10:17:47Z")

</div>

Hi Is it possible to swap /ui with flows? :1880 \> shows dashboard :1880/XXX gives the flow editor Peter

---

## [Worldmap accuracy](https://discourse.nodered.org/t/worldmap-accuracy/47970)

<div class="topic-metadata">

**Author:** [@ping](https://discourse.nodered.org/u/ping)\
**Replies:** 7\
**Last updated:** [3 July 2021 22:45 UTC](https://discourse.nodered.org/t/worldmap-accuracy/47970 "2021-07-03T22:45:19Z")

</div>

I am passing latitude and longitude of my location to worldmap. I chose OpenStreetmap. It shows my area but my spot is located on the opposite block of where I am. Any advise please?

---

## [Accessing Flow Information From Custom Node](https://discourse.nodered.org/t/accessing-flow-information-from-custom-node/47858)

<div class="topic-metadata">

**Author:** [@BShashwat](https://discourse.nodered.org/u/BShashwat)\
**Replies:** 2\
**Last updated:** [3 July 2021 20:45 UTC](https://discourse.nodered.org/t/accessing-flow-information-from-custom-node/47858 "2021-07-03T20:45:44Z")

</div>

Hi, I am trying to get the Flow Info within my custom node on input event as follows: this.on('input', function (msg, nodeSend, nodeDone) { console.info(node.name + " processing start"); node.st…

---

## [SQLite node syntax error but sqlitebrowser works](https://discourse.nodered.org/t/sqlite-node-syntax-error-but-sqlitebrowser-works/47350)

<div class="topic-metadata">

**Author:** [@mune](https://discourse.nodered.org/u/mune)\
**Replies:** 24\
**Last updated:** [3 July 2021 17:45 UTC](https://discourse.nodered.org/t/sqlite-node-syntax-error-but-sqlitebrowser-works/47350 "2021-07-03T17:45:02Z")

</div>

Hi guys, I have an issue that is driving me crazy. In two words: I have a SQLite node that raises a syntax error but the same SQL query works in sqlitebrowser or in the sqlite's cli. nodered version is 1.2.3 sqlite ver…

---

## [Form is different to before](https://discourse.nodered.org/t/form-is-different-to-before/47985)

<div class="topic-metadata">

**Author:** [@Jhon](https://discourse.nodered.org/u/Jhon)\
**Replies:** 0\
**Last updated:** [3 July 2021 16:43 UTC](https://discourse.nodered.org/t/form-is-different-to-before/47985 "2021-07-03T16:43:17Z")

</div>

hell 1.I used form of dashboard ,when I input information,than press the button(submit).the information still be displayed. 2.I update the node-red to latest. the same 1 when I input information,than press the butto…

---

## [Reading files into ui-table](https://discourse.nodered.org/t/reading-files-into-ui-table/47960)

<div class="topic-metadata">

**Author:** [@trust](https://discourse.nodered.org/u/trust)\
**Replies:** 3\
**Last updated:** [3 July 2021 16:02 UTC](https://discourse.nodered.org/t/reading-files-into-ui-table/47960 "2021-07-03T16:02:22Z")

</div>

Newbie so still trying to understand the system. I've tried using the example data from ui-table written into files and used file reader to input to ui-table - it creates a blank table. The examples using inject work fi…

---

## [MQTT store in mysql](https://discourse.nodered.org/t/mqtt-store-in-mysql/47978)

<div class="topic-metadata">

**Author:** [@Apoki21](https://discourse.nodered.org/u/Apoki21)\
**Replies:** 4\
**Last updated:** [3 July 2021 15:50 UTC](https://discourse.nodered.org/t/mqtt-store-in-mysql/47978 "2021-07-03T15:50:55Z")

</div>

Hello Guys, I need help correct my code, i fail store data on mysql this my flow: this my function code: msg.topic = msg.payload var tag1 = msg.payload.P1-basic/L1\_N\_Voltage(V) var tag2 = msg.payloadP1-basic/L1\_L…

---

## [error on start of node-red](https://discourse.nodered.org/t/error-on-start-of-node-red/20447)

<div class="topic-metadata">

**Author:** [@yordi](https://discourse.nodered.org/u/yordi)\
**Replies:** 2\
**Last updated:** [3 July 2021 15:42 UTC](https://discourse.nodered.org/t/error-on-start-of-node-red/20447 "2021-07-03T15:42:12Z")

</div>

node-red : File C:\\Users\\me\\AppData\\Roaming\\npm\\node-red.ps1 cannot be loaded because running scripts is disabled on this system. For more information, see about\_Execution\_Policies at https:/go.microsoft.com/fwlink/?Lin…

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

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