I have a fruit harvesting business that I would like to find existing, or implement software to keep a registry of scanned bin barcodes for each day, per team, and block area of an orchard.
Any given day might have a total of 500 bins picked, 250 from TeamA, 350 from TeamB, 200 from Block 1, and 150 from Block 2 and 3 lets say. Each bin has a bin card with a unique barcode and I have a bluetooth scanner that passes the value as an integer. At the end of the day I want totals from blocks and teams.
Obviously this could easily be done with Excel and macros quite efficiently but Excel won't run with macros on a mobile device (I think I'll want to go to a small format touch screen device). Google sheets and macros could be done easily too but some orchards are out of 3G reception and googles scripts are server side only.
Thanks in advance, as always