Just FYI, and not a question ..... I just did my first production map report with hundreds of pins ( 610 pins to be exact!) on the Dashboard and OMG, you really have to give Quickbase credit for th...
When you say they're all lumped together in a number, are you aware that you can zoom in with the scroll wheel? There is no way to overlay county borders but if you have any useful dynamic filters such as a county field on the record then you can set up a dashboard filter and just look at a single county or two at a time. Does that help?
------------------------------ Mark Shnier (Your Quickbase Coach) mark.shnier@gmail.com ------------------------------
Thanks! I was aware you can zoom in - the problem is, we want to really visualize the state-of-the-state all together. So having the numbers lumped like that is not terribly helpful given that the pins are intended to be color-coded and a very easy visualization of where there are areas without services.
The county filter is a great idea, though! We've further set it up into sections of the state, so we coudl filter out that way.
Is there a way to superimpose one map on another? It would be amazing to superimpose one map showing whether Service A exists, over top of another map that shows whether Service B exists. I realize I can suss out some of that by simply having Services A & B available on one field, but in this instance, I cannot. One measures a broad community-level program, while the other measures specifics at hospitals, so it wouldn't make sense to have them in one field/nor do I think we could really capture it. But I may think on that a touch more.
You may have a situation where you're trying to plot 2 sets of data and they are in different tables. I have that situation with a client where every job has a pick up and delivery and I need there for two pins.
So what I did is I created a button where a scratch pad type table is purged and then records are copied in from the source tables to create the pins. Then it redirects the user to a map where record the owner is the current user. So the map is actually a plot of this kind of scratchpad table, and it only shows records for the current user.
------------------------------ Mark Shnier (Your Quickbase Coach) mark.shnier@gmail.com ------------------------------
Okay all interesting points. So a little about what I'm trying to achieve. I do have two different data points, and I ultimately made a bunch of rules to throw the color code based on that. The two data points are A) Status of hospitals in a county (do they have hospitals? No hospitals? Do they have access to our specialty service?); and then B) Are there community committees focused around our field (sexual assault response)? So I created two additional fields.... one that summarizes the situation of the status of hospitals within the county; and then the next field summarizes the hospitals along with the existence or non-existence of county committees. The result is a color-coded grid with 10 different options, which differentiates between:
* Counties that have or don't have hospitals * Have or don't have access to sexual assault care in those hospitals * Have or don't have a community action committee
What we have now is a color-coded map that just represents pins that are aligned with each county's seat. But there are 62 counties in NYS, and still this is a little problematic that it lumps these in to #'s. I'd really like to view all of NYS at once if possible.
Qrew Legend
