topic Re: Arcade, FeatureSets, and Popups in ArcGIS JavaScript Maps SDK Questions

Arcade, FeatureSets, and Popups

AndrewSD — Wed, 16 Sep 2020 20:34:33 GMT

Hello,

I have two layers, Organization and Venue in a web map.

I want to display Venue info in a popup on the Organization layer. I know I can use FeatureSetByName in Arcade, but I don’t have a lot of experience with Arcade.

There are also related records so if you click on an Organization point it could have several venues so I would like to display all that relate to the Organization name (how they are related).

In my head I imagine the popup having all the organization info (name, address, other features) that I have created in the customize popup interface. Then I would have an Arcade Expression that gave me the venue name, address, etc. This expression would show any related venue that an Organization has worked at.

If anyone can give a sample code that would be great. If you need more info I can provide it just not sure what one might need.

Thank you!

Re: Arcade, FeatureSets, and Popups

XanderBakker — Sat, 11 Dec 2021 06:09:43 GMT

Hi ANDREW BUTTERFIELD ,

See below a simple example based on what you described:

// user clicked on organization, so that will be your $feature
// get related venue records, change name of relationship and fields according to your data
var fsvenues = FeatureSetByRelationshipName($feature, "Name of the relationship to access venue", ["name", "address"], False);

// initialize result text and get count
var result = "";
var cnt = Count(fsvenues);

// check count and start creating result text
if (cnt > 0) {
    // we have related records
    result = cnt + " venues found:";
    // loop through venues
    for (var venue in fsvenues) {
        // add a line per venue and include name and address
        result += TextFormatting.NewLine + " - " + venue["name"] + " (" + venue["address"] + ")";
    }
} else {
    // we don't have related record, show that in the result
    result = "No venues found";
}

return result;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Arcade, FeatureSets, and Popups

AndrewSD — Thu, 17 Sep 2020 13:38:45 GMT

Wow! Thank you very much! I will test this out and see how it works. Much appreciated!

Re: Arcade, FeatureSets, and Popups

XanderBakker — Thu, 17 Sep 2020 13:55:11 GMT

Hi ButterfieldLECP ,

Let me know if you run into any problems. Happy to help.

Re: Arcade, FeatureSets, and Popups

AndrewSD — Thu, 17 Sep 2020 16:07:02 GMT

Hi Xander,

Again thank you!! So I did have an issues but it's probable me and I might have put the wrong values in. So repeat_venue is where the venue info is, org_venue and org_venue_address are the field names that have the name and address info. When I run a test it says, "Execution Error:Invalid Parameters for Count" Not sure what I did wrong.

Thank you!

// user clicked on organization, so that will be your $feature
// get related venue records, change name of relationship and fields according to your data
var fsvenues = FeatureSetByRelationshipName($feature, " repeat_venue ", ["org_venue ", " org_venue_address "], False);

// initialize result text and get count
var result = "";
var cnt = Count(fsvenues);

// check count and start creating result text
if (cnt > 0) {
    // we have related records
    result = cnt + " repeat_venue:";
    // loop through venues
    for (var venue in fsvenues) {
        // add a line per venue and include name and address
        result += TextFormatting.NewLine + " - " + venue["org_venue "] + " (" + venue["org_venue_address "] + ")";
    }
} else {
    // we don't have related record, show that in the result
    result = "No venues found";
}

return result;

Re: Arcade, FeatureSets, and Popups

XanderBakker — Sat, 11 Dec 2021 06:09:46 GMT

Hi ButterfieldLECP ,

I assume that this is caused by the additional space around the relationship name and the field names. Have a look at lines 3 and 16 where this is the case in the expression you shared.

Can you try this?

// user clicked on organization, so that will be your $feature
// get related venue records, change name of relationship and fields according to your data
var fsvenues = FeatureSetByRelationshipName($feature, "repeat_venue", ["org_venue", "org_venue_address"], False);

// initialize result text and get count
var result = "";
var cnt = Count(fsvenues);

// check count and start creating result text
if (cnt > 0) {
    // we have related records
    result = cnt + " repeat_venue:";
    // loop through venues
    for (var venue in fsvenues) {
        // add a line per venue and include name and address
        result += TextFormatting.NewLine + " - " + venue["org_venue"] + " (" + venue["org_venue_address"] + ")";
    }
} else {
    // we don't have related record, show that in the result
    result = "No venues found";
}

return result;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Arcade, FeatureSets, and Popups

AndrewSD — Thu, 17 Sep 2020 16:33:09 GMT

Hi Xander,

