Kelly, I'd really rather not create additional fields with each sampling. I'd like to be able to simply fill out a form for each sampling site/event and have it populate a table like this:
| Site | Date | Nitrogen (mg/L) | Phosphorous (mg/L) |
|---|
| 1T | 1/1/18 | 0.2 | 0.1 |
| 2T | 1/1/18 | 0.4 | 0.35 |
| 1T | 2/1/18 | 0.15 | 0.4 |
| 2T | 2/1/18 | 0.3 | 0.7 |
| 1T | 3/1/18 | 0.6 | 1.0 |
| 2T | 3/1/18 | 1.1 | 1.5 |
The map would have a single point for 1T and for 2T. Upon clicking, a pop-up would show something like the above table or perhaps even a chart of change over time.
My ideal is to manage data in a Google Spreadsheet, then have the sampling events at least listed (and perhaps charted or statistically summarized) in a single pop-up (rather than clicking through the pop-up windows for each event/feature).
One point, one pop-up compiling multiple features with a common site name.
Let me know if there are any other questions. I feel like this must exist somewhere somehow and I'm missing it.
I thought of another way to say it after playing with clustering, which I figured might be a pathway to a solution but does not appear to be (yet). Let's say this was achievable through clustering. When clicking on a cluster point that might have clustered three points, I want the pop-up to list out (ideally in a table and/or chart, but I'm open to other options) all the fields for all the features (same Site, multiple sampling events). I might also want summary info (e.g., average), too, but we'll really want to see how data changes over time.
