nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Omit Fields without data from the Pop up Window on Online MapViewer

WFCAdmin

I am making an online experience and need help with Pop-ups

I have a point layer that contains my company's environmental DNA sample results. There are over 1000 data points, containing information on over 20 species. The point attributes include 46 fields.

When a point is selected in the map, I would like the viewer to only see those fields in the pop-up window that have data for that particular point, instead of having to scroll through 46 fields to find the pertinent DNA results.

For example,

For this point, I would like the following pop-up window to omit all the empty rows (red slashes).

Can someone help me with this appropriate arcade expression?

I prefer the default pop-up look. No fancy headings or color are needed.

If you could provide an example that would be great!

Here are a couple of the fields in my data set.

Chinook_Salmon_DNA_Detected_

NumPos_ChinookWells

Coho_Salmon_DNA_Detected_

NumPos_CohoWells

Bull_Trout_DNA_Detected_

NumPos_BullTWells

Thank you!!

Encontre mais publicações marcadas com

Accepted answers

gis_KIWI4

Here is the code to use display names -

var attributes = Dictionary($feature)["attributes"];
var fieldInfos = [];
var attributeValues = {};


var excludeFields = ["OBJECTID", "EditDate"]; //Use this to exclude any fields, null or not null


var layer_schema = Schema($feature);
var fieldAliases = {};


for (var i = 0; i < Count(layer_schema.fields); i++) {
    var field = layer_schema.fields[i];
    fieldAliases[field.name] = field.alias;
}


for (var key in attributes) {
    var value = attributes[key];


    if (!IsEmpty(value) && value != "" && IndexOf(excludeFields, key) == -1) {
        var displayName = key; // Default to field name
        
        // Use alias if available
        if (HasKey(fieldAliases, key)) {
            displayName = fieldAliases[key];
        }
        
        Push(fieldInfos, { fieldName: key, label: displayName });
        attributeValues[key] = value;
    }
}



return {
    type: 'fields',
    fieldInfos: fieldInfos,
    attributes: attributeValues
};

Here you can see the Highlighted fields have had the Display Name (ignore the other fields).
The test layers has Display name and Field Name the same.

All comments

andeb31

I have had success with using Arcade to accomplish this, however I really wish Esri would release a native solution to hide null fields. Seems like a toggle option would be possible. This would keep all layer settings like field order, aliases, even display format without having to tweak through Arcade.

Yeaton

Hi gis_KIWI4,

I am following the advice you provided in this post to modifiy my pop up attribute tables. I copy and paste the script you shared and modified for excluded values. Unfortunately, when embedding the script in the map even the attributes that have values are omitted from the pop up table. Do you have any insights into this? Much appreciated!

Best,

A. Yeaton

Table pre Arcade Script.png

Table post Arcade Script.png

gis_KIWI4

Here is the code to use display names -

var attributes = Dictionary($feature)["attributes"];
var fieldInfos = [];
var attributeValues = {};


var excludeFields = ["OBJECTID", "EditDate"]; //Use this to exclude any fields, null or not null


var layer_schema = Schema($feature);
var fieldAliases = {};


for (var i = 0; i < Count(layer_schema.fields); i++) {
    var field = layer_schema.fields[i];
    fieldAliases[field.name] = field.alias;
}


for (var key in attributes) {
    var value = attributes[key];


    if (!IsEmpty(value) && value != "" && IndexOf(excludeFields, key) == -1) {
        var displayName = key; // Default to field name
        
        // Use alias if available
        if (HasKey(fieldAliases, key)) {
            displayName = fieldAliases[key];
        }
        
        Push(fieldInfos, { fieldName: key, label: displayName });
        attributeValues[key] = value;
    }
}



return {
    type: 'fields',
    fieldInfos: fieldInfos,
    attributes: attributeValues
};

Here you can see the Highlighted fields have had the Display Name (ignore the other fields).
The test layers has Display name and Field Name the same.

rzufelt

I don't really see any difference in performance using this vs. the Field List but I only have 33 fields and 1100 features.

I'm pretty new to this kind of Arcade myself, but saw this post and had the need to incorporate it into some existing maps.

However, I do not see a way to have it non alphabetical. The script seems to be returning the Fields in the right order, but they get automagically re-ordered in the popup.

Hopefully @gis_KIWI4 or someone with a better understanding of this can figure out a way.

If I get a chance in the future, may dive into this more.

WFCAdmin

Also, if it were possible to have the resulting popups use the display name instead of the field name, that would be amazing!

WFCAdmin

It does work!

It just takes about 1-2 minutes to load the popup.

It looks like it defaults to ordering the fields alphabetically. Is there any way to correct this?

Thank you again!

rzufelt

To get this to work, I had to remove the field list, then add a new Arcade content and embed the code there.

Then it will draw the popup table correctly.

WFCAdmin

Awesome!

I am getting very close! Thank you gis_KIWI4!!

I am struggling with where to imbed the expression.

I notice that it will replicate the fields list filtered perfectly, omiting all the empty fields, but only if I add the expression after the fields list.

If I remove the fields list and only only include the expression then nothing will pop up.

gis_KIWI4

The arcade code is fully dynamic. No need to mention what fields to output. The only time you might want to specify the fields is in

var excludeFields = ["OBJECTID", "EditDate"];

These fields will be removed regardless if they are null or not.

WFCAdmin

Thank you so much!!!

Sorry, I am a total novice with Arcade.

For the fields line, I bracket each field with ' ' and separate each field with a comma? Do I close out the fields row with anything special?

Here is an example

return {

type: 'BULL_DNA_Detected', 'Num_BULL_Wells', 'DOVN_DNA_Detected', 'Num_DOVN_Wells'

fieldInfos: fieldInfos,

attributes: attributeValues

};

gis_KIWI4

@WFCAdmin -

Try this -

var attributes = Dictionary($feature)["attributes"];
var fieldInfos = [];
var attributeValues = {};


var excludeFields = ["OBJECTID", "EditDate"];


for (var key in attributes) {
    var value = attributes[key];
    

    if (!IsEmpty(value) && value != "" && IndexOf(excludeFields, key) == -1) {
        Push(fieldInfos, { fieldName: key });
        attributeValues[key] = value;
    }
}


return {
    type: 'fields',
    fieldInfos: fieldInfos,
    attributes: attributeValues
};

This also allows a provision to remove certain fields like "ObjectID" and other tracking fields.
An example below -

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.