Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Freezer mapping and sample organization

Topic Labels: Base design
423 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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