Latest Contributions by XanderBakker

Hi Travis Anderson , You should be able to use the Sum function to do just that: // access the meters featureset, limiting the fields to Consumption var meters = FeatureSetByName($map, "METERS", ["Consumption"], False); // count the meters var CountMeters = Count(Intersects(meters, $feature)); // Calculate consumption var consumption = 0; // check to see if there are meters in the zone if (CountMeters > 0) { // calculate the sum of the consumption consumption = Sum(meters , "Consumption"); } // return the result Return consumption;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ You can also include the number of meters found in the resulting text if that is something you want: // access the meters featureset, limiting the fields to Consumption var meters = FeatureSetByName($map, "METERS", ["Consumption"], False); // count the meters var CountMeters = Count(Intersects(meters, $feature)); // Calculate consumption var consumption = 0; var result = ""; // check to see if there are meters in the zone if (CountMeters > 0) { // calculate the sum of the consumption consumption = Sum(meters , "Consumption"); result = consumption + " gallon (" + CountMeters + " meters in zone)"; } else { result = "0 gallons (no meters in zone)"; } // return the result return result; ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Hi Jeff Davis , For completeness I will add the answer also in this thread; It is not possible yo have access with Arcade in the label profile to related tables. You will need to add a field in the main featureset and fill it with the information of the related table(s) in order to show it as a label. The reason behind this is that wherever an Arcade expression needs to be executed for multiple features the functionality is limited (with the exceptions of the profiles field calculations and attribute rules) due to performance.  Hopefully the Python code provided by Randy does not have a large impact on performance when moving around the map since it will need to executed for each label that will be shown in the map each time the map extent is changed.  ... View more

Hi sgl55 , Not sure if you did not include the complete expression, but at the end you should return the "popupString". That is the main reason you are not getting any result. // Write a script to return a value to show in the pop-up. var portal = Portal("https://services.wygisc.org/portal"); var speciesRelate = FeatureSetByPortalItem(portal, "6a0c8bcd1d164d99b76f162f140212f8", 0, ['Species', 'Taxa', 'Occurrence_Potential', 'BLM_Status', 'Texas_________________Status', 'Federal_Status', 'Habitat', 'Code']); // Filter related features by using a common attribute var HabCode = $feature.HabCode; var codeStatement = 'Code = @HabCode'; //Related features as a variable var relateData = Filter(speciesRelate, codeStatement); //build popupString by iterating through all related features var popupString = ''; for (var f in relateData){ popupString += "Species: " + Text(f.Species) + TextFormatting.NewLine + "Taxa: " + f.Taxa + TextFormatting.NewLine + "Occurrence Potential: " + f["Occurrence_Potential"] + TextFormatting.NewLine + TextFormatting.NewLine; } return popupString;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I would also recommend to access fields that contain an underscore using feature["Field_Name"] and nor as feature.Field_Name (see line 22). Avoid on lines 4 to 6 to include fields that you are not using to increment performance. ... View more

Hi Stantosa , What happens if you parse the actual field values to be included in the url inside the Arcade expression, like this: function MetersToLatLon(x, y) { // Converts XY point from Spherical Mercator EPSG:3857(Web Mercator Auxiliary Sphere) to lat/lon in WGS84 Datum (EPSG:4326). // Source: http://www.maptiler.org/google-maps-coordinates-tile-bounds-projection/ var originShift = 2.0 * PI * 6378137.0 / 2.0; var lon = (x / originShift) * 180.0; var lat = (y / originShift) * 180.0; lat = 180.0 / PI * (2.0 * Atan( Exp( lat * PI / 180.0)) - PI / 2.0); return [lat, lon]; } function CreateURLSurvey(lat, lon) { var url = "arcgis-survey123://?itemID=<surveyid>"; url += "&field:name1=" + $feature["name1"] + "&field:name2=" + $feature["name2"]; url += "&field:name_new=" + $feature["name_new"] + "&field:rel_globalID="; url += $feature["GlobalID"] + "&callback=https://collector.arcgis.app"; url += "&center=" + lat + "," + lon; Console(url); return url; } var latlon = MetersToLatLon(Geometry($feature).X, Geometry($feature).Y); var url = CreateURLSurvey(latlon[0], latlon[1]); return url;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Hi Ari Lukas , The moment you submit the new feature, do you have values in the fields pilotpress, staticpress and respress? If not you will be performing the calculations with null values. It would be better to include a validation that checks if the values are null and avoids performing the calculation when not all values have been specified yet. Can you try this expression? // function to validate if any of the values have not been set yet Function ContainsEmptyValue(arr) { var validation = False; for (var i in arr) { if (IsEmpty(arr[i])) { return True; } } return validation; } // read values var P = $feature.pilotpress; var S = $feature.staticpress; var R = $feature.respress; // validate values if (ContainsEmptyValue([P, S, R]) == False) { // all value are available, calculate Q and RF var Q = 167.0625 * Sqrt(P); var RF = Q * Pow(((S - 20) / (S - R)), 0.54); return RF; } else { // one or more values havve not been set, return null return null; } ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more