I’ve been searching for a solution and it seems like a simple issue but I cannot get it resolved. I am desperately seeking some help!
When I scan a UPC barcode, the 12 digits appear in my barcode field. I want my table to automatically populate in another field the product that is associated with that barcode. We use barcodes internally for inventory management so none of them are registered. So, essentially, I just want AirTable to know that X series of 12 digits is X product.
I tried using automations as my solution but that doesn’t work because I can only have 50 automations in my Pro plan and I need this to work on thousands of products.
Trigger: When record is updated on the field that get the code from the app
Action: Find a record, in your product table where product code is scanned code
Action: Update a record, add the record product name from step 2 into the place you want it
At least I think this should work. I think find only gathers up to 50 records, but if your products to codes are 1:1 you should be ok.
Alternatively, if the table of products has the barcode as the primary field, just automate pasting the barcode from the barcode field into a linked record field, and then lookup the other fields that you want to see.