Latest Contributions by AdamLevine

John, Thanks so much! Adam ... View more

John, Along the same exact lines as the above example, could we use the Split function to grab the street name instead of the street number?  Anything after the space essentially.  Thanks, Adam Levine SUNY Cortland ... View more

xander, Thanks so much for your time - it is still not 100% the way I want it to work but is so close that I am going to try and figure out the rest.  I don't want to take any more of your time with this.   I really appreciate all the help you have provided. Adam ... View more

Xander, I want the popup on the Bowers - BuildingsSQL.DBO.BWR_FireEx layer.  I want to use LocID from the BowersTransactions layer to display the most current extinguisher, so I submitted 2 transactions for BW-228 - different dates and I would like it to display the newest FE#.      My goal is: I am trying to display in the popup the current Fire Extinguisher at that location.   The process is every year all locations will have an inspection done.  Those will populate in the BowersInspections layer (I currently filtered for 2020) The ones that fail will have a transaction done to replace that extinguisher in that location which will populate the BowersTransactions layer.   So, if the FE passes the FE# will come from the most current BowersInspections layer for that location otherwise it will come from the most current BowersTransaction at that location.  Does that make sense?  That is the entire process – if I have to filter by year (like I have at this moment) that is ok.  So hopefully to further clarify and not confuse you - looking at expr2 - this expression is close to what I need - it is pulling the BowersTransaction FE# if there is one otherwise it pulls the BowersInspections FE# however if there was an additional transaction for that location then it is not pulling the most current.      Can this be accomplished with Arcade or am I pushing into JS?   I am a novice programmer – this is the first Arcade script that has been a bit beyond my abilities.   Thanks, Adam ... View more

Xander, Yes - I have a bunch of expressions going in that popup - the last one is the one I was working on expr4.  I submitted a test survey a few minutes ago for BW-228 - what you will see is expr2 brings up the FIRST transaction not the test that I just submitted a few mins ago - so that was what I was trying to get to show up for the expr4 script.   Does that make sense?  Adam ... View more

Xander, Give it one more shot and then I will do it without the basemap if necessary.  Thanks, Adam ... View more

Xander, I invited you to a group called ESRI Support in our organization and gave you access to the stuff I am working on.   Thanks again, Adam ... View more

Xander, Thanks again - I was looking at the post from Feb 1 and the code and your explanation make sense - I am just confused by the way I have things set up in this map so I am still trying to figure this out.   Would I be able to get further assistance (screen share) from support or is this something that wouldn't be supported by the ESRI support call center?   Thanks, Adam ... View more

Xander, The 'group identification' would be LocationID.    The screenshot that I sent you was my mistake.   The LocationID wouldn't be blank on my map ever. The code below is VERY close to what I need:  (the only problem is if I submit another Transaction for that locationID then it is pulling the first one (that would be the 'first' piece of code correct?)   IF I manually change the filter to an updated date range for the BowersTransactions featureset then this code does bring up the correct FE#)   So, I need to figure out how to bring up the last result in the array, instead of the first.......am I understanding that correctly?  var result = ""; var transfe =Intersects(FeatureSetByName($map,"BowersTransactions"), $feature); if (Count(transfe)==0) {     // no BowersTransactions     var inspfe =Intersects(FeatureSetByName($map,"BowersInspections"), $feature);     if (Count(inspfe)==0){         // BowersInspections either         result = "No results found";     } else {         // just BowersInspections         result = First(inspfe).extinguisherno;     } } else {     // BowersTransactions found, don't check BowersInspections     result = First(transfe).feno2; } return result; Thanks, Adam ... View more

Xander, Can I use some of the 'hidden' fields that are inherent  with Survey123 for instance EditDate, and ObjectID or do I have to rely on the fields that I defined for the survey?   Also, I have a filter on Location ID so that only those that pertain to the building in question are shown.  So, Location ID would have to show up based on the filter if that can still be used as the group identification?   Adam ... View more

Xander, It is tough to get a screenshot with the data only because there are so many fields - I have Notes being pulled into the Survey.  I have included a screenshot with the actual field names.  I also included a screenshot with the data containing the one date field that I created for this survey.  Thanks, Adam ... View more

Xander, I did a quick data export to Excel from the Survey123 Transaction Survey - so I have provided a screenshot of the fields and highlighted the date fields that I could use. I have also already filtered the transactions on 2020 - these are annual inspections however if there is any human error and they have to submit multiple transactions I would like the last extinguisher number to be used in the pop up based on the latest date.  Hope that clarifies everything.    ... View more

Xander, Let me clarify - I need the last transaction extinguisher number instead of the intersect (it seems to be pulling up the first one) that is really the only change to what I am trying to do.   If there isn't a transaction extinguisher number it should defer to the inspection extinguisher number.   So, it is close to what I need.   I believe the article i posted wouldn't be applicable because I am not using a related table. Correct?    Adam ... View more

Xander, Thanks for your help....I tested this with a technician and it is close to what we are looking for but now I think we have to adjust for the latest transaction (based on a date field).   So I will have to look at this document How to get attribute with last date modified from related table using Arcade perhaps as a guide?  Probably not this simple however can I create another variable (using some of the above code) that would be based on the Count being greater than 0?  Adam ... View more