I have a table called “Junctions” and what I want is that whenever there is a change happen in my table (say adding/updating/deleting a value) then I want to call my custom script which I have written in “Apps” to perform some operation related to those changes.
Is there any trigger which I can call to run my apps script whenever there is a change in a particular table?
You can run scripts as part of an automation. Automation scripts are very similar to Scripting App scripts. There are slightly different ways of inputting which record to act upon.
There are also a wide array of automation triggers. However, use the “when record updated” trigger with extreme caution. Every single key press in an editable field counts as an update, so it is easy to accidentally have an automation run prematurely (and multiple times) when using this trigger.