Field Maps Filter fonction not working using an intersect value

CristianGraf

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!

CristianGraf

Hi KenBuja!

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

 

I will try it asap!

 

Thank you!!!