Scan & Search
In a Ref Dropdown I want to Scan a Barcode to find an item. The Barcode is part of the Label. But the App says โThe can result didnโt match any known entriesโ. If I create a barcode from the Key, then it works. Can I scan for the Label of a Ref?
@Fabian Have you tried making the key and label same column? Label of a ref is simply an โeasy-to-readโ representation of the key column value. Therefore itโs working with the Key.
@Levent_KULACOGLU Label cannot be the Key because it has to be editable.
@Fabian the solution may be this; if the labels will be unique, then you can have an appformula in your key column like
=[_THISROW].[LabelColumn]
and then make it both the key and the label. As I donโt know your sequence, Iโm just brainstorming.
@Fabian I do this in most of my apps! Make a label column with a CONCATENATE expression and make that virtual column searchable and the label.
Key column
Product name
Barcode kF47ySil
Hot Wheels
856305011
My Label check box is on the virtual column called Product Label and the expression looks like: CONCATENATE([Barcode]," ",[Product Name])
I think this is what you are looking for.
@Aaron_Moolb that will surely work. Thnx for the heads-up.
Hi all!
I am a new user in the appsheet (beginner, made two apps already), and I have problems with Ref Dropdown QR-code search.
I have another Excel file that I pick up information.
QR-code scanning does not give the result, only notify โthe scan results didnโt match any known entriesโ.
If I type something on Search field (Name or ID Code), search results finds those items.
I already did follow @Aaron_Moolb instructions, and otherwise all works, but scanning does not.
I have in AppSheet one table called โItemsโ and Key is [Item ID] + one Label is image-column + one Label is [CalculatedName] with expression โCONCATENATE([Name],โ โ โ,[ID Code])โ.
Then I have another table called โTools1โ with [Name] column that column type is Ref, and it refers to โItemsโ table.
โTools1โ [Name] column is Searcable and Scannable, with Auto Input mode.
Please helpโฆ
And if you need more information, please ask.
I will be happy to send additional information
Thanks!
Hi all!
It is working.
But I need to change Ref - โID Codeโ to Key value.
So, everything is fine now
Thanks!
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |