Hi @Hachung ,
It's not possible to collect scanned values into different columns with one scan button. But if you have two buttons, you can use one to scan asset numbers and the other to scan serial numbers in to two collections. In the end, use a complete confirming button to combine the two collections together.
So, asset no. scanner OnScan:
Collect(colAssetNo, {AssetNo: Self.Value})
serial scanner OnScan:
Collect(colSerial, {Serial: Self.Value})
confirm button OnSelect:
ClearCollect(counter,0);
Clear(Combined);
ForAll(colAssetNo,
Collect(counter,Last(counter).Value+1);
Collect(colAssets,{
AssetNo:Last(FirstN(colAssetNo,Last(counter).Value)).AssetNo,
Serial:Last(FirstN(colSerial,Last(counter).Value)).Serial
}));
Clear(colAssetNo);Clear(colSerial)
Best regards,
