Search records by distance from a specified location

App Development
1

I have an application where I need to search for records based on the distance from a specified location. The setup looks like this.

  • Customer logs in
  • Once customer is logged in, customer can search by supplier trade, location (zip code, city, or state), and max distance from the specified location
  • Search populates a map with all suppliers within allowed max radius from the specified location, as well as suppliers that meet the additional search criteria
  • Search also returns a table with the relevant companies, addresses, and trades
  • Customer can click on supplier and pull up Profile for more data

There’s the Tadabase map component, but it lacks any search compatibility or function.

I also tried setting up a table to run the Google Maps directions pipe to get distance from the logged in users address to the suppliers address. This approach is missing the map, and I can’t use the pipe value for any data processing/interaction. See video below for a demo of that approach.

https://www.loom.com/share/fbd9a60db4574cae8bfb0020fe239edd?sharedAppSource=personal_library

If anybody has any ideas, I’m all ears. Shooting for the moon here!

2

Hi Tim,
I see it hard, it is a problem that I also have with the maps.
I believe the only solution is to use the tasks and rules to select and write in fields compatible with maps.

3

Hi @tim.young
did you go ahead with this project, did you find the solution?

4

Hello @DanioA

No, unfortunately there’s no solution right now.

6

I need this too :frowning:

7

i know this is an old post but its something we could do with, we moved from knack to tadabase but still pay knack just for this one little feature, it would be nice to drop knack completely and save paying 2 providers. Any update? thanks

8

its basically a store finder feature would be so helpful