Search x Geolocation (Airbnb) Retrieve list based on distance to geolocation provided

Hi Community!

I wish to implement an Airbnb style search feature in order to get the list of nearby available locations registered.

  • With a custom form, a user should be able to submit an address where he is looking a place to stay. Ideally with address autocomplete using Google API. ex: Paris
  • Once provided, I should be able to retrieve the address coordinate (latitude-longitude) => I was thinking about using Make or maybe a Script?
  • Based on the address provided, I wish to get the list of nearby places calculating the distance between the provided address and the location address. From the closest to the most distant one.
    This part one is the tricky one. As I cannot see what would be the source of my list block (currently it is Airtable)

Is that even possible?
Would I need to build this feature with another NoCode builder such as Bubble or Weweb?

Thank you very much!

Yes, it is possible using Airtable scripting to call mapping apis to calculate the distance between two locations.

I have done this, but with a limited data-set (I only ever need to know a maximum of 12 distances - freelancers travelling to a work locations). The script is triggered by an automation.

I shared the original script, triggered by a button here. It is easy to change the script being triggered by an Airtable automation.

If you do a wider web search for Google maps and Airtable distance calculations there are other threads.

I can imagine that once you have all the calculations, a Softr table showing X number of results sorted by shortest distance will do want you want for your users.

Wishing you all the best for creating a solution with Airtable and Softr. I think it is very possible.

Hi Mark, Thanks for taking the time.

when you say “a softr table showing X number of results…”

Which source of data are you pointing at?
I don’t see It possible to point an Airtable table: several users can be making research on my app at the same time.

Is there a way to source the json of a script result? The list result will be specific to each user research?

Amaury

when you say “a softr table showing X number of results…”

Which source of data are you pointing at?
I don’t see It possible to point an Airtable table: several users can be making research on my app at the same time.

Yes the Softr table would take its data from Airtable

Is there a way to source the json of a script result? The list result will be specific to each user research?

I don’t know that this would be necessary; but I also don’t know JSON and what you might be thinking of implementing.

All the best with achieving your project goals