Latest Contributions by TimFlynn

Hello! It turns out the issue resolved itself and now my maps are showing field aliases. So that's cool! Thanks, Tim ... View more

Hi Alix, Any idea when an update is scheduled? Thanks, Tim ... View more

Sure.  Here's an instance where the most recent inspection date was 2/20/2020, which is within 30 days. It passes the url for the checkmark image into the inspection.  I use the expression's tag in the image tag.  Underneath I use the same expression to pass phrases instead of urls.  This one says, "Inspection Current." Here is a pop up for a point with an inspection date from December, well over 30 days old: And for all points that don't have inspections this is the result of the Else statement: And just for good measure, here is the expression for the message underneath the image: var relatedrecords = Top(OrderBy(FeatureSetByRelationshipName($feature,"AST_Inspection"), "insp_date DESC"), 1); var cnt = Count(relatedrecords); var relatedinfo = ""; if (cnt>0) { var info = First(relatedrecords); var diff = Round(DateDiff(Now(), ToLocal(info.insp_date), "days")); relatedinfo = IIf (diff<30, "Inspection Current", "Inspection Due"); } else { relatedinfo = "No Inspections" } return relatedinfo‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I am trying to get it to return those text values.  The image urls will not be stored as fields, they'll be static.  I've been able to get it to pass img2url but not img1url when the related field "insp_date" is less than 30 days old.  Here's what I've got now, after realizing there was a bit of a syntax error before. var relatedrecords = OrderBy(FeatureSetByRelationshipName($feature,"AST_Inspection"), "insp_date DESC"); var cnt = Count(relatedrecords); var relatedinfo = ""; if (cnt>0) { var info = First(relatedrecords); var relateddate = Text(ToLocal(info.insp_date), "MM/DD/Y"); var diff = DateDiff(Now(), relateddate, "days"); relatedinfo = IIf (diff<30, "img1url", "img2url"); } else { relatedinfo= "img3url" } return relatedinfo‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Xander Bakker‌ any ideas where I'm going wrong? ... View more

I'd also like to see this capability implemented.  I'm currently working on a storage tank inspection workflow.  Currently, I've created a web app with Web App Builder where a field worker can tap on a storage tank point and then there are 3-6 different inspections that are linked.  The inspections are performed with Survey123 and that data is written into related tables.  Different inspections are performed monthly, quarterly, or annually.  Currently, there's no way for me to symbolize if a tank needs to be inspected without having the user also update a field in the tank location layer.  If I could use workforce to create work orders for inspections that are coming due, that would be great. ... View more

So is there a difference between adding in DES vs DESC?  Both seemed to work, at least while I have very few records in the data set. ... View more

Never mind Xander Bakker I figured it out!  I simply added "insp_date DES" and that did the trick!  Also added a nifty else statement for empty lists. Thanks for all the help in your many responses on these forums. ... View more

Xander, This works but now I've realized that for multiple inspections it will still only return the first inspection date.  What do I need to add to return the most recent inspection date? My code is as follows: var relatedrecords = OrderBy(FeatureSetByRelationshipName($feature,"AST_Inspection"), "insp_date"); var cnt = Count(relatedrecords); var relatedinfo = ""; if (cnt > 0) { var info = First(relatedrecords); relatedinfo = Text(ToLocal(info.insp_date), "MM/DD/Y"); } return relatedrecords‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I tried adding "Top(OrderBy(...),1)"  but that doesn't seem to make a difference.   Thanks, Tim ... View more