Hello!!
I built a basic inventory app for the inventory used in a biological research lab. In order to make the app work the way I need it to, I have all of the inventory in a single spreadsheet, which is used as the database in AppSheet. The app is organised by category: Bacteria, Yeast, Oligo, etc etc. When you click on a category, you can view all the items in that category.
Everything works perfectly, except for one thing. Certain inventory items are stored in test tubes, which are then stored in 20 x 20 grid boxes, which are then stored in different freezers. When viewing one of these items, it would be extremely beneficial to see a grid view of exactly where in the box the item is located. This is due to the need for the box to be kept below a certain temperature, so the faster an item can be retrieved from a box and returned to the freezer the better. In addition, it would be beneficial to see if a particular box has any empty slots, without physically removing it from the freezer. This would allow a researcher to quickly get a sample into a box in the freezer and easily add it to the inventory. Also, this "view" would only apply to about four out of 10 categories.
With traditional code, like Java or Python, I could make this happen by using a 2D array. However, I cannot figure out how to do this in AppSheet. I was thinking that "slices" could be used, but I honestly cannot figure how to get slices to do anything I want them to. Any help or suggestions would be greatly appreciated. Thanks in advance!!
LinkedIn
Twitter
