Scan to a form

[Larussa]

Hello!

I would like that when I scan a Barcode, the result would be placed inside the form in the sequence. R1, R2, R3, ...

Thank you

[rubin_boer]

hi @Larussa 

On the barcode scanner to a variable, for e.g.

OnSelect = ClearCollect(_BarCode,Split(BarcodeScanner1.Value,",")) assuming your barcode reads something like "R1,R2,R3,R4,R5,R6,R7,R8,R9,R10,R11,R12,R13,R14".

Add a Gallery and set its Items = _BarCode and its Wrap Count to 2.

Add a textbox to the gallery and set the Default = ThisItem.Result

This is what you will get

Hope this helps

[Larussa]

@rubin_boer 

Thank you for help me

I need to create a Gallery or  can you say a Form above(picture)?

...Add a Gallery and set its Items = _BarCode and its Wrap Count to 2...

[rubin_boer]

Hi @Larussa i used a gallery that way i don't need to create all the text boxes. you can create a form and set the each DataCardValue to the responding Value in the collection. The form may be more work but nothing stopping you to do it that way.

[Larussa]

Hi @rubin_boer 

I confess that I have a lot of difficulty with this. I apologize. I need to do it in a form so that I can save this scanned information.

What is missing for the scanned information to be inserted in the form?I did like this.

But the screen goes blank

[rubin_boer]

hi @Larussa Ok.

On the scan button add the following code

//Lets get the data from the scanner, you will have Set(_Scanned,BarcodeSanner1.Value)
Set(_Scanned,"R1,R2,R3,R4,R5,R6,R7,R8,R9,R10,R11,R12,R13,R14");
//lets split the barcode string so we can assign it to the datacards
ClearCollect(_ScannedArray,ForAll(Split(_Scanned,","),{Scanned: Result}))

Above unlock the datacard above and set the default of the card as

col1 default = First(_ScannedArray).Scanned

Col2 = Last(FirstN(_ScannedArray,2)).Scanned

Col3 = Last(FirstN(_ScannedArray,3)).Scanned

Col4 = Last(FirstN(_ScannedArray,4)).Scanned

Col5 = Last(FirstN(_ScannedArray,5)).Scanned

Col6 = Last(_ScannedArray).Scanned

On the Save button OnClick = SubmitForm(YourForm);
NewForm(YourForm)

In SharePoint

That should do it for you

[Larussa]

@rubin_boer 

Hi

look at this, please. Did I do correct?I believe I didn't. it didn't work