Some are controlled by a relay, some by RS485, some by SSH, some by a MFG card in the PC, some by MQTT – it all depends.
So, its needs to be my program (lets name it the: Service program) that receives the input, and from there i ‘distribute’ out the needed action. Not the individual machine.
It could be as simple as 1,0 for machine 1 off, 1,100 full on/100%, 1,50 for % (if it’s a machine that handle more than just on/off), so a string of ‘
1,0 2,0, 3,1 4,75’ would be just fine - of cause in JSON format.
It’s a very similar idea, as what you show on https://community.glideapps.com/t/glide-with-iot-iiot-industrial-iot-and-domotic-applications/22698
I see you use Make/Integromat, but you can’t get the time down under 1 min. I was considering investigating them, after Zapier.
But I need to have a response time of about 10-15 sec. however there will only be issued out 20-60 commands/actions a day.
Is GS-script, like a macro/script running on the google sheet?
I was considering a similar approach, where my Service program would be scanning the Excel file for changes, then act accordingly.
I’m not sure what kind of response time I would get, with that approach.
What we truly miss is an official Glideapp IoT gateway / Broker, something you’ll connect directly to your glide application, which then communicated with your ‘Service program’ at the corporate/factory LAN
A Glide-MQTT broker would be brilliant, with a closed proprietary protocol from glide.pages <> my.local.Glide.MQTT broker.
Imagine the stuff you then could make, the sky would be the limit