Latest Contributions by XanderBakker

Hi ANDREW BUTTERFIELD , It seems that there is something strange going on in your data. I was expecting to find a relationship from the organizations info to the venue locations, but I only found one relationship towards Form_2. And when I try to use it, it returned an empty string as the relationship name: Earlier you mentioned that the link between the two layers is established using the organization name, so I used that instead. have a look at the expression below: // use organization name and venue name to link the information var orgname = $feature["org_name"]; // access the venue featureset var fsvenues = FeatureSetByName($map,"Venue Locations", ["org_venue", "org_venue_address", "org_venue_type"], False); // create a SQL query to get the related venues var sql = "org_name = @orgname"; // filter venues on org name / venue location var venues = Filter(fsvenues, sql); // count venues var cnt = Count(venues); // loop through venues and create result var result = ""; if (cnt > 0) { // there are venues found, loop through venues result = cnt + " venues found:" for (var venue in venues) { // add venue information to the result result += TextFormatting.NewLine + TextFormatting.NewLine + venue["org_venue"]; result += TextFormatting.NewLine + venue["org_venue_type"]; result += TextFormatting.NewLine + venue["org_venue_address"]; } } else { // no venues found result = "no venues found..."; } return result; ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ The result will show like this: Is this what you are after? ... View more