Skip to main content
Question

Parent record multiple location map?

  • June 28, 2017
  • 0 replies
  • 41 views
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?
    This topic has been closed for replies.

    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.
    • WesWebb
    • Author
    • Registered
    • June 28, 2017
    Ok, let me give that a shot.  And you are correct, I have a report of all children on the parent forms already.
    • WesWebb
    • Author
    • Registered
    • June 28, 2017
    Work order is the parent and pole is the child.

    Child report has a map.
    • WesWebb
    • Author
    • Registered
    • June 28, 2017
    On the child map report why does it only load 100 locations?  I have 2780.
    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
    • WesWebb
    • Author
    • Registered
    • June 28, 2017
    I can't find the form properties for the report link to change it to a map report.
    • WesWebb
    • Author
    • Registered
    • June 28, 2017
    Nevermind.  Found it!!!!  Thanks so much for your help!!!
    • WesWebb
    • Author
    • Registered
    • June 28, 2017
    My map is blank :(
    Does the map report that you pointed to have any filters on it?  It is not supposed to have any filters.
    • WesWebb
    • Author
    • Registered
    • June 28, 2017
    No, I don't think I'm referencing the correct information somehow.
    • WesWebb
    • Author
    • Registered
    • June 28, 2017
    • WesWebb
    • Author
    • Registered
    • June 28, 2017
    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.
    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.
    • WesWebb
    • Author
    • Registered
    • June 28, 2017
    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.
    • WesWebb
    • Author
    • Registered
    • June 28, 2017
    Thats wierd because on other records it shows all of them on the map.
    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.
    Terms & ConditionsAccessibility statement