Currently I have been using node-red to send MQTT data to a SQLite Database and store the data. I then used the dashboard for end users on the production floor to see the last 25 rows in the database.
I used the template node to create a Table that only holds 25 rows of data on the dashboard. And I made a buton to click to grab the newest 25 rows of data from the SQLite database.
My question is there a way to get rid of the button and have the table automatically generate the newest data entry to the bottom of the table and then roll off the oldest data entry.
I will Leave a Picture of my Node red and the dashboard within the template node.