How would I map the number of Surveys Completed?

Question

Hello, I am working on a citizen science project where we need at least 3 surveys completed at 45 different lakes. We are using survey123 and AGOL to try and create a map showing how many surveys have been conducted and how many surveys are needed. We have tried the summarize nearby fundtion, which does not update in real time and are currently trying to join the survey feature layer with a point layer (representing each of the 45 lakes) without any success. Any thoughts would be greatly appreciated.

dougbrowning · Answer

Cool.  One note is why I return '' in case you want to get fancy and warn when more or less than 3 are done.

I am using this to show a message only if there is an issue.  So in the pop up you add your Arcade expression (using {expression/expression1}) in red.  That way if the code returns a issue it displays in red.  If no issue it returns '' and no red message.

I got it from this post here  https://community.esri.com/community/gis/web-gis/arcgisonline/blog/2017/07/18/conditional-field-display-with-arcade-in-pop-ups

Example

NathanaelWold · Answer

Thank you, Doug. That did the trick!

dougbrowning · Answer

Joins are static but Relationship Classes are dynamic.

Your SQL query is off.  You are using the pop up for Loon Priority Lake so no need to give that.  What you want to write out is what field you want to query.  You are just building the text SQL string to use.

So

var sql = "selectTerritory = '" + $feature.selectTerritory + "'";

On the rest just make sure your web map has the layers named exactly how you write them here.