How to create science lab inventory

I’d like to create an inventory of science equipment at my school. For ease of use I’d like users to be able to find where the equipment is and simply press a button to “check-out” the number of items and the quantity adjust automatically. I have figured this much out in my sample below. However, for returning the materials, I don’t want teachers to have to go to each item individually to “check-in” what they are returning. Is there a way for a type of “shopping cart” function to be added that would track all of the materials they have “checked out” and then be able to press 1 button in their “cart” in order to return all items and their respective quantities would adjust automatically? Thanks in advance!

Take a look at this.

2 Likes