TL;DR: will airtable let me build a usage log?
I’d like to scan barcodes into a Use record, then add all those barcodes to a linked field, so that bringing up the individual gear record, shows each use (a list of dates).
I’d like to do that without needing to scroll through all 200+ pieces of gear, each time I try to add a record to the linked field. And I’d like to do it without needing to add a record for each piece of gear on each use, because that seems wasteful.
Perhaps I’m just misunderstanding the power/use of linked fields and there’s another way to do this.
If there’s a way to Share the base I’ve been playing with, let me know
Here’s my situation: I’ve been tasked with selecting an electronic version of our equipment usage and inspection logging system for our Ropes Course. Our risk management association is also telling us that each piece of equipment needs to have individually identifying marks on it, so I was really hoping to do this with barcodes, but that’s getting ahead of things.
There’s a couple hundred pieces of gear (my “records,” I would assume). On a given day, I would need to be able to edit/add a date to the records of, say, 60 or 70 of these items, depending on what part of the course was being used (these 16 harnesses, these 20 helmets, these two ropes, etc.; this is why scanning a barcode while we put it away would be great).
Result would be the ability to show a log of all uses for each piece of gear, on request, so I’d want to be adding each date to a text field on the record, I think?
OR linking a Uses field to some other table of “Uses” maybe? I fear that a Uses table would turn into a very Record-heavy prospect though, with 50-60 pieces of gear being used on a daily basis? Unless there’s a way to log one day’s uses to one record? A Use form that creates a record for the Date with enough empty fields to cover the maximum potential gear that could be used in a day?
I see that if it’s linked, when I go to add a Use record, I can “+add” and scroll/choose from all the records in the Gear table, but I think it would be easier if I could just scan the tags I’m going to have to add to all our gear anyway.
If the primary name in the Gear table is the barcode, and I have a field for each piece of gear used, could I somehow get all the scanned barcodes arrayjoined into that linked field or something?