How do I scan a QR code and fill up the form with the data extracted from the QR?

[ssvvaaff]

I have a QR code which has data such as:

AISLE B1;LOT 21;LOCATION B1-21
AISLE B2;LOT 22;LOCATION B2-22
AISLE B3;LOT 23;LOCATION B3-23

The form contains a location input that requires a QR code scanner. Once the QR code is scanned, the location will be extracted from the QR code value. How do I do this?

[Aleksi]

You can do that for example with INDEX(SPLIT([QR],";"),3)

[ssvvaaff]

When I scan the QR code, it extracts the information as a whole and not as the split value. How do I resolve this?

[Aleksi]

You can either read the last value from the string in another column or you can add an Event Action that it will be triggered when the record is saved.