title: Google sheets how do I ensure field change done before running script with button
body: <p>I have a sheet with a button (drawing) that executes an apps script. The script reads the data on the sheet and does some work.</p>
  <p>I keep making the same mistake. I change some data in a cell then push the button. Since the cell only saves on lost focus, and the button push does not cause a change of focus, the data has not actually changed. I have to make the change to the field, click on another field then push the button. There does not seem to be anyway to save all changes before the button press.</p>
  <p>How can I detect that I am mid edit and save what I have first then run my script.  Or is there a way to disable the button until edit is done?</p>