I am very new to AppSheet but I see great potential. I want to design a barcode scanner, very simple stuff in theory:)
The Datacolumns in my googlesheet are: Barcode, Location, date of last check, date of future check
I got three questions:
a) After a barcode was scanned i would like to see the information of my GoogleSheet (Location, date of last check & date of future check) In Excel i would use the vlookup based on the scanned barcode.
b) based on the GPS coordinates i would like to filter my location list, e.g. GPS in the states, show only American Cities.
c) I would like to have the date of future check calculated based on the date of last check. Should be today plus 2 years as default but also editable.
Thanks for your help.