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.