Solved: Question: Is it possible to do this? - Page 2

retailpartnerco · 05-17-2020 05:49 AM

Hi! I have a list of store locations in my app. My users often visit these stores and write reports for them. Is it possible in AppSheet to use the user’s current location to find the store that they currently are at (I have an Address column in the table), or is it possible to rank stores based on how close they are to the user (probably not, just want to make sure)?. Thank you!

Steve

Yep, it’s possible, so long as each store has its LatLong location (in column Location, e.g.). The closest store to the user can be found with:

ANY(
  ORDERBY(
    FILTER("Stores", TRUE),
    DISTANCE(HERE(), [Location])
  )
)