nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

elpinguino

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?

Find more posts tagged with

Accepted answers

All comments

daansolaire

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?

JonathanMcDougall

@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/xyz?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.

elpinguino

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.

JonathanMcDougall

@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.

BrittanyBurson

@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!

elpinguino

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.

JonathanMcDougall

@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

elpinguino

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.

BrittanyBurson

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!

JonathanMcDougall

@elpinguino

Will do.

elpinguino

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.

JonathanMcDougall

@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.

maymiennam

I'm also waiting for an answer

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.