Hi Airtable community!
I am working on a table that inputs schedules for our contractors. Their schedule is then linked to their dedicated record in our database. An issue arises when they schedule for next week before this week due to the sorting of the linked records. I found a way to sort linked records by the week they’re scheduled for by placing said week in the name of the record that we are linking. I can then order these by the week using the Batch Update block. So that solved my problem, now the issue is that the Batch Update block needs to run every time a new record is inputted into the schedule table.
In essence, is there any code I can write in the scripting block that will automatically trigger when a new schedule is inputted that will trigger to run the Batch Update block?