Thanks for the super fast response.
The answer is really disappointing (the 2nd one in the last 48h while starting diving deeper to airtable :sneezing_face: ).
But now I more understand the insight you gave here : Create weekly snapshots of totals from other tables -
talking about the Google Apps Script - I read this in their restrictions:
"[…]Because simple triggers fire automatically, without asking the user for authorization, they are subject to several restrictions:
Range.setValue()to edit a cell does not cause the spreadsheet’s
onEdittrigger to run. […]"
=> seems like my use case(s) won’t work as I am not allowed to get it started from “outside” or in a scheudled manner. So kind of same - same here (regarding the time/trigger control of actions inside from outside) - or am I missing something?
It might seem that way, but you’d be wrong to believe what you think it seems. :winking_face:
Currently, I have more than 80 clients running Google Apps Script across more than 500 automation processes every five minutes. Some, every 60 seconds. Every one of them are script trigger processes created and managed in Google Apps Script.
The restrictions you cite are actually advantages in most automation process requirements. You must also understand that every Google Document (spreadsheet, presentation, word processing document) is a serverless container - a persistent web process that is capable of being a server in and of itself as well as an automated (and manual) scripting engine.
Moving any sort of data process to an external environment provides you with almost every imaginable data-centric pathway to create solutions where the core platform fail to provide the integrated features. Google Apps Script is simply a good one to investigate.
Yes , I confirm, I’m one of these Folks, as @Kasra is knowing it.
As scripting represents for me a part time activity to serve the particular needs of my main job, I deeply regret having to start searching on another platform for services as elementary as external triggers, timer or calendar driven actions that I found on an embedded microcontroller (interrupts, timers)!
This is my biggest regret about airtable and especially scriptable airtable.
(My second and last regret is the impossibility to process VIEWS by macro or by script but it’s still possible to get around that with a lot more work).
Thanks to @Bill.French (and Expert Developers Scripters) for teaching the Community, for their time and energy!