Most of you know my love for real-time applications and industrial process monitoring. Taking advantage of the fact that Glide has improved its capabilities and has powerful new tools, I made a new demo to simulate a small SCADA system to monitor 18 variables (I/O signals) .
My laptop simulates values from my virtual Factory (pressure, temperature, status ON/OFF, etc) and using a software working as “IoT Gateway” I can collect the data associated to my 18 variables and log all this to a Google Sheet every 30 sec.
Later, my App reads that data constantly via Google Sheet API calls (no automatic or manual Glide updates, I mean my app doesn’t consume Glide’s update quota) and any user can monitor the factory process regularly in a safe manner.
You will able to see how the devices’ data change every 30 sec on screens automatically while you monitor or analyze how the factory is working. Although I set the data update to 30 seconds, I could have set it to 10 seconds (faster) but I didn’t want to force a situation that is not normally intended for this type of solution.
A system like it can have an update rate every 3, 5, 10 min (or more) depending on the process to be controlled.
The APP has some technical tricks and advance animations/chart to help users to understand the data and the process (well… I hope so! )
I made a little video as trailer and help, you can watch it here Loom | Free Screen & Video Recording Software | Loom
And of course, anyone can test my demo clicking on https://myfactory.glide.page
Thanks in advance for testing my idea.
Gracias y feliz día!
Some caveats to keep in mind, please:
My laptop and my IoT gateway (a software) work as a data simulator so thy must be on obviously. I’m going to keep my laptop ON and running as much as I can. If there is any failure regarding data updating, probably the cause is generated by my internet or my laptop was shutdown… sorry!
The APP has a better view working on desktop. Unfortunately, using a phone doesn’t look like very well.
My APP or idea is not perfect, so any suggestion or clever idea to improve it is welcome.
In a real scenario, my devices (sensors, PLC, SCADA, IoT devices, etc.) may be sending their data to my data source directly on a web or my IoT gateway works as a single data collector and sends all to my data source (Google Sheet or other database) in a synchronized way.