Latest Contributions by SteveCole

Todd I'm marking your suggestion of not using Experience Builder as the answer to my Experience Builder question. 😂  Using a Dashboard app does appear to be better in terms of UI and ease of use so I'm onboard with it. I'm already 90% there in terms of what I want it to do but I'm getting bogged down in the Actions and filtering the second related table. I'll make a new thread over in the Dashboards area for that. ... View more

Thanks, Todd. I'm going to need some time to digest the example you've thrown together but it is much appreciated. I kind of have the filter widget "working" but, as you speculated, it only works on filtering the direct table and not the related tables. I can answer the why I'm doing this, though.. My co-workers are responsible for doing monitoring on various wetland mitigation sites that we are responsible for to ensure those sites are meeting their performance requirements. Nearly 20 years ago, I had developed an Access database to store various bits of information and developed some routines which do the quantitative number crunching for all the observations that are recorded while walking the sampling transects. In 2007/2008ish, things like Survey 123 weren't really available so the staff ended up having to record their observations down on paper and then enter them into the Access database in order to run the number crunching (there was a Windows Mobile app called hanDBase but I never got far trying to work up something with it).  We still have this work to be done and budgets are tight once again so I saw an opening to try and leverage Survey 123 to at least provide that field application that would allow users to capture the necessary data digitally. But capturing it digitally is only half the battle- it still needs to find its way back into this Access database. That is what leads me to this thread and developing a tool to extract the data as CSVs from Survey 123 so that I can then import them into Access to perform the data crunching. This is how I end up with a feature class (the mitigation site location) and then 2 related tables (one table with parameters of all sampling transects & a second table with the observations found along each transect). The EB front end solution is an attempt to allow those staff the ability to be self sufficient in terms of collecting, exporting, and then importing the data in order to finish these monitoring requirements. With the exception of having to manually 10 key the data back in, it's worked well up until now. I'm just hoping to close that loop and get it entered digitally on the front end. I still have yet to develop the VBA import routines inside Access but that's all doable. ... View more

Absent of metadata in the service, you can try just searching ArcGIS Online. I just searched for Spokane County and one of the services you linked was the 4th or 5th result, when sorted by date modified: https://www.arcgis.com/home/search.html?restrict=false&sortField=modified&sortOrder=desc&searchTerm=spokane+county&mode=keyword#content  The item info page: https://www.arcgis.com/home/item.html?id=9226c1e6d0034d23b0afa7ad95c78e91#overview  ... View more

Hi Todd, As with most things ESRI, you tend to get most of the way there before stepping on a rake & get hit in the face. Your suggestion seems straightforward enough but it's not working either. I've designed the filter SQL query in the exact same way as what I've done with the Query widget but at runtime, there are no values to select in the pulldown. Query widget SQL design: Query widget runtime: Meanwhile, filter widget SQL design: and filter widget at runtime:   ... View more

Apologize in advance for necro-replying to a topic but I'm currently dealing with this. You asked why not use the query output view and here's why I don't like/want to do this: I have the query widget hitting a feature class with 2 related tables. I have to keep drilling down by tapping the 4 dots to access the options pane and then select related records. This is a far more confusing UI than if the query widget would filter the table widget after selecting records. If it did that, in my example each table is its own tab which the user can quickly cycle through and then export the records via the 4 dot pane located on each tab. *That's* what I want to do but it does not do. You can select View in Table of Add to Table but the user has to select that option. IMO, the action should AUTOMATICALLY do this, if specified. ... View more

Thanks Jon for highlighting that Instant App as I wasn't familiar with it. I neglected to mention that I'm attempting all this inside Portal version 11.5. The Manager Instant App is available to me but, right now, I'm just getting a spinning circle when I launch the app. Clearly I'm doing something wrong so I need to read up on it. Only thing I don't like is it being map based. My S123 use isn't map dependent. ... View more

I don't know if I'm misinterpreting your question but this thread discusses deriving the M value using Arcade. This does work as I'm now using it in a map for my users to click on a road to determine the roadlog milepost location. Outside of this, you need to shell out some $$$ for ESRI's Roads and Highways product which introduces click for M value and zoom to M value functionality which has not made it into their standard web map products to date. https://community.esri.com/t5/arcgis-pro-questions/get-route-m-value-at-point-clicked-using-arcade/m-p/542031/highlight/true#M23831  ... View more

Yeah, as Tim links, it's pretty easy. Just copy the second URL I posted (the one that ends with a zero) and then in your map viewer, click the plus symbol in the upper left and select "Add Layer from URL" and paste in the URL you copied. That will then add it to your map and you can adjust symbology and popups as you see fit. ... View more

The state of MA does have a wards layer published so you could swap out the broken layer for this one- https://gis.data.mass.gov/maps/aec5130790814ace94438d3bcf23cf9a/explore  Direct REST link: https://arcgisserver.digital.mass.gov/arcgisserver/rest/services/AGOL/WardsPrecincts2022/MapServer/0  ... View more

Yeah, what I really like about Doug's approach is that it's just so much cleaner. You don't have to juggle the visibility of 3 group options and people can just type what they know and it should suggest it. ... View more

Doug, I marked your answer as the solution. While it's not exactly what I was looking for, I think this approach can work and since I have to export the S123 information and import it into Access, I can use the Split function to just break up the answer into its respective parts when I import it into Access. I follow up with a PM. Curious if you've tackled a particular need with your forms. Thanks guys! ... View more