Hi Doug,
Thank you for the help. I just had a couple follow up questions. We are wanting this map to be dynamic, as surveys come in the map will show how many surveys are completed. If I join the two FC (Lakes and Surveys) together will that layer be dynamic?
I tried to hack your code above with no success. Would you mind looking it over? The two layers I am working with are 1) "Loon Priority Lake" and 2) "Survey Point". The common field between them is "selectTerritory". Thank you for your patience, my coding abilities are very limited.
var sql = "Loon Priority Lake = '" + $feature.selectTerritory + "'";
var tbl = Filter(FeatureSetByName($map,"Survey Point"), sql);
var tblCnt = count(tbl)
if (tblCnt < 1) {
return "\n----No Surveys Conducted"
}
else if (tblCnt > 1) {
return "\n----More than 1 Survey Conducted"
}
else {
return ''
}