We want an Action that changes a text value, to also trigger a Google Apps Script to run.
The script is setup to run ‘on edit’. And this works if we edit the text value manually in the spreadsheet. But if the value is changed by AppSheet, then an the scripts is not being triggered to run.
Any ideas on why this is happening and what we can do? Thanks!