Barcode scanner auto-fill

[DC81]

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

[Marc_Dillon]

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

help.appsheet.com

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.

[DC81]

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

[DC81]

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

[Lynn · Accepted solution]

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

[siyadk]

Hi Lynn,

Can you please help me for Auto-Fill for the below

I have two sheets 1) Item Master sheet and 2) Count Sheet (Blank)

Item Master Sheet Column Order (BARCODE, CODE, BRAND, DESCRIPTION)

Count Sheet Column Order (Date(auto), Barcode, Code, Description, Brand, Qty)

Barcode (Scanning Manually)

Code (Auto-Fill)

Description (Auto-Fill)

Brand (Auto-Fill)

Qty (Manual)

[Steve]

Everything you need is in this topic.

[DC81]

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!

[Marc_Dillon]

DC81:

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.

help.appsheet.com

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.

[DC81]

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!!