Employee timesheet log with historical calendar
Function: Human Resources
This is app allows employees to track their hours and log time in and time out. The app allows for immediate calculation of total wages based on hours work, giving accounting or human resources all of the information they need.
Also see: tablet mode & fullscreen mode
How we built this app
The app takes advantage of the following features: information capture via forms, app formulas, virtual columns, references, image display. [Forms] Users submit information that is immediately synced back to the owner's spreadsheet. [App Formulas] In order to calculate wages based on time worked, we converted the time values into numerical values the app can understand. -For the Total Hours column, we subtracted the time in from the time out -For the Total Wages column, we multiplied the Total Hours by the hourly wage [Virtual Columns] In order for the app to be able to make the correct calculations of the above formulas, we needed to create virtual columns that run calculations but aren’t shown in the app. To do this, we needed to convert all of our time values into a decimal format. For the Number of Hours column, we used the following formulas to do this: HOUR([Total Hours]) ([Minutes]/60)+([Seconds]/3600)+[Hours] Users submit information that is immediately synced back to the owner's spreadsheet.
This is a preview of the data sets used in the app.
This is a high-level model of both the data entities and the UI elements in the app.