Appsheet Tutorial - Counting Items using Barcode scanner

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

[@user-ze2ep7us8e]

di sheet scanned item sudah dikasih rumus unique tapi muncul warning "The spreadsheet row number is being used as a key in the table 'Scanned Items'. It's best to include an 'ID' column in the table." hehe

[@bayubiru25]

Abaikan gpp gan

[@juzammafikri2052]

Kren bang 👍

[@bayubiru25]

Just sharing 😬

[@ayahomecko6663]

Ada panduan tertulis atau versi pdf gak bang, kalo by video tulisanya kecil ada yang gak jelas.

[@user-od7rq6nk8n]

Keren bg, bisa buat multi scan barcod ga bang?

[@bayubiru25]

Multi scan gmn maksudnya gan?

[@user-od7rq6nk8n]

@@bayubiru25 contohnya jadi kita bisa scan terus seblum kita save kayak contoh di bawah ini bang (ttps://kzbin.infoC2a16tPDY8w?si=-v5KHaQPalimiRRp)

[@davidsetiono1617]

bang kalau ada barang yang tidak ada barcode bagaimana ?

[@bayubiru25]

Nanti muncule kosong bang atau bisa dibuat ada notif e kl barang tidak terdaftar

[@davidsetiono1617]

@@bayubiru25 berarti kalau mau pakai barcode, pastikan dulu semua barang ada label barcodenya ya bang ? atau bisa gak, yang gak ada barcode dicari by nama ?

[@bayubiru25]

@davidsetiono1617 Bisa bang, kl barcode yg belum kedaftar nanti langsung di tulis manual nama barange, begitu di scan lg nanti dah otomatis nama barang yg barusan di tulis muncul

[@davidsetiono1617]

@@bayubiru25 bang kalau supaya tau nama user yang input boleh minta formulanya bang ?

[@bayubiru25]

Useremail()

[@user-ze2ep7us8e]

bang itu bisa auto Save ga bang

[@bayubiru25]

Bisa gan

[@user-ze2ep7us8e]

@@bayubiru25 caranya gimana bang jadi setelah scan langsung tersimpan gitu

[@bayubiru25]

Cari pengaturan auto save di form view nya

[@user-ze2ep7us8e]

@@bayubiru25 terimakasih banyak bang

[@Dian_Maddie]

Subscribe 😍

[@bayubiru25]

Thanks

[@Dian_Maddie]

@@bayubiru25 bang, saya mau dibikinin apps inventory. Saya bisa hubungi kmn ?

[@Dian_Maddie]

Kbopmandarin @ Gmeeeeaillll Dot Coooooom

[@bayubiru25]

Check email