Hello everybody. How are you?
In my second post, I would like to describe you a problem I have been facing since I have created a trigger called “unCheck”.
The basic idea involved in this script is to uncheck a checkbox if its value is true for a specific duration, let’s say 5 minutes. There are two functions inside: onEdit to record when it was edited and the variables related to the edited cell and the uncheck function which receives the variables and compare the time the checkbox was checked (TRUE value) with a specified time. If it’s equal or higher to the specified, the checkbox is unchecked.
The problem I’ve been facing is that the script is only being able to recognize editions I’ve done while working directly on the Google Spreadsheets. I’ve tried many times to edit using the app and the checkbox doesn’t get unchecked afterwards.
Does anyone know a way around this issue? Please let me know!
Danillo S. Soares