Related table in Experience Builder not preserving 1-Many relationship?

685
3
Jump to solution
09-22-2023 07:21 AM
Labels (1)
Alicia_Ritzenthaler
New Contributor

Using Experience Builder I have created an experience that has both a map and table widgets. The relationship between the map features and table records is 1 (feature) to Many (records).

I have set up actions so that when you select a feature on the table, the related record selects in the table widget and vis versa - when you select a record in the table they related feature is selected on the map.

Unfortunately, when a feature is selected on the map, only the 1st related record selects in the table - not all related records. What can be done to preserve the 1:many relationship so that when a feature is selected on the map ALL related records select in the table? 

Notes: I've already ensured that the select mode of the table is set to 'multiple'. I've also gone into the data settings of each of these layers (i.e. the features and related table) to ensure that the page size exceeds the total number of records.

0 Kudos
1 Solution

Accepted Solutions
Alicia_Ritzenthaler
New Contributor

Yes! ESRI is now supporting this functionality in Experience Builder. 

To set it up I first added both a 'Map' and 'Table' widget to my Experience. Next I added an 'Action' to my map widget and set up a 'Framework' that 'Select Data Records'. I used my map feature (1) as my trigger data and my table (many) as my action data. Now, when I select a feature on my map all of the related records appear in my table. For my experience I also added the reverse 'Action' to my table so that when records are selected from the table they're selected on the map as well.

Hopefully this helps. The Experience I made with this functionality is public - you can find it here. There is contact info at the bottom of the Experience page. Feel free to reach out that way if you want to get into more detail about how I set it up (the email address for the program will come directly to me). 
https://experience.arcgis.com/experience/208f5b99663044be9dd6d30289838ac4 

View solution in original post

3 Replies
MikhaylaB
Frequent Contributor

Did you ever get this figured out? I need the functionality that webapp builder has to show related records when a feature is selected. We also have a one to many relationship in our data.

0 Kudos
Alicia_Ritzenthaler
New Contributor

Yes! ESRI is now supporting this functionality in Experience Builder. 

To set it up I first added both a 'Map' and 'Table' widget to my Experience. Next I added an 'Action' to my map widget and set up a 'Framework' that 'Select Data Records'. I used my map feature (1) as my trigger data and my table (many) as my action data. Now, when I select a feature on my map all of the related records appear in my table. For my experience I also added the reverse 'Action' to my table so that when records are selected from the table they're selected on the map as well.

Hopefully this helps. The Experience I made with this functionality is public - you can find it here. There is contact info at the bottom of the Experience page. Feel free to reach out that way if you want to get into more detail about how I set it up (the email address for the program will come directly to me). 
https://experience.arcgis.com/experience/208f5b99663044be9dd6d30289838ac4 

MikhaylaB
Frequent Contributor

Thank you for the reply! I wondered about adding the trigger in reverse; I may do that as well.

0 Kudos