QR Code - fillig up after scan

[Pepe]

Hello everyone!

I have a question that I couldn’t find an answer to in the forum.

I have made a form in which the employee can enter the bike number (“Numer naprawionego roweru” field) and a field with the possibility of scanning a QR code (“QR Kod” field ). Is it possible that after scanning the QR code, the result will automatically appear in the “Numer naprawionego roweru” field (but this number can still be edited)?

The data format in the QR code is: “http://ddd.cc/XXXXX” where “XXXXX” = bike number.

I would like the return value in the “Repaired bike number” field to be only XXXXX ( bike number ).

[Aurelien]

Hi @Pepe

Yes

help.appsheet.com

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.

In “Numer naprawionego roweru” field, with Initial expression:
[QR Kod]

Cheers

[Pepe]

Hello @Aurelien,

Thanks for answer!

I’m already a step closer. Unfortunately, now the entire QR code is pasted (together with “htttp: …”). What should I do to make sure that only the number at the end will be pasted?

[Aurelien]

If you know in advance the structure of the value in the qr_code, you may want to use various expressions to get the numbers you are looking for.
The purpose, in this case, would be to break the structure then extract numbers, maybe concatenate some pieces of the breaking

Please see:

help.appsheet.com

EXTRACTNUMBERS()

Extract list of numeric values within text value

help.appsheet.com

SPLIT()

List from text

help.appsheet.com

CONCATENATE()

Merged text from parts

[Pepe · Accepted solution]

Found it!

EXTRACTNUMBERS([QR Kod])