Template
Fun with Images
An app to learn more about using images in AppSheet
Industry:
n/a
We demoed this app during an AppSheet Webinar to show how to add and manage images in your apps.
Loading...
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 number of 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.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...