Template
Equipment Inventory
A convenient app to track equipment inventory
Industry:
Legal
Function:
Operations
The Equipment Inventory app helps users keep track of inventory items and quickly browse and search through those items. The app is an improvement over keeping spreadsheets as it makes the spreadsheet data easily available via mobile app. The data in the spreadsheet is in sync with the app and users can submit and edit items as needed.
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
We created this app to highlight some key features in AppSheet: Bar-code scanning, Automatic App definition, and Enumerations (ENUMS). Here are some app details:
1) Bar Code Scanning. AppSheet can capture data from bar-codes and QR-Codes, to make any text entry scannable, go to Advanced Editor > Data > Column Structure and mark any column you need as scannable. The Equipment ID field in the app is scannable.
2) The app was created automatically from the spreadsheet, including drop-down menus. AppSheet infers the type of data per column and assigns it a specific mobile app behavior. If you have dates, then AppSheet will treat the column as dates, same for phone numbers, emails, urls, and image links.
3) When the spreadsheet has drop-down menus using data validation, AppSheet automatically creates a drop-down menu for data entries in that field. This is called an ENUM or ENUMLIST in AppSheet. We edited the ENUMS directly in AppSheet by going to Advanced Editor > Data > Column Structure and changed the field we wanted to ENUM. We got to add the items in the ENUM and decide if we allowed other items or not. The drop-down menu showed the items in the order they were added.
Copy this app for free and customize it to fit your business needs!
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.
Loading...