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

AppSheet AppSheet Q&A
1

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.

2

Worth visiting another post recently thrown by other member.

[Quick scan and put away function for inventory](https://community.appsheet.com/t/quick-scan-and-put-away-function-for-inventory/41471/2) 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…

3 Likes
3

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

2 Likes
4

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!