Finding the closest major metro to a city
Some similar questions have been asked but I can't find exactly what I'm after. Here's the problem: I have a list of sites in one table called 'Sites'. In another table I have a list of 50 '...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI recognize that distance formula. It's mine from this old post from 2014 here.
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MID=30357&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer
I watched Kirk's video and it only works for one Home Record at a time. It does not work for a set of sites.
I believe what you will need to do is to create an Automation to copy in all 50 Major cities as child records to each site. In fact they could be a join table between Sites and Major cities.
Then lookup the geocode of the Site down to that child join table and do you Pythagoras math on the children.
Then you can make a summary of the minimum distance and if you like you can also float up the combined text of the city name where the minimum distance is the distance of that city.
Post back if you get stuck on how to create all those children records, but you can get the concept working to prove it will work by copying across the 50 cities to one representative site.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MID=30357&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer
I watched Kirk's video and it only works for one Home Record at a time. It does not work for a set of sites.
I believe what you will need to do is to create an Automation to copy in all 50 Major cities as child records to each site. In fact they could be a join table between Sites and Major cities.
Then lookup the geocode of the Site down to that child join table and do you Pythagoras math on the children.
Then you can make a summary of the minimum distance and if you like you can also float up the combined text of the city name where the minimum distance is the distance of that city.
Post back if you get stuck on how to create all those children records, but you can get the concept working to prove it will work by copying across the 50 cities to one representative site.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
