topic Re: How to click on a related table in the table widget and zoom to area in map in ArcGIS Experience Builder Questions

How to click on a related table in the table widget and zoom to area in map

elpinguino — Sat, 19 Jun 2021 01:02:13 GMT

Hi EB community,

I have a map and a table widget in my Experience Builder. The table has the same layers as the map. In the table there are spatial features and tables that relate to the spatial features. There are GlobalIDs and GUIDs that connect them. When I click on a row in the table of a spatial feature, I can get the map to zoom to that feature. I've set this up in action/triggers. When I click on a row in the table of a related feature (non-spatial like owner details), I can't figure out how to get it to zoom to the parcel the owner details relates to.

Is anyone able to help troubleshoot me here?

Re: How to click on a related table in the table widget and zoom to area in map

maymiennam — Sat, 19 Jun 2021 01:23:55 GMT

I'm also waiting for an answer

Re: How to click on a related table in the table widget and zoom to area in map

JonathanMcDougall — Sat, 19 Jun 2021 16:20:09 GMT

@elpinguino

Always wondered this one too, as a relationship table selected item will, through action, filter and flash on the map - it just doesn't trigger a zoom or pan to that location.

Re: How to click on a related table in the table widget and zoom to area in map

elpinguino — Sun, 20 Jun 2021 02:18:39 GMT

Hi @JonathanMcDougall , thanks for your reply. I can't get the flash action to work on my related tables. Could you post some screenshots or a video of how you did it?

The steps I took are table widget>action>add a trigger> select map> Trigger data = related table, Action data = polygon in the web map. Conditions GUID and GlobalID.

Are there the steps you took?

Again, all triggers/actions for spatial data works fine. It's the related table data trigger the map that isn't working for me.

Re: How to click on a related table in the table widget and zoom to area in map

JonathanMcDougall — Sun, 20 Jun 2021 07:45:22 GMT

@elpinguino

Will do.

Re: How to click on a related table in the table widget and zoom to area in map

BrittanyBurson — Fri, 25 Jun 2021 17:33:29 GMT

Hi @elpinguino I have been trying to do something similar. I couldn't find a way to do this, so I created an Idea, if you want to help vote it up.

I'd like to be able to click on a related record and have it zoom to the parent feature, as you suggested. I also want to be able to click on a parent feature and have it automatically select or filter for the related record(s) in the related table. As well as have them filter based on the applied table Search. For now it didn't seem there was a way, but if you find one... please let me know!

Re: How to click on a related table in the table widget and zoom to area in map

elpinguino — Tue, 06 Jul 2021 04:52:38 GMT

Hi Brittany, I saw your idea post. Looks like you got this sorted. Everything except for the click on a related record in the table and then zoom to it on the map. I was only able to get it flash, but that's better than nothing for me.

Re: How to click on a related table in the table widget and zoom to area in map

JonathanMcDougall — Tue, 06 Jul 2021 08:10:56 GMT

@elpinguino @BrittanyBurson

Hi both - " I also want to be able to click on a parent feature and have it automatically select or filter for the related record(s) in the related table" - this is possible if you don't use a table, using Feature Info pointed to the related table it works. It will also be filtered down by the current map extent.

The other two, yeah, given you click on a related record in the widget that's been setup to relate ParentID and GlobalID, how it can't zoom to.

I've tried to avoid tables, I find them clunky and, after all, who is going to use a table to scroll through lots of table records? I don't find it the best user experience. I put the table into the widget controller allowing the user the chance to have filters set and extract data.

We've a gully inspection dataset with 20k+ features and each one gets inspected once or twice a year - imagine wading through that table.

I try to think of the user flow - so, use the map to navigate or search, some filters, then go through the selections.

The screenshot is of an exp that's embedded in a Roads exp - it shows the gully, you'll see it's showing 2 inspections along with the attachments, I can click the widget controller to view the Parent Feature etc etc.

Then this is the number of inspections held 2020/21

Re: How to click on a related table in the table widget and zoom to area in map

elpinguino — Wed, 07 Jul 2021 22:58:46 GMT

Thanks @JonathanMcDougall . I'm using the table primarily because you can edit in it. Are there other widgets you can edit in in Experience Builder that I've missed? I'm still new to this, so could easily have missed it. Quick googling says there is an Edit widget in the developer version, but I'm not going to jump into that just yet.

Re: How to click on a related table in the table widget and zoom to area in map

BrittanyBurson — Wed, 07 Jul 2021 23:01:32 GMT

@elpinguino Same here, looking to use the Table widget because of the editing capabilities, especially for our workflows we are transitioning from Excel entry. It's really great!

Re: How to click on a related table in the table widget and zoom to area in map

JonathanMcDougall — Wed, 07 Jul 2021 23:10:37 GMT

@elpinguino

Excuse the questions, merely interested.

Just thinking of your edits - is this editing Inspection Records, hence the related table? If so, how do you preserve the validity of the inspection record?
I've used 123 in a dashboard before, this has allowed me to view an inspection record whilst only allowing the edit/update of "staff" fields. Was thinking of putting 123 into ExpB for a test to allow insurance claims to be logged.

Re: How to click on a related table in the table widget and zoom to area in map

elpinguino — Wed, 07 Jul 2021 23:22:10 GMT

Hi @JonathanMcDougall , No problem. I hadn't thought about embedding a dashboard in. I have the EB set up so new details can be filled out through survey widgets. What I like about survey widgets is that it can pass attributes through.

If any of the records need to be updated later, they have to do it in the table.

Re: How to click on a related table in the table widget and zoom to area in map

JonathanMcDougall — Wed, 07 Jul 2021 23:29:25 GMT

@elpinguino

So the dash I had allowed the update of a customer form. In the dash there was a list of issues, this list could be selected and that would call back the survey123 form. This was done by the list having the global id and the embed having the properly formatter survey123 url eg;
https://survey123.arcgis.com/share/xxxxxxxxxxx?mode=edit&globalId={globalid}&version=latest

I've not tried it yet like this in ExpB but I'm sure someone with far more knowledge than I will know if possible.

Re: How to click on a related table in the table widget and zoom to area in map

daansolaire — Wed, 15 Nov 2023 12:53:01 GMT

Hi @JonathanMcDougall, I know that your message is currently already two years old, but I am wondering if you could assist me nonetheless. My company wants to conduct inspections and has created surveys in Survey123 for this purpose. While filling in the survey, photos should be attached and for various questions, it should be possible to attach multiple photos. Therefore, the decision was made to use repeats in the survey. The downside is that the photos end up in related tables as a result. I am currently trying to make it possible to display these photos in Experience Builder. I am attempting to achieve this by using object info. I want to be able to click on a point on the map, and then have the Object Info widget show the corresponding photos from the related table. However, I'm having trouble accomplishing this. It seems that you have achieved this in a previous post. Could you please show me the settings you used for this?