Skip to main content
Question

Google Distance Matrix API

  • April 20, 2017
  • 0 replies
  • 157 views
Forum|alt.badge.img+6
I would like to see if there is a way for me to create an API that will call into Google Distance Matrix API and return the distance a worker's home is from the job site. I was able test the API in Postman but I am having a hard time adding it to Quickbase. Not sure if I should do this with a formula URL field or a webhook
      This topic has been closed for replies.

      • MCFNeil
      • Quickbase Alumni
      • April 20, 2017
      Generally this requires custom coding depending on your exact needs.  

      Are you looking to just have a button that pulls up the map w/ directions?   (this is an easy button, that I can share if needed)

      Or something that is automatic when a worker is assigned to a job site?  (This is much more advanced)
      Forum|alt.badge.img+6
      • AlinMihalcea1
      • Author
      • Quickbase Alumni
      • April 20, 2017
      Matthew,
      Thanks for your resoonse!
      I am looking for something that will go to google and get the distance when a worker is assigned to the job. Can you give me some pointers?
      • MCFNeil
      • Quickbase Alumni
      • April 20, 2017
      Directions Button,

      This is formula URL button:

      "https://www.google.com/maps/dir/"&URLEncode([Resource - Home Address])
      &"/"&URLEncode([Project Location])

      This is just a URL Button that will go to google maps.  Both of those field are full address fields being referenced.
      Forum|alt.badge.img+6
      • AlinMihalcea1
      • Author
      • Quickbase Alumni
      • April 20, 2017
      Thank you!
      Any way I could get you to point me in the right direction for the automated way?
      Can I use a webhook to get the information and then post it somehow on to a field?
      Again, thanks for taking the time to help me!!
      Terms & ConditionsAccessibility statement