I have been thinking of ways to reduce my usage of the Looper custom widget and instead utilize Automations which could be more reliable or at least a better experience for the users.
A key feature I would need to see to accomplish this would be a built-in Action to Get Table Records…multiple records. To me it seems the existing Query and Aggregations could be used to return a list of Unique IDs which when passed to a Loop action could make Updates to each record. Any filters in the query set to App Input would of course require input from within the Automation.
Example: I have a PARTS table that contains a single record per serial numbered part. I have a second table DOCUMENTS that contains uploaded PDFs with inspection and other test reports…multiple records per serial numbered part. When Quality signs off a part being complete, I want to update a field on each related record in the DOCUMENTS table to indicate the document was approved. Probably many more examples but this is just one.
I understand I can likely accomplish this using a connector function however having it built in would make it much easier and cleaner for development.
I really see a need for using Queries in Automations. In my use case I have a mapping table holding Ideal Run Rates based on Article and Machine combination. I’m looking for a way to set the Ideal Run Rate of my machines based on a given Article-Machine combination. Specifying the Record ID is just not possible without a lookup action first.
In my current case, I trigger automations by an updated table record. When a specific status is set, it loads the project number and deletes all records for this project in another table.
Unfortunately the only way to find these records to delete is the table API
But I can’t grand access to connector editing to everybody, especially because I can’t include or exclude specific connectors (all or nothing access).
Hi @thorsten.langner we understand this would be a valuable improvement for Automations. We’re weighing building out key features like this vs investing in App Functions, and are hoping to circle back to Automations new features after getting the core Functions feature set out.
Have you had a chance to surface your needs to your customer success manager? We’d be happy to jump on a call and chat through what we’re working on for Functions and Automations, how we are thinking about sequencing, and also get your input live.