Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

Is it possible to combine a Calendar Report and a Google Maps API integration to figure out routing/scheduling for our service employees?

Here's an overview of our situation: we have a handful of employees that go out and perform a specific type of service call, and there are 3 possible timeslots for those service calls per day. Whe...
APIs and custom code
App builders
Ask about Quickbase functionality
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
8 years ago
I read the complete title and scanned the body of your message. It is possible but I think you are looking at a custom solution to hit all of your requirements many of which I don't think you have surfaced in your message but are there nevertheless.

I created a demo of using the Distance Matrix API which I am trying to locate.

Here is one fragment message (it was altered during the forum software update) that deals with a similar issue

https://community.quickbase.com/quickbase/topics/map-route-planning-for-field-technicians
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    8 years ago
    well, good to know that it's at least something that looks workable. Full disclosure: I'm fairly new to QuickBase (haven't built anything up from scratch yet) but have an okay programming background and have spent the last week or so going through every bit of the QB University content from the beginning through the "Api Bootcamp" part of the Advanced videos. definitely agree that there are probably lots of things encapsulated in this idea that I haven't explicitly come out and defined, but I'd like to help out as much as I can with the development.

    the other thing that's weighing on me is that given our project integrates with the calendar view, with the upcoming rollout of the new calendar in a couple weeks, it might not even be worth starting this until we can see how it would look and what parts of our existing scheduling process break :\
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    8 years ago
    Well I am the resident cynic here but I do think the new calendar it going to be a big improvement and well received. The customization you need will probably be on the map side of things especially if you want some type of dynamic route planning or optimization. There are enormous possibilities here that are largely unexplored. 

    I can't wait till I get my hot little hands on that new calendar thingy so I can script it up! QuickBase has assigned their best developers to this project and they have been working at top speed. They could not possibly have had adequate time to think of all the ways I am going to enhance it with script .

    BOOM