Yes that is possible if you have a browser on the phone that can access QuickBase and you don't need any special services including connected tables . Quite frankly the more "services" and external components you add to QuickBase the more complicated you are making the solution. Just do everything in script.
This demo locates the ten closest
White Castle stores to the searcher's present location (your problem is very similar technically):
White Castle ~ Cravers & Slidershttps://haversineconsulting.quickbase.com/db/bi5963543 Just add a
new Search and permit your location to be shared, save the record and a list of the ten closest (as the crow flies)
White Castle emporiums will be displayed:
White Castle ~ Cravers & Sliders ~ New Search
https://haversineconsulting.quickbase.com/db/bkkxm2a9w?a=nwr Pastie Databasehttps://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=485 I created this app so that no matter where I am after hard day of
QuickBasing I can find my nearest
White Castle.
Notes (1) There are
no approximations involved in the distance calculations. The trig functions are calculated Client-Side using JavaScript because QuickBase does
not have trig functions in their formula language. The essential formula for these calculations is the
Haversine function which calculates the great circle distance between two points specified by latitude and longitude (yes that is what my business is named after
Haversine - a exotic trig function). Here is a technical reference with code I used.
Calculate distance, bearing and more between Latitude/Longitude pointshttp://www.movable-type.co.uk/scripts/latlong.html (2) I took a lot of shortcuts and packaged the demo in this fashion specifically to not involve any external services and for other reasons related to being able to maintain a working demo over time. A production implementation would probably have other requirements that could easily be accommodated.
(3) Great
Longitude movie:
Longitude FULL MOV_E 2000 UK
https://www.youtube.com/watch?v=LHvt48S9l4w
