7
Hello,
Please help me i have totally no idea about below things...
I want to make collection updated column by column
ex) Collect column A * 20 times -> collect column B * 20 time n the same order as column A
more information, please see picture below.
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:
Share
Report
All responses (
Answers (
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,
Thank you for help me..
I want to make Asset barcode scanning tool.
Each asset has Two barcodes on 1 box (Asset Number, Serial Number)
but when asset income big quantity(ex. 1,000EA), it's more easy to scanning barcode by vertical. as below picture.
I failed to coding to Collect by row(Column1 -> Column2 = Collect -> Next Row) but i don't have any solution for collecting by Column1 -> Column2.
Thank you so much 🙂
Hi @Hachung ,
Could you please share more details about your scenario? I still don't know the specific meaning of your description. You can provide a pre-post example of the collection so that we can understand it correctly.
Best regards,
