Hello Airtable family,
I’ve previously explored how to sort the linked records, finding the best approach was a manual sort using the ‘Batch Update Block.’
The purpose was so that when using our Airtable-based ordering system, when we clicked a customer record in the customer table, it would show linked orders sorted with the most recent orders at the top.
As I’m not the only one entering orders, it’s become a bit tedious and/or unreliable to use this method. I’m looking for a way to do it programmatically, either with an automation, scripting, or using even using Integromat.
In theory, I’m thinking the best approach might be an automation script that only triggers when a customers ‘linked orders’ array changes, though not sure how to set that up with views, triggers, ect. I can likely figure out the script part from pseudo code.
Any suggestions or ideas to try, I’m all ears! (Or, eyes…?)