Hi everyone,
I am trying to create a Barcode Reader App which allows Multiple scans at the same time; however, I want to prevent duplicate scan from occurring.
Issue 1: Prevent Duplicate Barcode being captured during scanning (Multi Scan Mode)
Collection = MultiBarcode
Insert a Gallery (Select Title Only)
DataSource = MultiBarcode
Gallery Title Text = ThisItem.Value
Insert a Barcode Reader
OnScan = If(CountRows(Filter(MultiBarcode,Value=BarcodeReader1.Barcodes))>0,Notify("Duplicate"),
Collect(MultiBarcode,BarcodeReader1.Barcodes))
I am getting an incompatible comparison error for the OnScan code above.
Issue 2: Multiple Font Color in Gallery Subtitle
I created a gallery to showcase and calculate data in a Sharepoint List.
For the gallery subtitle (AVAILABLE...........................), I want to change the font color of Available to Green & Total Cylinders to Red.
Below is the current code for the subtitle:
"AVAILABLE: " & CountIf(
'Barcode List',
Gastype = ThisItem.Value && OnLoan = "Yes"
) & " Unit ; Total Cylinders: " & CountIf(
'Barcode List',
Gastype = ThisItem.Value && TotalAvail = "1"
)
