Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Distance between cities and states


Mark Johnson

This topic is 5757 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a database that has a table with a list of techs and the contact info for them but also have a seperate table that has a list of all my clients. what i want to do is on the main page of the database that gives me an overview of the client, i have a portal that lists all the techs that are associated with the state that my client is in but i want to be able to have a field calculation that i can do that will show the distance between the location of the tech and the location of the client based on the city and state between each so that i can scroll throught the list and find the techs that are closest to the client and then view the info for the tech and call them instead of having to go to google all the time and type in all the info. One thing though, i dont want the google webpage to be viewed in filemaker, i just want a number in the field and thats it. Is there a way to do it.

Link to comment
Share on other sites

This topic is 5757 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.