Selected group/cluster to view on map view

3X_9_4_94b9094196eb75b5691cebd201395d6f825ba67c.png

how to view selected group of pins/ cluster on Map View (sample: Map1 โ€œconsist of 100 pinsโ€ ,Map 2 โ€œconsist of 77โ€ so on and so onโ€ฆ,) if I selected specific Group/Cluster Pin on map it will only appear the selected. Sample Mapper 1 โ€œconsist of 100 pinsโ€ then it will only appear the selected. Thanks in advance for the answer.

0 14 673
  • UX
14 REPLIES 14

3X_8_7_878b51eb13906ddfce3845b600903bee9be88c49.png

Is there anyone could help me about viewing selected Group of Pins on Maps?

How can I view the selected Route/Scheduled Map (Pin on Map) when I selected โ€œMapper 1โ€ that consist of 89 pins on map and it will only shows what Iโ€™ve selected, not the whole thousand pins? Thank you in advance Sir.

It may not be exactly in one step but in two steps it could be possible to display pins of the selected mapper only.

It sounds that you have grouped the table by a field called something as [Mapper] that has values MAPPER 1, MAPPER 2, โ€ฆMAPPER10โ€ฆ and so on.

If so,

  1. Please add another group by column "_ROWNUMBER "below mapper field in the table view
  2. please create an action called say โ€œSelectPinsโ€ with an expression something like

LINKTOFILTEREDVIEW(โ€œYour Map View Nameโ€, [Mapper]=[_THISROW].[Mapper])

  1. Please set this action as Row Selected action in the table view โ€œRouteโ€ that you have shown.

Now when you tap on a Mapper in the table view it will take you to another summary view of the selected mapper. If you tap on any row again, you will see the map wiew with pins for that selected mapper only.

Edit: Added link to the relevant help article.

Please see the attached file for your reference.
SAMPLE DATA.pdf (74.3 KB)
Note: Please change the file extension name to โ€œxlsxโ€ i-change it so that I can attached the file.

Here is the view of โ€œRouteโ€ that I needed to view on maps with pins when I select (sample)Mapper1 then will only show the selected route with pins on map of Mapper1 only.
3X_0_6_06f67c9a3cc19e5aa4311c0db608235f2153af80.png
Maybe the reason why I canโ€™t follow your procedure is because I donโ€™t know where to input it. Sorry Iโ€™m newbie here in appsheets, Iโ€™m 1month learning the app when I have free time after my work. I hope you can guide where do I put step by step. Thank you [Suvrutt_Gurjar]

I tried but it doesnโ€™t work Sir.

Does it works on you Sir? Can you send a short video so that I can follow and understand of how I can view the map specific of what I selected. Thank you.

Yes, I shared the approach in detail after I tested it on a sample app. Of course my understanding of your requirement could be erroneous.

Could you please share what have you tried with relevant screenshots.

@Suvrutt_Gurjar This sounds like something I could definitely use. I have a similar need, and would like to be able to generate a map based on locations I select in a table view.

I set up the action like you described here, but I can only navigate to one pin at a time. I was hoping that my action would show up in the top right โ€œthree dotโ€ menu, or that when I multi-select from the table, that the action you described would take me to a view of what I selected, but it doesnโ€™t seem to be workingโ€ฆ

My table of items is called โ€œRealm,โ€ and the โ€œAsset Numbersโ€ are the locations.

(The โ€œasset numbersโ€ arenโ€™t visible in this video clip, but I would assume the idea is the same with or without them in this example.)

Do you know what I am missing?
Thanks.

[Loom | Free Screen & Video Recording Software]

From the video you have shared, the number of pins in each group seems to be in the thousands. In such a case the approach described above ( LINKTOFILTREDVIEW() ) may not be useful to you. Also if you are trying to bulk select with the LINKTOFITREDVIEW() navigation action, then I believe it will not work. Bulk select will work on each of the selected row with a row level action

Anyway, incidentally today only @Fabian has posted bulk select and navigate option tip. I think it is applicable to your use case as well. Please take a look at it.

Thank you for the reply. That makes sense. At least I got part of the idea right, even though it wonโ€™t work for me. I definitely have thousands of rowsโ€ฆ

Iโ€™m wondering how, if it is possible at all, one can generate a map view โ€œon the flyโ€ or based on user selections when the data source is largerโ€ฆ

I may have to wait for that, or perhaps Iโ€™m missing something.

Thanks again. I did see that post you mentioned, and I added my vote to the โ€œbulk select map viewโ€ feature request, which I think would be fantastic.

You are welcome. Any specific reason you think @Fabian 's approach will not work for you?

I think this is possible. One implementation is below through the interactive dashboard sample app. Map pins based on a country are selected.

https://www.appsheet.com/templates/An-example-of-an-interactive-dashboard-using-a-map?appGuidString=...

The below sample app selects the records for the โ€œChartโ€ view. But you could select records ( or pins) that you wish to appear in the map view through the same principle of user selection.

https://www.appsheet.com/templates/Allow-the-user-to-filter-a-view-based-on-a-form?appGuidString=912...

Those are great examples, thanks. I will take a closer look. It would seem like those principles would apply to getting a custom map view also.

Hi @Ryan_Wagner this may be a possible way for you.

You have to first mark the rows you want to show in the map view. Then you can navigate to the filtered map view.

3X_2_3_231592f9846034c72506d5a7e5373306f2d90e2d.gif

I saw you other post where you shared this technique. It is awesome. I will have to give that a try. Iโ€™m wondering if I can leverage one of my existing columns to use as a โ€œselectedโ€ column instead of making a new oneโ€ฆ

Thanks!

One more follow-up question, @Fabianโ€ฆ

If you donโ€™t mind sharing, what expression are you using to get to that filtered map?

LINKTOFILTEREDVIEW("Map_View",[Select]=TRUE)

After navigating to the map view you should somehow erase all [Select] columns.
This is not possible as a Grouped Action, because a Grouped Action stops with a navigation action. You cannot Navigate + Set a value in a Grouped Action.
So you could do it with a Bot. But Bots run on the Server, not on the device. So it will take some seconds until the erase reaches the device.

For sure you could use 2 columns: [Select] and [Select_2]. With the Select action you set both columns to TRUE. Then with a Grouped Action you erase the [Select] column and navigate to LINKTOFILTEREDVIEW("Map_View",[Select_2]=TRUE)
But the problem is: A Grouped Action cannot be set to display overlay.

I didnโ€™t find a solution for that.

Top Labels in this Space