Latest Contributions by LynnBerni

YES!! This would be a truly significant improvement to real-world dashboard functionality. Come on Esri.... ... View more

As you have discovered, options for accessing and displaying related data is often quite frustrating.  Per the suggestions from MobiusSnake, you will need to add a Map Element (with a map that includes your point data and the related tables), as well as the Chart Element to access and display the related data. But you don't set up the filters in the Map Element, rather the only way I found was with "Category Selectors" in either the Sidebar or Header elements.  You then use the Selectors to filter the charts by sampling location. And yes, lots of "polishing" and fiddling with the settings to get the dashboard working how you want.  One thing that is the most frustrating about related data in dashboards is that you cannot simply click on the sample points in the map to filter the data charts! Here's my stream sampling dashboard, which is very similar to what you describe: Salt Lake County Stream Water Quality Dashboard. p.s. don't forget to add and setup a Mobile View for your dashboard too :^) ... View more

Hello S123 community, This problem is unresolved for me.  My SampleIDs are not being calculated. I have to go in and add them manually.  Does anyone have an idea as to what changed and how I can fix this?   The formula works as expected for other sample data that we collect, that are NOT in a repeat.  Connect  3.21.62 Field Apps  3.21.62 HELP!! Thanks, Lynn ... View more

A splash screen and or news banner option would be fantastic! ... View more

I actually like the default filename for photos because it includes both the fieldname and the date, but I just want to also add the site name to help distinguish where the photos are taken. We have a TON of image questions in our survey and it will be much easier to copy paste the fileName formula if I can include the fieldname in the formula. Is this possible?   ... View more

Completely agree!  The sidebar should stay open until someone chooses to close it. ... View more

I don't see how to "update the services of URLs in a web map" in this new version of Assistant. Will this (incredibly helpful) feature be included at some point?  I would continue using the the classic AGO Assistant for this task, but it's not working.  AGO does allow me to update the URLs, but the change is not getting pushed out to the web map itself!  ... View more

thanks, it is a geodatabase table.  I just exported the points to the file gdb, and now it works.  So the problem was definitely the data being in two different gdbs! ... View more

Thanks, for the scenario that didn't work, the join table does have Object ID....but I think the problem must be that the data is NOT in the same gdb.   We do have relationship classes, but I need to join the related data because I want to symbolize the points based on the data.  ... View more

The expression is working like a charm in the AGOL popups (see attached screenshot). Portal popups too, with a minor tweak. I started out trying to get this to work in Pro. Then switched to AGOL mainly because I wanted to create a map that's easy to share with colleagues who have limited GIS skills.  Ideally, I wanted Arcade to customize symbology on the fly, without needing a new "rating" field, since my data is in an egdb and I don't have full access to easily add new fields. I'm using published REST services in the webmaps, which are referencing the tables that are updated whenever new water quality samples are submitted via Survey123.  Plus, I don't really want a "rating" field in my site points, since the value will change based on the samples being evaluated (as currently written, the expression looks at all samples collected at each site, but we'll also want to see ratings based on date ranges, such as comparing 3Q 2020 to 3Q 2019 for example). In an attempt to symbolize the Good, Fair, Poor rating with a field calculation, I just exported a copy of my site points so I could add an "E.coli Rating" field.  Unfortunately though, the arcade field calculation in AGOL doesn't allow me to access a FeatureSet from other layers in the map...there's no $map variable! There is the $datastore variable which, "allows you to define a FeatureSet from any sub-layer of the Feature Layer that you’re currently working with in the Arcade editor."  I don't even know what that means. Ugh.  Even if I could get it to work, the other bummer about field calculations is that they're static. Whereas an arcade expression in a popup (and hopefully someday in the symbology) is dynamic, and will update when the input to the expression updates. Like I said before, custom on-the-fly symbology is the dream! So now, I jumped back into Pro and I'm trying to use my shiny new expression in a field calculation, but I can't figure out how to get at the related tables. I don't know how to access FeatureSets in the field calculation. Dagnabbit!!  It's frustrating how the Arcade functionality is different in each platform.  Working with related data is so tricky. Maybe its time to abandon Arcade, at least for now. David or @JoeBorgione, do either of you think Python would be a better solution?  For now, in order to get these ratings published in a map asap, I'm just gonna crunch all the numbers in Excel and then use a join to "manually" add the ratings into my copy of the site points. Which is ridiculous, I know. I hope this answered your questions David. Thanks again for all your help! ... View more

Yes, it's the related tables. Neither the $map or $datastore global variables are available to use in a symbology expression, so there's no way to access the related tables. So frustrating!  ... View more

Wahoo, it works! So simple. So sleek. So easy, once you gave me the answer that is, haha.  And a different solution than what I originally thought I needed. Thanks so much David :^) I named the new variable "highest_mpn" and gave it a starting value of 100, which is the highest possible MPN for the 'Good' rating.  Now if only I could use this expression to access my related records in either a field calculation or to update symbology on the fly, because ultimately I want to symbolize my sample sites based on the rating.  I know symbology on the fly isn't available yet with arcade, but I really thought I could use this in a field calculation. There's no $map in the fc arcade window! Here's my updated expression:    //store SiteID as a variable so it can be used to query //the BacteriaSamples table for matching records var siteId = $feature.SITEID //access BacteriaSamples table as a FeatureSet; //include only three relevant fields and filter on QA/QC status var samplesAll = Filter(FeatureSetById($map, /* Watershed - BacteriaSamples */ "Watershed_962", ['SAMPLEDATE', 'SITEID','MPN_ECOLI']), "QAQC_COMPL = 'yes'") //use SQL filter statement to access variable with @ symbol; //essentially this creates a relate var filterStatement = "SITEID = @siteId" //filter the table to find related records at each site var samplesBysite = Filter(samplesAll, filterStatement) //store count of related records as a variable var cnt = Count(samplesBysite) Console("Number of Samples: " + cnt) //loop through samples to find the highest MPN_ECOLI //rating criteria: <= 100 'Good'; 101-405 'Fair'; >405 'Poor' //set starting value of variable to highest possible 'Good' rating var highest_mpn = 100 var rating = '' if (cnt > 0) { for(var f in samplesBysite){ //if sample is higher than current highest_mpn value, update it highest_mpn = When(f.MPN_ECOLI > highest_MPN, f.MPN_ECOLI, highest_MPN) } }else { rating = "No samples" } //designate site rating based on highest_mpn value rating = When(highest_mpn <= 100, 'Good', highest_mpn > 405, 'Poor', 'Fair') Console("Highest MPN: " + highest_mpn) Console("Site Rating: " + rating) return rating                     ... View more