GAS – simple data entry

You want to make life easy for your users, and reduce the opportunity for errors when entering data! This simple example allows a cleaning supervisor to enter their inspection scores (items clean / items dirty) for an area, calculates the percentage score, then moves the information to a second data sheet in a list. There is a drop down validation for the locations, and the date field validation allows a double click to bring up a mini calendar. The script is attached to the Submit drawing.


At the end of the script, all the fields are cleared ready for the next entry.

Leave a Reply

Your email address will not be published. Required fields are marked *