A convenient app for company employees to track equipment inventory.
How we built this appWe created this app to highlight some key features in AppSheet: barcode scanning, conditional formatting, and dropdown menus (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 check the "Scan?" checkbox. 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. You can either ENUMS directly in AppSheet by going to Advanced Editor > Data > Column Structure and change the field we wanted to ENUM; then add the items you'd like in the dropdown menu. You can also include your dropdown menu items using data validation in the spreadsheet as we did with this app. 4. Last we added a set of slices and formatting rules that apply a colored icon to each Equipment ID field, letting the user know if the item has been verified or not. Copy this app for free and customize it to fit your business needs!