An app for store inventory management. Sort products by unique categories.
How we built this appWe built this app in under 30 minutes. Here are some design highlights: 1. Slice columns. We went to Advanced Editor > Data > Slices and selected a slice that shows all data rows but only shows a subset of columns. We filtered some columns that are important for the spreadsheet but are not necessary for the app, making data entry cleaner and faster. 2. We added bar-code reader to the data entry. We turned the bar-code reader on by going to Advanced Editor > Data > Column Structure and enabled Scannable in the Name field. This helped us entering bar-code information instead of typing an Item name. 3. We added a formula to the “Inventory Value” column in the spreadsheet that shows the spreadsheet user the monetary value of current inventory based on multiplying the "Quantity in Stock" and "Unit Price" columns. Pro tip: You can create a second table where you collect all Item names and add bar-code information next to it, you can then use a VLOOKUP function in the table to extract the product name and simply record the item number using the app's bar-code feature. This will save you hours over time! Copy this app for free and change its data to your own products.