Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How to associate automatically barcode with another field

Topic Labels: Base design
Solved
Jump to Solution
250 5
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Any help would be hugely appreciated. Thank you!

1 Solution

Accepted Solutions

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.

See Solution in Thread

5 Replies 5

Hi @Olivia_Ake
Welcome to the community!
I do not think that you need 50 automations, one should suffice.

Do you have a corresponding table of products and the matching code?

Thank you @Vivid-Squid! I really appreciate your response.

Yes, I do have that.

You should be able to set up an automation

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.

Thank you, @ScottWorld. That solved my problem. Thank you for taking the time to help me.

@Vivid-Squid Thank you for your help too. I was having a bit of a hard time with the finding the record step but that’s probably on me.