How to create a data table in Node RED Dashboard

Did you know that you can install additional gadgets to the Node-RED dashboard? Learn how to add the table node package, and then see an example of real-world data. In this video you will learn how to create a data table for your Node-RED dashboard.

00:00 Introduction
00:52 Installing the table node
01:31 Documentation overview
02:15 Static example data
03:54 Adding the table to the dashboard
05:45 Getting real-world data
07:08 Setting dynamic properties
09:40 Seeing a single row update
10:46 Configuring the table
13:57 Adding additional rows
17:02 Limiting the number of rows
18:13 Emptying the table
19:57 Conclusion

Learn More:

More FREE online training

All Opto 22 products are designed, manufactured, and supported in the U.S.A. from our Temecula, California headquarters and factory.
#api #nodered #node #groov #JSON #IoT #Tutorial #learnprogramming #programming #IIoT #automation #javascript #node-REDdashboard

[TheSwarmlord]

Thank you for this wonderfull guide. I could only wish that my teachers can explain things as clearly as you.

[HeinzRuetschi]

Hello Terry, thank you very much for your fantastic training videos and valuable technical information. Your way of presenting Node-RED any your Opto Products is really a great pleasure to watch and appreciated.
Unfortunately, I’ve noticed when trying to reading some of the additional information mentioned under the video, that a few links in learn more, are not available anymore and do not work.
Would there by any chance to update these?
In any case Terry, thank you very much again for all your quality training and enormous efforts!

[adaptivetechnologies]

Another Excellent video.. Thanks for all the efforts to make these videos..👍👍

[joeking]

This is the only YT vid to make any sense of the ui-table. Very many thks, you saved me leaving NR and using other lang to complete project.
But 2 issues. 1> The table only updates on screen for the first entry, any further entries looks like nothing happens until you refresh the ui browser/webpage, this off course is hopeless for a real world prog, do you have any pointers as to how to make the display of data show when an entry in the table is added and complete array resent, looking at the other comments it seems like the guy with far eastern name may be describing the same issue as me.
2> I have added the ui-table columns to tidy up/size etc as you explain but when these are added I can get NO data displayed until I remove the the columns, and yes the items names are correct from the array that my prog sends.
One last point noted. when you define the ( i think savedData variable ), you just type savedData =, without preceding with a the var keyword, I cannot use your code as you type it without starting the line with var, as will throw an error, while adding var works for me now there has to be a reason why your NR does not need to precede the variable declarations with var.
One again your clear concise approach and superbly timed speaking manner with a super clear diction is very much appreciated. My project may not be finalised in NR due to the above but without this vid I would have kicked out NR for another platform without you, so still with NR for now, I just very much hope you may make a reply to this with some pointers to resolve the above. Keep up the good tutorials and will be checking out ALL your others. Kind Rgds.

[gabrieldavid]

Thank you very much, your video help me!

[kobedde]

Very clearly explained in this video. Thanks for sharing this with us. 👍

[erwinwaldherr]

fine video, very easy to build now a table myself!!

[jamesd]

Personally, I would have preferred a while loop to pop off your table while it's > 5. It would be more fault tolerant in case a bug ever caused your table to grow beyond 6 (for whatever reason), and it better reflects your intention to always limit the table to 5 rows.

[smitcher]

One other tip is to convert the door state on the fly too for better readability, something like changing msg.doorState to

msg.doorState ? "Closed" : "Open"

or you can switch them round depending on what true/false actually means...

[raulrrojas]

Node red is great! I´d only like to have a more friendly export file format in order to be able to learn and escalate as with other lenguages. Besides that, it is fantastic.

[saarnikianto]

Hello! Thanks for the good Video! I would have a Question: How do I make a dynamic List where I can add a row with data and then when needed, remove the same row of data later? Maybe using some id number…

[jhonnyputtini]

Great video! Can I storage all table data and the struct buit to a Sqlite?

[fun_tech]

morning, sir. May I ask you question
how if my table was not updated automatically, I mean I have to refresh my ui to get my table updated. Whats wrong, sir ? 🙏

[calixtoemilio]

Very educational!

How to show the table name (not the group name) in the dashboard?

[geirvalsvik]

Thanks for a great video on node red UI-Table design! This is perfect for my project where I want to use UI-Table to display an alarm list from the PLC control system I'm using. The only thing to make it complete, is to automatically refresh the table every time a new alarm appears. Like in your example it only updates when the browsers refresh button is manually pressed. Is there a way to make the refresh automatic? Other than that this example is perfect.

[YvesDarbellay]

Thank you for this good tutorial. If I want to use these tables, I have to restart the Node-red service on my server so that the table is visible on the dashboard. After that, all my other dashboards are invisible. To correct this, I need to delete the node array and restart the service on my server. Is this a known problem? Thanks for your help.

[werneroostendorp]

Hi! Is there an easy way to 'download' all the values in the table (to .csv) via a button? and if yes, do you know if there is an example flow which i can use?

[drccr]

It's very nice. But why my ui-table can't auto update new coming data? Thank you!

[andersondachery]

congratulations for your video. it helps me a lot in node red. I have a doubt I have a table where I store data collected by my plc. I need to save this table in Pdf daily. how could i do this? thanks

[kme]

this could be used to create an alarm buffer. Having to build your own alarm logic is the thing that I have not yet managed to wrap my head around in node red. Trying to get something similar to WINCC alarm management. not easy for a noob