Show distance away from current location and mark as completed

[EHong]

My app starts with a card view of my customer list so the users can figure out which locations to visit next. Is there a way to display the “distance away” from the current location for each customer’s listing? That way the user can pick the next closest location to visit for maximum route planning efficiency. My Google Sheets data has the column header Current Location with data Lat Long HERE().

Also, the second question I have is, is there a way to show a check mark or highlight on a customer listing on the start page if that customer has been visited by my user already? This way they don’t visit the same location twice by accident?

Thank you so much.

[WillowMobileSys]

EHong:

Is there a way to display the “distance away” from the current location

Unfortunately, AppSheet doesn’t yet have the pieces to support your needs (hopefully coming soon now that the merger has settled)

I have heard of developers integrating with Google’s mapping service to get the driving distances. I believe that is free up to certain volume of calls. So with a little extra effort, you can get something useable that way.

[Marc_Dillon]

WillowMobileSystems:

EHong:

Is there a way to display the “distance away” from the current location

Unfortunately, AppSheet doesn’t yet have the pieces to support your needs (hopefully coming soon now that the merger has settled)

Can’t you put DISTANCE( HERE() , [there] ) in a virtual column?

EHong:

Also, the second question I have is, is there a way to show a check mark or highlight on a customer listing on the start page if that customer has been visited by my user already? This way they don’t visit the same location twice by accident?

You can use a format rule for this.

help.appsheet.com

Format Rules: The Essentials

Learn how to change the way information is displayed throughout your app.

[Steve]

Marc_Dillon:

WillowMobileSystems:

EHong:

Is there a way to display the “distance away” from the current location

Unfortunately, AppSheet doesn’t yet have the pieces to support your needs (hopefully coming soon now that the merger has settled)

Can’t you put DISTANCE( HERE() , [there] ) in a virtual column?

To clarify:

• Yes, you could use DISTANCE(HERE() , [there]) in a virtual column, but this provides only the straight-line distance (“as the crow flies”), which may or may not be an accurate indicator of driving distance or driving time.

• True, AppSheet does not have the pieces built-in to provide accurate driving distance or driving time.

[WillowMobileSys]

Marc_Dillon:

Can’t you put DISTANCE( HERE() , [there] ) in a virtual column?

Yes, and I almost blurbed about it. There are two issues with the DISTANCE() function. The first is as @Steve commented. It is only straight line distance. Probably not helpful in this use case.

The second, more problematic issue is that the function requires two coordinates. HERE() is easy enough to get. But the [there] is not. Since apps typically store only addresses, a developer is still stuck with obtaining the coordinates to that address - something AppSheet doesn’t yet do. Again, third party services can help.

[Marc_Dillon]

Ahh, yes, I understand, thanks.