topic Re: Field Maps Filter fonction not working using an intersect value in ArcGIS Field Maps Questions

Field Maps Filter fonction not working using an intersect value

CristianGraf — Mon, 02 Mar 2026 17:33:55 GMT

Hi Community!

I'm working on a project where half of the data it's intersected from a existing polygon (AKA Project Polygon). This polygon has the base data: project name, number, user, dates... So for any new data created on that specific polygon it will be transfered do the new collected ones.

This is very usefull for us, it's help us maintain a standard flow and it's helps to avoid any misspelling once on the field.

One of our goal it's to create a unique id filtered on the project number. So for any type of data, we will need a unique ID from 1 to X.

Here's our code... and it's not returnig what we are specting. As we are intersecting the project number (no_proj) from another layer maybe the issue it's there and the filter it's not doing what it should.

Any guess or another wya to do it?

var numberlist = FeatureSetByName($map,"2-Station d'inventaire")

// Return total list
function RecupererNoProjet(np_1) {
var EntreesDansProjet = Filter(numberlist, "no_proj = '" + np_1 + "'")
var max_feature = First(OrderBy(EntreesDansProjet, "id_table DESC"))
if(max_feature.id_table!= null) { return max_feature.id_table}

return 0;
}

//If value is empty
if(IsEmpty($feature["id_table"]) || ($feature["id_table"])==0 ){

var np_1= null

//Get project number
np_1=$feature["no_proj"]
//Get total project number
var num_proj = RecupererNoProjet(np_1);
return num_proj + 1
}
else {
//Return existing velue lor different to 0
return $feature["id_table"]
}

Thank you!!!

Cheers!

Re: Field Maps Filter fonction not working using an intersect value

KenBuja — Tue, 03 Mar 2026 14:05:16 GMT

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; }

Re: Field Maps Filter fonction not working using an intersect value

CristianGraf — Tue, 03 Mar 2026 18:05:20 GMT

Hi KenBuja!

no_projet it's a text field. id it's a numeric integer one.

I will try it asap!

Thank you!!!