Hi There
Iโm designing an app that allows me to gather metrics and performance indicators on the staff Iโm responsible for mentoring and have to manually edit several spreadsheet lists and answer several questions to gather the reporting I need.
Using AppSheet, Iโd like the ability for it to detect my current location (i.e. when I perform a site visit) then:
- Check that information against a list of addresses Iโve saved in a spreadsheet with relevant site/worker information.
- Pick the one closest to my current position.
- Auto open and fill certain fields of a form (i.e. Site Name, Staff Name).
Iโd like the app to do this each time I open it, but would like to ability to manually set the location in-case Iโm performing a โsite visitโ virtually over the phone.
Iโve already achieved somewhat of a working app, with data being pulled from a Read Only Table (i.e. site and worker information), and having it auto complete some form fields using a de-reference, before writing that to a worksheet holding all the reports within Google Sheets - nothing using GPS data however.
I figured Iโd use something else down the line to separate the reports I make to view them by Worker or by Site, but I am not sure how.
Any help appreciated.
LinkedIn
Twitter
