No video

How to create a data table in Node RED Dashboard

  Рет қаралды 62,636

Opto Video

Opto Video

Күн бұрын

Пікірлер: 73
@TheSwarmlord
@TheSwarmlord 4 ай бұрын
Thank you for this wonderfull guide. I could only wish that my teachers can explain things as clearly as you.
@gabrieldavid7664
@gabrieldavid7664 2 жыл бұрын
Thank you very much, your video help me!
@gabrieldavid7664
@gabrieldavid7664 2 жыл бұрын
Do you have a course?
@Opto22
@Opto22 2 жыл бұрын
Yes, there is more FREE training at: training.opto22.com/
@LaurentTercinet
@LaurentTercinet 3 ай бұрын
I love the way you teach it.
@adaptivetechnologies7584
@adaptivetechnologies7584 2 жыл бұрын
Another Excellent video.. Thanks for all the efforts to make these videos..👍👍
@Opto22
@Opto22 2 жыл бұрын
Thanks so much!!!
@talkeasy
@talkeasy Жыл бұрын
Excellent, thank-you.
@Opto22
@Opto22 Жыл бұрын
Thanks so much!
@jamesd7448
@jamesd7448 2 жыл бұрын
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.
@joeking5211
@joeking5211 2 жыл бұрын
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.
@wrgarcia2012
@wrgarcia2012 2 жыл бұрын
Excellent video
@Opto22
@Opto22 2 жыл бұрын
Glad you liked it
@kobedde
@kobedde 2 жыл бұрын
Very clearly explained in this video. Thanks for sharing this with us. 👍
@Opto22
@Opto22 Жыл бұрын
Glad it was helpful!
@adharaglz5974
@adharaglz5974 2 жыл бұрын
100/100 you saved my life ✨
@Opto22
@Opto22 2 жыл бұрын
Thanks!! Glad it helped.
@adharaglz5974
@adharaglz5974 2 жыл бұрын
@@Opto22 how can I put data from a python dictionary?
@erwinwaldherr2126
@erwinwaldherr2126 Жыл бұрын
fine video, very easy to build now a table myself!!
@Opto22
@Opto22 Жыл бұрын
Glad it was helpful!
@fun_tech
@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 ? 🙏
@diegogalabvis472
@diegogalabvis472 Жыл бұрын
i get the answere, use this funcion ="msg.ui_control = {tabulator: {data: msg.payload}}; return msg;". This function updates the data in real time.
@Gijs_van_Elderen
@Gijs_van_Elderen 5 ай бұрын
Thank you ! @@diegogalabvis472
@HeinzRuetschi
@HeinzRuetschi 10 ай бұрын
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!
@damianolesz6326
@damianolesz6326 Жыл бұрын
Well presented!
@Opto22
@Opto22 Жыл бұрын
Glad it helped!
@raulrrojas
@raulrrojas 2 жыл бұрын
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.
@Opto22
@Opto22 2 жыл бұрын
Thanks for sharing!
@balcubo
@balcubo Жыл бұрын
Great explanation, thank you
@Opto22
@Opto22 Жыл бұрын
glad you liked it!
@littletiger6902
@littletiger6902 4 ай бұрын
I have problem with adding the table. I can add one table, but the Tab is missing and not able to add other dashboard icon in same page.
@raulpadrongarcia8852
@raulpadrongarcia8852 2 жыл бұрын
you have my respect
@Opto22
@Opto22 2 жыл бұрын
And you, ours. Thanks Raul!!
@calixtoemilio
@calixtoemilio Жыл бұрын
Very educational! How to show the table name (not the group name) in the dashboard?
@paulobarbusa3339
@paulobarbusa3339 2 жыл бұрын
Thank you! Veryy good
@Opto22
@Opto22 Жыл бұрын
Thanks so much!
@smitcher
@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...
@mircopolo
@mircopolo 6 ай бұрын
Is it possible to edit record values and save them back to the database? also by few users at the same time...
@saarnikianto3541
@saarnikianto3541 9 ай бұрын
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…
@drccr
@drccr 2 жыл бұрын
It's very nice. But why my ui-table can't auto update new coming data? Thank you!
@Opto22
@Opto22 2 жыл бұрын
Let me check
@jhonnyputtini8514
@jhonnyputtini8514 Жыл бұрын
Great video! Can I storage all table data and the struct buit to a Sqlite?
@geirvalsvik1780
@geirvalsvik1780 Жыл бұрын
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
@YvesDarbellay 11 ай бұрын
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.
@kme8134
@kme8134 Жыл бұрын
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
@werneroostendorp1154
@werneroostendorp1154 7 ай бұрын
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?
@xiaoxiao6681
@xiaoxiao6681 2 жыл бұрын
good
@Opto22
@Opto22 2 жыл бұрын
Thanks so much!!!
@andersondachery385
@andersondachery385 Жыл бұрын
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
@Opto22
@Opto22 Жыл бұрын
Glad it helped!
@dyaez80
@dyaez80 Жыл бұрын
ello, thanks for your contribution, I have a problem, my database is fine, but when I want to use this node, it happens to me that it does not appear in the dashboard, and I followed the steps just like in the video, but there was no case, I tried it in 2 PCs that I have a network node and it is the same time ago if it worked for me but now I do the same steps and it does not appear, could it be something with the versions? Or what else could it be that is giving me problems? greetings and thank you very much.
@stumbleinnmontpelier
@stumbleinnmontpelier Жыл бұрын
This is a great tutorial! It was just what I was looking to do in creating an event stack to display in dashboard. However, mine doesn't seem to update the table unless I refresh the Dashboard. Any suggestions?
@fun_tech
@fun_tech Жыл бұрын
have same problem, did you get the solution ?
@ricardocallejo7422
@ricardocallejo7422 2 жыл бұрын
Where do you define savedCount? I couldn´t find flow.set("savedCount", tablaData)
@christopherlawes9286
@christopherlawes9286 2 жыл бұрын
Can you save the table data in a SharePoint List?
@rrpedrigal
@rrpedrigal Жыл бұрын
How will you get those data to send or notify you for example Telegram?
@StoryofEV
@StoryofEV Жыл бұрын
Can u do a FTP server on node red ?
@user-nj2hr9ld9e
@user-nj2hr9ld9e 2 жыл бұрын
My ui-table can't auto update new coming data
@fun_tech
@fun_tech Жыл бұрын
have same problem, did you get the solutions after this 2 month ?
@user-nj2hr9ld9e
@user-nj2hr9ld9e Жыл бұрын
@@fun_tech No
@benjaminhurand792
@benjaminhurand792 Жыл бұрын
I have the same problem, I can't find any solution, what about yall ?
@geirvalsvik1780
@geirvalsvik1780 Жыл бұрын
Same problem with me as well. Any found a solution to make the table auto update when new data arrives?
@basoayam4252
@basoayam4252 Жыл бұрын
Can u make it with database How to show data from database sql to the table, please make the tutorial bro, i really need that
@HelloHelloXD
@HelloHelloXD 2 жыл бұрын
Great video. Can you make a video on how to get data from MySql to Node-Red and display it in a chart instead of a table?
@jamesd7448
@jamesd7448 2 жыл бұрын
He's actually already done that here! kzfaq.info/get/bejne/rt18h8Wqm8iReYk.html
@Opto22
@Opto22 2 жыл бұрын
Check out this older video: kzfaq.info/get/bejne/rt18h8Wqm8iReYk.html
@IsaacBG84
@IsaacBG84 Жыл бұрын
Node-red uses javascript to work?
@Opto22
@Opto22 Жыл бұрын
Yes, the Node-RED runtime is built on Node.js
@jamiecoates9891
@jamiecoates9891 8 ай бұрын
Great Video, only cant read the contents of the Function block shown at timestamp 15:49, top line tableData = flow.get("savedData") {} [];????
@jamiecoates9891
@jamiecoates9891 8 ай бұрын
maybe because of have UK keyboard??
@jamiecoates9891
@jamiecoates9891 8 ай бұрын
Re-watched video and can see they are two parallel line ' || ' added them , but I get an error as soon as I type tabledata, makes no sense to me... tableData = flow.get("savedData") || []; tableData.unshift({ "Timestamp": new Date(msg.payload).toLocaleString(), "Lat": global.get("Latitude_ISS"), "Long": global.get("Longitude_ISS") }); msg.payload = tableData; flow.set("savedData",tableData); return msg;
@manuelmatus2959
@manuelmatus2959 Жыл бұрын
I get an error when I enter the TableData... Seems like it is not recovnizing the "savedData". You have to modify the 1 line to -> var tableData = flow.get("savedData") || [];
@revolutionertech.4559
@revolutionertech.4559 Жыл бұрын
hello there if could please guide me, below mentioned in my function where each msg is incoming data from energy meter, I want to push each data to table if you can please guide " var msg0 = {payload:msg.payload[0]}; var msg1 = {payload:msg.payload[1]/10}; var msg2 = {payload:msg.payload[2]/10}; var msg3 = {payload:msg.payload[3]/10}; var msg4 = {payload:msg.payload[4]/10}; var msg5 = {payload:msg.payload[5]/10}; var msg6 = {payload:msg.payload[6]/10}; var msg7 = {payload:msg.payload[7]/10}; return [msg0, msg1,msg2,msg3,msg4,msg5,msg6,msg7]; "
How to use APIs with Node-RED: OpenWeatherMap Example
28:06
Opto Video
Рет қаралды 51 М.
Intro to JSON for Node-RED
12:58
Opto Video
Рет қаралды 50 М.
Running With Bigger And Bigger Feastables
00:17
MrBeast
Рет қаралды 153 МЛН
Алексей Щербаков разнес ВДВшников
00:47
English or Spanish 🤣
00:16
GL Show
Рет қаралды 5 МЛН
ROLLING DOWN
00:20
Natan por Aí
Рет қаралды 11 МЛН
My Workflow for Building any Streamlit Dashboard Project
9:40
Fanilo Andrianasolo
Рет қаралды 82 М.
How to style a custom Node Red Dashboard
12:36
RuWindustries
Рет қаралды 37 М.
I Never Want to Create React Tables Any Other Way
5:40
Josh tried coding
Рет қаралды 257 М.
How to Get Started with MQTT
13:38
Opto Video
Рет қаралды 400 М.
How to use MQTT in Node-Red: basics, examples, tip & tricks
29:21
Csongor Varga
Рет қаралды 41 М.
Top 5 Node-RED Core Nodes
15:04
Opto Video
Рет қаралды 125 М.
Running With Bigger And Bigger Feastables
00:17
MrBeast
Рет қаралды 153 МЛН