# How to create science lab inventory

**URL:** <https://community.glideapps.com/t/how-to-create-science-lab-inventory/25592>\
**Category:** Ask for Help\
**Created:** [April 15, 2021, 1:50pm UTC](https://community.glideapps.com/t/how-to-create-science-lab-inventory/25592 "2021-04-15T13:50:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rocco\_Williams](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rocco_williams/32/24930_2.png) [@Rocco\_Williams](https://community.glideapps.com/u/Rocco_Williams)\
**Post date:** [April 15, 2021, 1:50pm UTC](https://community.glideapps.com/t/how-to-create-science-lab-inventory/25592/1 "2021-04-15T13:50:39Z")

</div>

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!

> **[Science Inventory](https://habitual-name-0713.glideapp.io/)**

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [April 15, 2021, 2:03pm UTC](https://community.glideapps.com/t/how-to-create-science-lab-inventory/25592/2 "2021-04-15T14:03:06Z")

</div>

Take a look at this.

> [@Reset Multiple Rows At Once](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211):
>
> There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n…