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.
Freezer mapping and sample organization
+2
+12Hi @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
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.