topic Re: Returning Field Aliases for Specified Fields Using Arcade in ArcGIS Online Questions

Returning Field Aliases for Specified Fields Using Arcade

DaveK — Fri, 24 Jun 2022 13:22:32 GMT

Hello,

I'm trying to use Arcade to return the field aliases of fields that have a value of "1" in the data. I have a table of fish species and I would like to return the field alias in the popup anytime there is a value of "1" found in the species record (image of table below). I currently have an Arcade expression that returns all of the field aliases if a "1" is found in the data, but I would like to specify the fields to return.

Expression I have so far that returns all:

var features = FeatureSetByName($map, 'Ocean Prime Fishing Grounds', ['*'], false);
var aDict = Schema(features);
var aArray = aDict["fields"];
var output;
for (var i in $feature){
if ($feature[i] == 1) {
for(var j in aArray) {
var dict = aArray[j];
if (dict['name'] == i){
output += dict['alias'] + TextFormatting.NewLine;
}
}
}
}
return output;

Here are the specific fields I would like to return:

'SUMMFLOUND', 'SEABASSTAU', 'CODPOLLOCK', 'BLUEFISH', 'WEAKFISH', 'STRIPEDBAS', 'TUNA', 'SHARKS', 'BILLFISH', 'BONITOALBA', 'SCUP', 'RED_HAKE', 'LOBSTER'

Example of the data table:

The data I'm using is shared publicly - https://njdep.maps.arcgis.com/home/item.html?id=df7de8c132a749d680ae415b30322fc8

Any help is appreciated. Thanks.

Re: Returning Field Aliases for Specified Fields Using Arcade

KenBuja — Fri, 24 Jun 2022 13:52:11 GMT

You can specify the fields returned for the Schema array using

Now this will also include the OBJECTID field, so you can test for that when looping through them

if (dict['name'] == i && dict['name'] != 'OBJECTID'){

Re: Returning Field Aliases for Specified Fields Using Arcade

KenBuja — Fri, 24 Jun 2022 14:07:38 GMT

And with some more testing, a shorter way of doing this

var fields = ['SUMMFLOUND', 'SEABASSTAU', 'CODPOLLOCK', 'BLUEFISH', 'WEAKFISH', 'STRIPEDBAS', 'TUNA', 'SHARKS', 'BILLFISH', 'BONITOALBA', 'SCUP', 'RED_HAKE', 'LOBSTER']; var features = FeatureSetByName($map, 'Ocean Prime Fishing Grounds', fields, false); var aDict = Schema(features); var aArray = aDict['fields']; var output; for (var j in aArray) { //console(aArray[j]['name'] + ' ' + $feature[aArray[j]['name']]) if ($feature[aArray[j]['name']] == 1 && aArray[j]['name'] != 'OBJECTID') { output += aArray[j]['alias'] + TextFormatting.NewLine; } } return output;

Re: Returning Field Aliases for Specified Fields Using Arcade

JenniferBorlick — Tue, 22 Apr 2025 17:22:15 GMT

THANK YOU! I tried a couple different solutions for my map and they didn't work. They would show up when I ran them in the configuration dialog, but not in the actual pop-up. I tried both the Arcade expression and the Attribute expressions. I finally tried this one and got it to work as an attribute expression.

Re: Returning Field Aliases for Specified Fields Using Arcade

JenniferBorlick — Wed, 30 Apr 2025 20:01:01 GMT

Annd now it stopped working.