Scan barcoded item and have details show up in different record under same table

[scaretable]

Hi, I’m an Airtable Newbie.
At work we are setting up an inventory of our items/assets to be checked in and checked out of our warehouse. We have an Asset Management Base set up and populated. The individual inventory records are barcoded as well.
What I’m looking to do in the same base, but under a different table, is run a check in/out list.
Ideally we would be able to use the Airtable mobile app > open up the base > go to our check in/out table > scan items in or out > have the table automatically fill in the designated fields.
At the moment, I don’t see anyway to do this, other than scanning the barcode and then manually linking to an existing record in the Asset Management table.

Any help/advice is greatly appreciated.
thanks

[JonathanBowen]

Hi @scaretable - this cab be done with Airtable Automations. Take a look at this post for the general setup:

Use of Barcode as Unique value for Linking to Auto Populate other values Ask the community

Hi @Mehul_Bhandari - have a look at this post as your problem (and a solution!) is similar: If this is your product master table: [29] in the form entry table, just snap the barcode and quantity into two appropriate fields (I’m assuming you’re using a mobile device to scan the barcodes, but this doesn’t matter): [27] Now create another column “Barcode Link” (which is a link to product master) and copy and paste the barcode values into this link field. You can add a lookup field that sho…

But now, instead of copying the values from the scanned field into the linked field you can use an automation to do this for you:

When a record is created -> Update record -> Set the linked field to be the value of the scanned field

[scaretable]

Thanks @JonathanBowen, I appreciate the reply. I’ll give this a shot and post on my progress/outcome.
Thanks again.