O'Reilly logo

Learning Google Apps Script by Ramalingam Ganapathy

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating an employee timesheet application

From the knowledge and experience gathered by creating the preceding applications, you can create this full blown timesheet application. This application can be used in an organization or company to log employees, worked hours in a day or shift. The daily attendance data will be backed in the Backup Sheet for future reference.

Create a new spreadsheet with a Sheet named EmployeesList and populate it with employee names. All these names will be listed as a dropdown automatically in the user interface.

Creating an employee timesheet application

Create another Sheet named TimeSheet and arrange the column headers as shown in the following screenshot. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required