Hello,
In a QRCode scanning, it returns like
โSERVO- Mechanic Parisu Darbar
SUPER MG 20W40 (7494) - 7.5 Ltrs
Points - 150โ
This is the key to search the master data in a table. But its unable to pick up the data though its available.
Please advise.
Regards,
Senthil
What does the stored value look like? How is it that the stored value is different from the scanned value?
I checked the excel sheet, both looks similar. The excel text comparison function also returns true.
Please provide screenshots of the following:
Thanks @Steve, Given below the requested details & screenshot. That data field is a key column, so not expressing. Sample data is given below
โSERVO- Mechanic Parisu Darbar
TRACTOR OIL PLUS 15W40 - 7.5 Ltrs
Points - 150โ
Both columns should be the LongText type, not Text.
I tried this option already, the following exception thrown
Column Name โUIDโ in Schema โmechanicMaster_Schemaโ cannot be scanned (not Barcode scannable) because its Column Type is โLongTextโ.MORE INFO
Then Iโm out of ideas! I encourage you to engage support@appsheet.com for further help.
Thanks @Steve, Will do
Hi @SenthilD, I am still learning this barcoding and I saw this post.
Just asking if actually your Key column is a multi-line text? As I saw your post that twice:
What if you make it like:
SERVO- Mechanic Parisu Darbar SUPER MG 20W40 (7494) - 7.5 Ltrs Points - 150
So that it will find only โOne stringโ?
Hey @Heru, thanks. its a multiline text. The problem is, vendor has configured the coupon QR code that way. So I didnโt have a choice. Now Iโm using a workaround, string tokenisers to extract the required data out of it and posting into table.
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |