I want to search by extracting only a part of the scanned text string

[yj_Lee]

I have a column in my table with a unique code value of 8 digits.
However, when I scan the QR code, it scans with a longer string.
The string I’m looking for is part of the scanned string (8 digits).
Is there a way to extract the scanned value and find one that matches the value in my column?
Thank you.

[Koichi_Tsuji · Accepted solution]

Worth visiting another post recently thrown by other member.

Quick scan and put away function for inventory Questions

Set your scannable field as required. Just show this scannable field only on your form view. Set the form view as auto-save, as well as advanced-automatically. Then attach any deeplink action to this form so that you let the user navigate next as what you want. On your case, I further recommend that you make just a quick table, Id and one scannable field, just for “scanning purpose” only. This quick sample app may help https://www.appsheet.com/samples/Public-Sample-App?appGuidString=7f122a…

[yj_Lee]

Thank you for your answer.
I analyzed your sample app and solved the problem!!

[MyPill]

HI,

unfortunatelly, the sample app is not available any longer. I face similar problem as you did. May I ask you the share your solution?

Thanks!

[Steve]

help.appsheet.com

MID()

Characters from text