I'm trying to get a dynamic list of "Current Viewers" of over 50 Google Spreadsheets in just one master sheet. So far, I've got the code to run that inserts a new row using the onOpen function (just a row that records: user email, viewing document, date of entry, time of entry etc.) and I've also got the code to remove the entry when they exit - I just have no way of firing the code upon exit!
This is why I'm looking for an OnClose() or OnExit() function - just like the onOpen one. Is there any way I can accomplish this?
There is no onClose/onExit functionality in Apps Script.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With