Control (Line Feed Character) in a data

AppSheet AppSheet Q&A
1

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

2

What does the stored value look like? How is it that the stored value is different from the scanned value?

3

I checked the excel sheet, both looks similar. The excel text comparison function also returns true.

4

Please provide screenshots of the following:

  • Configuration screen of the column receiving the scanned QR code.
  • Configuration screen of the column containing the stored values.
  • Entire expression used to match the scanned value to stored values.
1 Like
5

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”

2X_0_0b84c66774cf771b334841a82937ca5984b4a534.png
2X_0_0b84c66774cf771b334841a82937ca5984b4a534.png426×172 10.5 KB

2X_2_2857e2298a58fffe1a18abfb1845506cd1ad2744.jpeg
2X_2_2857e2298a58fffe1a18abfb1845506cd1ad2744.jpeg426×172 8.86 KB

2X_9_9448fe91b20ca971fdeb7b0fd403d30b81247dc0.png
2X_9_9448fe91b20ca971fdeb7b0fd403d30b81247dc0.png418×244 10 KB

2X_0_0b8e49e926c752f1fdb1d88fa28f0cb7774632a7.jpeg
2X_0_0b8e49e926c752f1fdb1d88fa28f0cb7774632a7.jpeg418×244 10.5 KB

1 Like
6

Both columns should be the LongText type, not Text.

1 Like
7

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

1 Like
8

Then I’m out of ideas! I encourage you to engage support@appsheet.com for further help.

9

Thanks @Steve, Will do

1 Like
10

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:

SenthilD:

“SERVO- Mechanic Parisu Darbar> TRACTOR OIL PLUS 15W40 - 7.5 Ltrs> Points - 150”

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”?

11

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.

1 Like