Arcade Expression Popup NaN - relationship class table

LianneStegink_gelderland — Wed, 05 Jul 2023 08:49:15 GMT

Hi,

I need some help. I have a related table (relationship class) but only 1/3 of my arcade function is working. The records that say NaN should say Gereed....

The data is all the same for all 6. So I don't know what to do.

I put my arcade expression below.

Thank you in advance.

~~~~

// weergaven monitoring uit tabel

var SNL = FeatureSetByRelationshipName($feature, "Tabel_2023")

//koppeling met gebiedsnaam (tabel en kaart)

var gebiedsnm_SNL = $feature.gebiedsnaam

var koppeling = "Naam = '" + gebiedsnm_SNL + "'"

//filter van de koppeling

var filterSNL = filter(SNL,koppeling)

//aantal vlakken's per vlak

var aantalSNL= count(filterSNL)

//popup

var popup = ''

if (aantalSNL > 0) {

for (var f in filterSNL){

popup += Text(f.Gepland_Inventarisatie_jaar) + TextFormatting.NewLine + "GLK:" + " " + Text(f.GLK) + TextFormatting.NewLine + "Natuurmonumenten:" + " " +

Text(f.Natuurmonumenten) + TextFormatting.NewLine + "NPHV:" + " " +

Text(f.Nationaal_Park_De_Hoge_Veluwe) + TextFormatting.NewLine + "Staatsbosbeheer:" + " " +

+ Text(f.Staatsbosbeheer) + TextFormatting.NewLine + "VALA:" + " " + Text(f.VALA) + TextFormatting.NewLine + "Bosgroepen:" + " " +

+ Text(f.Bosgroepen) + TextFormatting.NewLine}

} else {

popup = 'No Records';

}

return popup

Re: Arcade Expression Popup NaN - relationship class table

jcarlson — Wed, 05 Jul 2023 14:04:11 GMT

Do you ever expect to see more than one related record? Is it possible the first record returned just doesn't have the values you're expecting to see? Try adding Console(f) to your expression so you can verify the information coming from the feature.

I would consider using an Arcade popup element instead of a single field expression like this. You'd be able to have the Monitoring section show up as its own field list.

topic Re: Arcade Expression Popup NaN - relationship class table in ArcGIS Online Questions

Arcade Expression Popup NaN - relationship class table

Re: Arcade Expression Popup NaN - relationship class table