Is there any way to have a google map on the QB homepage that I can ""click"" on and pull up co-ordinates to create a new client & Job site? also have the map display jobs?

Question

Im building QB app for our plumbing company. We make use of google maps extensively for mapping and finding addresses. In South Africa, our addressing system does not always point us to the customers house, we therefore use Lat&Long co-ordinates to get our techs from 1 site to the next. Is there any way that we can incorporate a google maps widget in the home screen with the ability to "click" and action a new client address and Job.

I know QB already has built in functions to show various jobs (with their status) already, however this relies on the native google maps search engine to pull address location which is not accurate for us. Some assistance will be appreciated

quickbasecoachd · Answer

I'm not sure if this will help but here is a tip when you want to store a Customer "Address" in the form of lat and long as opposed to a normal street address.

"Another feature that you can do natively without coding, is to put the latitude in the Street 1 field and the longitude in the Street 2 field. This will populate the location on the Google Map.

Ensure no other data entered and Save"

https://quickbase-community.intuit.com/questions/1333933-i-have-latitude-and-longitude-coordinates-as-decimals-43-72007-71-0363-and-i-would-like-to-display-this-location-on-a-google-map-on-a-quickbase-form#

geoffreyharmuth · Answer

That actually works very well. So what I have done is:
1) Put the address details in a multi text box and
2) then put the "location" details in GPS format in line 1&2 as you said.

Is there any way to incorporate a "clickable" google maps layer within QB?

quickbasecoachd · Answer

I don't know how to do that :).&nbsp;&nbsp;I did my Reply as a Comment, so maybe some other brainiac will see this post and respond.

geoffreyharmuth · Answer

Thanks so much for the quick assistance.&nbsp;&nbsp;hope someone can shed some light

_anomdiebolt_ · Answer

This script will obtain the lat and lon from a click on the map:google.maps.event.addListener(map, "click", function (e) {&nbsp;&nbsp;&nbsp;&nbsp;var latLng = e.latLng;});

Forum Discussion

Is there any way to have a google map on the QB homepage that I can ""click"" on and pull up co-ordinates to create a new client & Job site? also have the map display jobs?

Related Content

Utilizing a different form when clicking the "Add Record" button

2021 New Style Beta Report - cannot click on a record to "View" must click on the "eye" icon

Open Print dialog when clicking "print exact form" button

"Save and next" clicks in the reverse direction of my list

Field that displays a paperclip icon that when clicked displays the ""embedded attachments"" report