Barcode scanner auto-fill

Hi legends. Is it possible to scan a barcode and have the form auto-fill the item data eg. Name, Price, Category, etc? (if the code has been scanned previously)

If so, how would I go about it?

Thanks in advance

Dan

2 Likes

Thanks mate. I thought it may have had something to do with lookup. Appreciate your input :+1:

So it seems I’m still an absolute noob and can’t for the life of me work this out. The name field on my form just disappears.

In the app formula of Name column, I’ve put:

If((“INVENTORY_Form” = CONTEXT(“View”)),
LOOKUP([Code], “Inventory”, “Item Name”, “Code”),
“Select Name”)

I want the name field (among others) to display the item name of an already scanned bar Code. How the heck do I achieve this?

Any help would be greatly appreciated :pray:

Hi @DC81
Check out the Lookup doc @Marc_Dillon posted.
I think it should be more like.
LOOKUP([_THISROW].[Code], “Inventory”, “Code”,“Item Name”

2 Likes

That partially works. It brings up an item that’s already been added to the list but won’t let me add a new name to a new barcode. Any ideas?

The Item Name field is an Enum dropdown list with Allow Other Values selected. If any of the barcodes match, the name field is unselectable, otherwise it doesn’t even show on the form.

Thanks for the advice too! :+1::+1:

1 Like

Got it. I put LOOKUP([_THISROW].[Code], “Inventory”, “Code”,“Item Name”) in Initial Formula with isnotblank([Code])=true in show_if for Item Name column.

You guys rock, thanks for the help!!

3 Likes