I have created a sheet in Google Sheets that is basically a form users fill out. They fill in the blanks, then press a button to run a script based on the data. However, no matter how I warn them, they don't exit the last field before clicking the button, and the script perceives that the last field is empty. I have tried letting the script activate another field on the screen, but it doesn't seal in the value before doing that. Is there another command that can force the value to be written to the field?
CodePudding user response：
Use a checkbox at the end of your form and have them click it. This checkbox does nothing, but it changes focus from the last field to the checkbox.
CodePudding user response：
As an additional option to what 