Help

Freezer mapping and sample organization

Topic Labels: Base design
932 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Lynch_Lab
4 - Data Explorer
4 - Data Explorer

I’m wondering if there is a useful airtable app or organization strategy that could be used for freezer mapping and sample organization? It would be similiar to an inventory catalog but would need to track multiple freezers/shelves/racks.

1 Reply 1
Williams_Innova
7 - App Architect
7 - App Architect

Hi @Lynch_Lab,

I’ve set something like this up with basically two tables in a base.
The first table was items with locations (widget 1 in rack A, shelf 2, bin 2). This table also had values that were updated from the second table.
The second table had actions (remove/add). Anytime an item(s) was added or removed from inventory, it was logged along with quantity. There was a formula field that would make the value positive or negative. This allowed me to use a roll up in the first table that would keep track of all the removals or additions.

Chris