We build a simple Employee Time Tracking app with AppSheet and use the AppSheet API Workflows to automatically create and update time cards for users of our app.
We build Batch Actions to
- 0:00 - Intro
- 12:20 Create a batch of time cards
- 32:40 Update this pay periods time cards
- 33:30 Mark all time cards paid when we run payroll for a given time period.
- 47:20 Debug Broken AppSheet API Calls
API Workflows are great for:
- Making time related batch updates via Reports
- Updating many records at once without clogging up a bunch of syncs on the user device
- Creating multiple records at once
- Running AppSheet Actions & Adding data via 3rd party applications
LINK TO APP: https://www.appsheet.com/template/showdef?appName=QREWScheduler-1733516&quickStart=False
LINK TO API DOCs: https://help.appsheet.com/en/articles/1979979-invoking-the-api
LINK TO COURSE ON DYNAMIC TEMPLATES: https://appsheettraining.com/path_detail/templates-and-document-generation
Feel free to catch us every week for a new concept from AppSheet Training using this link: http://appsheettraining.com/webinar
www.AppSheetTraining.com
QREW Tools Extension: https://chrome.google.com/webstore/detail/qrew-tools/hklmffdokpefcfabkmkpjnkoakehigjg?hl=en-US
Expressions Library: www.appsheettraining.com/expressions
