Hi all, I am new to Airtable and would be grateful if anyone can point me in the right direction. Here is my use case:
I manage freezer inventory for a small family business. They bring it food items, vacuum seal them and place them in freezers. The issue is, no one can remember what or how many of any specific item is in the freezers.
I would love to be able to create an item tracking system for them in Airtable.
For entry, I would like a form that they simply enter an item description. Once submitted, an item number pops up that can be written on the item. (Ideally, if there was a way for it to print a barcode on a computer attached Brother PTouch label maker, that would be incredible). But either way, after an item is entered, it provides an item number, checks the item in as “in freezer” and adds a date.
For removal, I want it to be extremely simple. When a staff member pulls something from the freezer, I would ideally have an ipad with a barcode scanner. When the item is pulled, they scan the barcode (or type in the item number if barcodes aren’t possible) and after entering the number, it displays the item for confirmation. Selecting confirm then either deletes the record from Airtable, or marks it Removed and records a removal date.
One other idea...it would be good if items can be searched by keyword - for instance, searching the word chicken would bring up a list of all related items - chicken legs, chicken breasts, chicken nuggets, chicken and rice, etc. With that list, having it display item numbers would be helpful so then when they go to the freezer, they can find the item and then remove it with the barcode scanner as described above.
I hope this makes sense and is possible to achieve. If anyone can help me get started with this, I would be grateful! If you need any clarification, please let me know. Thanks in advance!