POST
|
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
12-09-2021
09:10 AM
|
0
|
2
|
3907
|
POST
|
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
02-19-2020
12:47 PM
|
0
|
1
|
753
|
POST
|
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
02-19-2020
06:55 AM
|
0
|
3
|
753
|
POST
|
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
02-18-2020
07:43 AM
|
0
|
5
|
753
|
POST
|
Xander, Give it one more shot and then I will do it without the basemap if necessary. Thanks, Adam
... View more
02-18-2020
07:13 AM
|
0
|
7
|
1245
|
POST
|
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
02-18-2020
06:26 AM
|
0
|
9
|
1245
|
POST
|
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
02-17-2020
08:38 AM
|
0
|
11
|
1245
|
POST
|
In the past I have used the pulldata function to access data from a csv file pulling from a specific record.....I was wondering if there is a way to use the pulldata function (or another way) to 'cycle' through a file of data for verification. My use case is to be able to walk into a building - select the building entered and then cycle/scroll through all of the spaces in that building one by one (pulling 5+ fields of information) and check a box verified or not verified (with a list of reasons why). SO instead of having to type in room by room just having it scroll through the list of areas in that particular building which would save a lot of time. Looking for ideas on how/if this might be able to be accomplished. Wondering if a repeat can be used with pulldata not repetitive questions. Thanks, Adam
... View more
02-17-2020
07:59 AM
|
0
|
8
|
1372
|
POST
|
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
02-12-2020
06:41 AM
|
0
|
13
|
1245
|
POST
|
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
02-03-2020
08:32 AM
|
0
|
15
|
1245
|
POST
|
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
01-31-2020
08:41 AM
|
0
|
18
|
2885
|
POST
|
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
01-31-2020
06:50 AM
|
0
|
20
|
2885
|
POST
|
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
01-30-2020
08:43 AM
|
0
|
22
|
2885
|
POST
|
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
01-30-2020
07:38 AM
|
0
|
24
|
2885
|
Online Status |
Offline
|
Date Last Visited |
01-08-2024
08:39 PM
|