Latest Contributions by KenBuja

Use the Console function to test whether you're getting back any results from the Filter function. Also, is the field "no_proj" a string field or numeric field? You can use variable substitution in the Filter function to avoid the quote problem function RecupererNoProjet(np_1) { var EntreesDansProjet = Filter(numberlist, "no_proj = @NP_1"); Console(Count(EntreesDansProjet)); var max_feature = First(OrderBy(EntreesDansProjet, "id_table DESC")); if (max_feature.id_table != null) { return max_feature.id_table; } return 0; } ... View more

If you'd like to keep the order of the fields, you can use the feature's Schema instead. Expects($feature, "*"); var fields = Schema($feature)["fields"]; var fieldInfos = []; for (var field of fields) { if (!IsEmpty($feature[field.name])) { var fInfo = {fieldName: field.name} Push(fieldInfos, fInfo) } } return { type: "fields", fieldInfos: fieldInfos };   ... View more

I created the Sampling Design Tool add-in for doing more complex sampling. Take a look at its documentation to see if it has the capability to do what you're wanting. ... View more

I'm not having any problem with dragging and dropping screenshots.  ... View more

This will involve a couple of steps. This code uses an Arcade element in the popup. First , the code gets all the related records for a feature with the FeatureSetByRelationshipName function (line 1).  Next, it creates an array that will contain all the output strings, starting with the area code (line 2). Then it get the First record (Line 4) of the results of a GroupBy function which gets the sum of all the num_trees values (line 5) and then get the Count attribute from that feature (line 10). This value is added to the output array (line 12). It creates another FeatureSet (line 14) that consist of the unique combinations of Tree Role and Status (line 16), with the sum of the Num_Trees (line 17) as an added field. It then gets the unique roles from that FeatureSet (line 20) and loops through them (line 22). In each loop, it get the records for that role with the Filter function (line 24) and loops through those records (line 27), adding up the number of trees for each status (line 28) and creating a string containing status and number of trees (line 29). Finally, it adds a string with the information about each status for the role to the output array (line 31). The return uses the Concatenation function to put each of output strings on a separate line var fs = FeatureSetByRelationshipName($feature, 'your relationship name', ['*'], false) var output = [`Area: ${$feature.code}`] var total_Count = First( GroupBy( fs, "code", { name: "Count", expression: "num_trees", statistic: "Sum" } ) ).Count; Push(output, `Trees total: ${total_Count}`) var grouped = GroupBy( fs, ["Tree_Role", "Tree_Status"], [{ name: "Count", expression: "Num_Trees", statistic: "Sum" }] ); var trees = Distinct(grouped, "Tree_Role"); for (var tree of trees) { var tree_role = tree.Tree_role; var filtered = Filter(grouped, "Tree_Role = @Tree_role"); var role_Count = 0; var output_roles = [] for (var role in filtered) { role_Count += role.Count Push(output_roles, `${role.Count} ${role.Tree_Status}`) } Push(output, `There are ${role_Count} ${tree_role} trees (${Concatenate(output_roles, ", ")})`) } return { type: 'Text', text: Concatenate(output, "<br/>") } This output of this code looks like this:   ... View more

If this did answer your question, don't forget to click the "Accept as Solution" button. That will help others in research similar questions. And help me maintain my MVP status 🙂 The best place to start would be the Home page of the Arcade documentation, focusing on the Language features section. I would also take a look at some of the Arcade blogs that Esri has written, such with this one, which focuses on scripting for popup. I would also look at some of the posts that @jcarlson has written, since he has scripted some pretty nifty solutions to various problems. ... View more

The Expects function doesn't return anything, so you use it like in Line 1. You don't need to call the entire dataset, since the Schema function can work with $feature. You can also get the fields directly from the Schema in Line 2 (I've learned a few things since writing the code in that previous thread) Expects($feature,'Campgrounds_Present','DockPier_Present','DrinkingWater','GrillsPresent','HotShowers','PicnicTables_Present','Restroom_Present'); var aArray = Schema($feature).fields;   ... View more

One workaround is to go to your profile page, which lists all the Ideas you've submitted   ... View more

First, you should put the Expects function as the first line of the script Expects($feature, 'Campgrounds_Present', 'DockPier_Present', 'DrinkingWater', 'GrillsPresent', 'HotShowers', 'PicnicTables_Present', 'Restroom_Present'); Also, if the fields are controlled by a domain, you'll have to use the actual domain code in line 13 or this syntax if (DomainName($feature, i) == "Yes") {   ... View more

You're loading the FeatureSets without their geometry. Use this syntax instead (removing the "false" at the end) FeaturesetByPortalItem(p, "c756ab8f4b654789812c1b9d6d783640", 31, ["*"]),   ... View more

In Arcade, you can check whether a field is empty before adding it to the string. This example uses an array (fields) that contains the field name of each of your fields (line 2). The code loops through that array (line 4) and adds the value to an array (output) if the field's value is not empty (line 5). It uses the Concatenate function to return a string with all of the non-empty values in the output array on a separate line (line 7) var output = []; var fields = ["fieldName1", "fieldName2", "fieldName3"]; for (var field of fields) { if (!IsEmpty($feature[field])) Push(output,$feature[field]); } return Concatenate(output, TextFormatting.NewLine);   ... View more

I'm not seeing that I see it if I include a special character For the labels that are broken, what are the values for ownlab2 and ownlab3?     ... View more