Avoid collecting existing item in Survey123
So assuming you did the relationship part there are 2 ways. (You should have already made a new Hosted service that has the master and the form with a relationship class between them, then repoint the form).
Super easy way is just to map the forms with a symbol based on the Yes/No. Like a big checkmark vs say an X.
If the relationship is 1:1 then you can often just use the relationships attributes that are built into the pop up. Just scroll to the bottom and you will see things like {relationships\0\objectid}. If it is 1:M then you can only get a count of the forms found. But this may be enough for you. (I also wonder if a 1:1 would even let you make 2)
If you want only the ones that are marked as Yes in the form you can use Arcade.
BUT I just remembered you can not change the symbol and use a related lookup yet. I think cause it is too slow. You can have it in the attribute table or in the popup however. So you could have the master popup say in large Red type or something "Already Flushed". Sorry forgot about the feature set not working there yet.
The arcade just uses the key to go look it up.
Here I have a popup with Red text. Then if an error is found I see text in Red otherwise it is just blank and see nothing.
if ($feature.EvalStatus == "Eval") {
var sql = "PlotKey = '" + $feature.PlotKey + "'";
var tbl = Filter(FeatureSetByName($map,"Plot Char"), sql);
var tblCnt = count(tbl)
if (tblCnt < 1) {
return "\n----No Plot Char form found!"
}
else if (tblCnt > 1) {
return "\n----More than 1 Plot Char form found!"
}
else {
return ''
}
}
else {
return ''
}Hope that helps. See my other post below with links to more.
