Skip to main content

Freezer mapping and sample organization

  • December 16, 2021
  • 1 reply
  • 0 views

Forum|alt.badge.img+1

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

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


Reply