Showing distance between hotels and nearby attractions

[Ata_Farzamnia]

Hi,

I have a base including 900 hotels in different cities.
I have another base including 1200 attractions in different cities.
On the website frontend I’d like to show nearby attractions and distance to the specific hotel.

I don’t have any issues with calculating the distance between 2 locations. I was wondering how I can show only attractions in the same city for a hotel.

Thanks for your help.
Ata

[kuovonne]

Welcome to the Airtable community!

Can you put both the hotels and the attractions in the same base, and then link them together using a linked record field?

Also, what are you using to build your website front end?