It looks like I got the same error as above.

Andrew

Re: Arcade, FeatureSets, and Popups

XanderBakker — Thu, 17 Sep 2020 17:20:10 GMT

Hi ANDREW BUTTERFIELD ,

The second thing I would validate is the name of the relationship used on line 3. Since you had additional spaces in the name, I assume that you configured it manually and not using the interface. It is best to use the interface to avoid any typos in the process.

So, go into the Arcade expression editor, click the ">" right to $feature:

Next, at the end of the list of attributes of the $feature you will find something called "Related records". Click the ">" right to it:

This will reveal the relationships that the layer has. Click on the "FeatureSetByRelationshipName" to insert the code into the expression. Edit the fields (watch out with additional spaces).

If it continues to produce errors, I would need to have access to the data to investigate a bit more. You could share the map and data to a new group and invite me "xbakker.spx" to this group to have access to the data and test the expression more efficiently.

Re: Arcade, FeatureSets, and Popups

AndrewSD — Thu, 17 Sep 2020 17:47:45 GMT

Xander,

I did not work so I am creating a group now.

Thank you again!

Andrew

Re: Arcade, FeatureSets, and Popups

XanderBakker — Sat, 11 Dec 2021 06:09:49 GMT

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?

Re: Arcade, FeatureSets, and Popups

AndrewSD — Thu, 17 Sep 2020 19:51:15 GMT

Xander,

Thank you so much! this is exactly what I was looking for. I had a hard time relating this data so that was probably an error on my part. I really appreciate the time you gave to help with me. I am still learning arcade and can be a little confusing at times. This gives me a better idea on how to use it.

Thanks again!

Andrew

Re: Arcade, FeatureSets, and Popups

XanderBakker — Thu, 17 Sep 2020 20:02:38 GMT

Hi ANDREW BUTTERFIELD ,

I am glad to hear that this is what you were trying to establish.

Could you mark the post that answered the questions as the correct answer? At this moment the thread is marked as "assumed answered". Thanks!

Re: Arcade, FeatureSets, and Popups

AndrewSD — Tue, 06 Oct 2020 20:36:37 GMT

Hi Xander,

Last month you helped me with this arcade popup issue (thanks again!) and I had another question for you. In the above code you have it so that if an Organization is clicked on it show the organization info and the venues they went to. How would I do it so the opposite is true, when you click on a Venue dot all the organizations that have been would show up. I tried just switch everything that relate to Org to Venue and anything Venue to Org.

Thanks for any help!

Andrew

Re: Arcade, FeatureSets, and Popups

XanderBakker — Tue, 06 Oct 2020 21:34:01 GMT

Hi ButterfieldLECP ,

I assume that a little more will be required to get the desired result. If you can share the web map and data again ("xbakker.spx") I can have a closer look. What information of the organizations do you want to show at each venue?

Re: Arcade, FeatureSets, and Popups

AndrewSD — Tue, 06 Oct 2020 21:41:24 GMT

Xander,

Thank you, creating that group now. I wanted to show the Organizations Name, Type, Address and Number of Participants. I also need to figure out how to sum up all the participants. Ex, if there is a list of 4 organizations that have been to one venue, I want to have the list with name, type, address, and participants then under that have a sum of all the participants that have been to that venue.

Thanks again!

Andrew

Re: Arcade, FeatureSets, and Popups

XanderBakker — Wed, 07 Oct 2020 13:41:58 GMT

Hi ANDREW BUTTERFIELD ,

Let me know what the data is shared. Summing the participants should not be a problem.

Re: Arcade, FeatureSets, and Popups

AndrewSD — Wed, 07 Oct 2020 14:16:53 GMT

Xander,

I added you to a group I made, did you get the invite?

Re: Arcade, FeatureSets, and Popups

XanderBakker — Wed, 07 Oct 2020 14:21:37 GMT

Hi ButterfieldLECP ,

I did not receive a notification. I can see if I have the group listed if you can tell me what it is called.

Re: Arcade, FeatureSets, and Popups

AndrewSD — Wed, 07 Oct 2020 14:29:10 GMT

It is called GIS Edits. When I searched your user name it didn't show up but when I searched your name an account showed up.

Re: Arcade, FeatureSets, and Popups

XanderBakker — Wed, 07 Oct 2020 14:46:35 GMT

Hi ButterfieldLECP ,

I just searched for "GIS Edits" and checked the groups with owners outside mi organization and the group does not appear in the list. Can you invite me using "xbakker.spx"? If you use my email or name it may be linked to one of the many other organizations that I am part of. Sorry for that.