Find the nearest Starbucks using QuickBase
Last week Howard popped into an "Office Hours" webinar asking about how to find the closest customers to a given Latitude and Longitude location. Well you can do that with QuickBase. I went lookin...
Forum Discussion
Hi Kirk,
I'm a user of your Magic Buttons app and have gained a great deal of insight from a lot of its functionality. However, it seems as though the coding for getting latitude and longitude does not work. I'm curious if you have an updated working version you could share. Or could you point me to where I could find a working model.
Thanks
------------------------------
Barry Dolan
------------------------------
Hi Barry,
Are you wanting to know how to get the Lat and Long for a given address? You can't do it directly in quickbase, you'll need to use an outside service like google or geocodi.io and a pipeline to geocode, but it's pretty simple to set up.
------------------------------
Jeff Peterson
------------------------------
I am wanting to get the lat/long for the current location.
When a user taps a button on the qb mobile app it will capture the current time and update a form field. I have this much set up and working. But what I also need is to capture the location of that user when the button is tapped.
This is functionality we're programming to replace our time clock so employees can clock in/out on the mobile app. But we need to be able to determine where they clocked in from.
I saw an older post with a similar question, regarding government mandates for that person's needs, but there wasn't any response to the post.
I'm getting more familar with API's in pipelines, so I'd be interested in learning more of what you suggest.
Thank you,
------------------------------
Barry Dolan
------------------------------Getting the current location will require some coding outside of native Quickbase. Your process would likely need to use a code page where the user clicks a button and navigates them to said codepage where you have some javascript that logs the date/time and their information. In that code you would have to use your browser or devices geolocation API or service to get the current position and then log it.
In this situation you can't use Pipelines because its independent of the user at that point, and unfortunately Quickbase doesn't have any native services specific to geolocation.
------------------------------
Chayce Duncan
------------------------------I'm familiar with the method you outline. Kirk had his URL formula call a code page, which isn't working.
I use a code page that I found on the Magic Buttons app to capture the current time.
I also found code page that I can call from a button to open a popup window and then get the current lat/long. (attached), but I don't know how to get what I need from it. It works, but not on a mobile.
------------------------------
Barry Dolan
------------------------------
