Appsheet Tutorial - Counting Items using Barcode scanner
with some tricks using GSheets formula, we can count item based on how many we scanning the items,
Formula for counting items in Sheet Scanned Items
=UNIQUE(SCANNING!B2:D1000) in A2
and
=IF(A2="","",SUMIFS(SCANNING!E:E,SCANNING!C:C,B2,SCANNING!B:B,A2)) in D:D
if you don't need to add the items, you can delete the ITEMS Sheet and delete the formula in valid if in column barcode also delete column item_name
20 сен 2024