Forum Discussion
ArchiveUser
8 years agoQrew Captain
First, I would say that you would need a 3rd Table that would hold the connected records between Table 1 and Table 2. The 3rd Table will allow you to have connections to records in Table 1 from Table 2.
Second, Quick Base doesn't have anything built in that will determine the distance between 2 points. To do this, you will need some type of script that would do a comparison of all records in Table 1 to those in Table 2, determine the distance between them, and then create a record in Table 3 if the distance meets your specified criteria. You may be able to build something like this using Zapier or Workato, but I've never attempted distance calculations in either of them.
Second, Quick Base doesn't have anything built in that will determine the distance between 2 points. To do this, you will need some type of script that would do a comparison of all records in Table 1 to those in Table 2, determine the distance between them, and then create a record in Table 3 if the distance meets your specified criteria. You may be able to build something like this using Zapier or Workato, but I've never attempted distance calculations in either of them.
- MichaelBarrow8 years agoQrew CadetActually, if you have the latitude and longitude points stored for each of the two locations (we use a Zipcode table to bring in those lookup fields), you can use a formula. Not sure if QuickBase has all of the trig functions necessary to do this calculation (I haven't actually implemented this yet in QB), but I have had it working in our legacy app in MS Access for the past 20 years. See this article for guidance: https://stackoverflow.com/questions/27928/calculate-distance-between-two-latitude-longitude-points-haversine-formula
- ArchiveUser8 years agoQrew CaptainQuick Base does not have the necessary math functions to perform this action within a formula field. Haversine Formula calculations would have to be done by a script with the results populated back to Quick Base.