🚨 Glide working as GUI for IIoT projects

Hi everyone!

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! :woozy_face:)

image

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.

7 Likes

Nice! You can add the current date to the fetch parameters… and it will update it every 10 seconds :wink:
The charts are super cool! And gages… super extra cool!!!

1 Like

Thanks for testing!

yes, you are right. I know and use that trick as well: the “t” parameter

The APP is reading and making API requests every 10 sec although my data is changing and being saved every 30 sec. I left that function to test how the app works for days (abusing this) and so far the performance is still normal.
I will fix it once I get a real customer with a real process in order to avoid unnecessary API calls.

Gracias de nuevo!

You can make a lot of API calls… don’t worry about that :wink:
You can make 300 per minute… so 50 users at the same time using your App…
And if you have a Workspace account is 3000 per minute… 10x more for just $12/month

BTW, you are covering your LInk in the screenshot… but do you know that everybody can see it? :wink:
Protect your Spreadsheets! I see that you don’t have any sensitive data there… but just to be alert, you left your sheets and scripts wild open…

1 Like

Right!!

When I read about these limits given by Google weeks ago to use their Google Sheet API I knew that I had to use and test them and so far, everything works without trauma.

I almost forgot thanking @Jeff_Hager for his help and clever code to create dynamic animations based on HTML. Your idea and code shown here generated my animations:

image

Cheers Jeff … que tengas un increíble fin de semana!

4 Likes

Hi @Bungchow_IDEApps … I think it can be useful for you.

Saludos!

1 Like

I’m gonna see your app. Thanks @gvalero :+1: :+1:

Hi, gvalero!
Whats to say? Cool!
Just i see some proceses are continously taking around 20% percent of my processor just to fetching data, doesn’t matter which tabs.


Could you please tell more, why you need column.sh for?
Why you use google for storing data? What is main reason? I mean why not some another platform?
Thanks!

Column.sh is the host for multiple column types in Glide, at least it was the case before 2023.

I’m not sure if they still use it, but looks like they still do from your screenshot.

1 Like

Hola!

Let me come back to my home and I will reply you with further details.

Happy 2024!

1 Like

Looks very nice! How did you make the gauges? and can the gauges be based off a glide sheet instead?

Hola @Myles_Chaput , sorry for my long delay.

I’ve been sick and busy these weeks and now I’m trying to make up for my time by enjoying working with Glide and helping people.

My gauges come from Google library (free), you can learn and play with them here: Visualization: Gauge  |  Charts  |  Google for Developers

What do you mean with:

can the gauges be based off a glide sheet instead?

Are you referring to whether they can work without using the Web Embed component? If so, unfortunately the answer is no.

@slscustom.ru my apologies as well, I hope you are fine!
Regarding with your questions, here my answers:

Could you please tell more, why you need column.sh for?

To be honest, I don’t know what process Glide internally uses in their columns, in my demo I use very often the Construct URL and Fetch JSON columns and some JS codes but I don’t have critical issues with my laptop’s CPU or phones.

Why you use google for storing data? What is main reason?

It’s free and allows me to store enough data for what I’m trying to do/display (historical data). :wink:
If I use GT instead, I would have to use Glide API and each transaction/write will consume one update and within 3-4 days, my quota will be far exceeded. It would be a very expensive and hard solution.

Using a Google Sheet, I can store up to 70k-90k rows and read its data via GS API easily and free every 30 sec or 1 min.

Saludos!

2 Likes

This is seriously mindblowing to me! :sweat_smile:
Especially Google sheet with up to 90k rows workaround that doesn’t cost any updates… I just don’t understand how :exploding_head:
May I ask you if you can share any tutorials or helpful posts that will elaborate on this capability?
Much appreciated!

Hola Nataliya!

Depending on Google Sheet API version you use, you can have many options to easily retrieve data and almost for free.

Here we talked about it with some additional tips:

and here you can see and play with GS API v4’s some practical examples to read range values, columns, etc:

The plan C could be to use a service like Sheet.best to turn your GS into a REST API and have many options to write/read/update/delete your data for a comfortable fee. I have tested this service before and it very powerful.

Have a nice night, saludos!

1 Like

Thanks a tonnnnn!!! :star_struck: