before after As mentioned in the title, I’m looking for a way to automatically save a sheet while it’s still being edited. I want every single change, even as you’re typing, to be saved immediately. For example, if a small change occurs, it should be automatically saved. Essentially, I want a button that, when triggered, saves the cell that’s currently being edited, even if the editing process is not yet complete.
I tried creating a duplicate sheet to check if it’s saved, but that didn’t work. I also attempted to change the active selection from the editing cell to another one, thinking it would automatically exit the editing mode and save, but it still doesn’t work.
Aron Inopia is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
3
Is it possible to implement an autosave feature in GoogleAppsScript that also saves active cells/the cell being edited when the function is triggered
The answer is no. There are no Apps Script triggers that fire while you are editing a cell.
-
The “on edit” event fires after a cell edit is complete.
-
The “on change” event fires after another kind of change happens.
-
See Automation triggers and events for more.
You could create a browser extension that captures individual keypresses during an edit, but that cannot be done in Apps Script, and it would take some actual programming.
4