Quick Base Discussions

Expand all | Collapse all

Parent record multiple location map?

Wes Webb06-28-2017 17:18

Wes Webb06-28-2017 17:25

  • 1.  Parent record multiple location map?

    Posted 06-28-2017 15:39
    I have a Parent and Child table.  Each Child record has the gps location and the google map shows up which is really nice.  Is there anyway to have this function on the Parent record that shows the locations of all child records in one map?


  • 2.  RE: Parent record multiple location map?

    Posted 06-28-2017 16:19
    no problem.  

    Just make a Map Report  on the Child table of all children.

    Then put a Report Link field of your children on your Parent record form (probably for the second time as no doubt you already have the children listed on the Parent form already, but for this second report link field, specify that map report to be used.  That is set on the form properties for the report link field.


  • 3.  RE: Parent record multiple location map?

    Posted 06-28-2017 16:39
    Ok, let me give that a shot.  And you are correct, I have a report of all children on the parent forms already.


  • 4.  RE: Parent record multiple location map?

    Posted 06-28-2017 16:41
    Work order is the parent and pole is the child.

    Child report has a map.


  • 5.  RE: Parent record multiple location map?

    Posted 06-28-2017 16:48
    On the child map report why does it only load 100 locations?  I have 2780.


  • 6.  RE: Parent record multiple location map?

    Posted 06-28-2017 16:55
    I presume that on an individual Parent record, you probably have less than 100 children,s o you are probably OK there.  But you are asking if you try to map all records, there are too many.  That is just a current limitation of QuickBase.  It only lists the first 100 records, but some definition of "first".

    If you need to map more, there are enhanced add-ons like from Juiced Technologies which are not limited to the number of pins and also have other features such as being able to color and label the pins by formula.
    http://www.juicedtech.com/add-ons/qb-maps


  • 7.  RE: Parent record multiple location map?

    Posted 06-28-2017 17:08
    I can't find the form properties for the report link to change it to a map report.


  • 8.  RE: Parent record multiple location map?

    Posted 06-28-2017 17:09
    Nevermind.  Found it!!!!  Thanks so much for your help!!!


  • 9.  RE: Parent record multiple location map?

    Posted 06-28-2017 17:18
    My map is blank :(


  • 10.  RE: Parent record multiple location map?

    Posted 06-28-2017 17:21
    Does the map report that you pointed to have any filters on it?  It is not supposed to have any filters.


  • 11.  RE: Parent record multiple location map?

    Posted 06-28-2017 17:24
    No, I don't think I'm referencing the correct information somehow.


  • 12.  RE: Parent record multiple location map?

    Posted 06-28-2017 17:25


  • 13.  RE: Parent record multiple location map?

    Posted 06-28-2017 17:27
    On report link field options, what field do I choose?  On the "to the values in this field" I chose Pole location: street 1, which is where the gps coordinates are.


  • 14.  RE: Parent record multiple location map?

    Posted 06-28-2017 17:35
    You are over complicating this.  You said that you already have a report link field showing the children on the parent form. Put that same exact same field on the form again.


  • 15.  RE: Parent record multiple location map?

    Posted 06-28-2017 17:48
    Ok, now its working but for some reason it doesn't list ever child location on the map.  For example on one parent record I have 22 children, only 17 show up on the map, but all 22 show up on the other report link field.


  • 16.  RE: Parent record multiple location map?

    Posted 06-28-2017 17:55
    Thats wierd because on other records it shows all of them on the map.


  • 17.  RE: Parent record multiple location map?

    Posted 11-14-2018 23:52
    Hi Wes, did you find a work around to the 100 pole limit? did you contact third party such as Juiced? I'm curious as we are running into similar issue and wondering what ended up working for you. Thanks. 


  • 18.  RE: Parent record multiple location map?

    Posted 06-28-2017 17:58
    Some location may not map due to addressing issues.  so, for example, figure out which ones are missing and you will find that there is a problem with the address - Google does not know where it is, so it can't map it.  Them boys at google are pretty smart so odds are it's bad address info.  GIGO.