Latest Contributions by DavidForbuss1

You should be able to create a view on your gdb that would add some columns to your parent table from the related table.  We have this setup for some symbology on a webmap that we feed into Collector.  The features are the parent table, and there is a related inspections table.  Our SQL statement pulls the most recent inspection (lastprocessed) and determines how long ago it was (dayssincelastprocessed) and adds that number of days into the view's extra columns.  I bet you could do the same thing in this situation but just pull the first record in the related table.  You'd then publish the view as a feature service and feed it into your map.  I'm not super good with SQL but maybe this could give a launch point: The two columns added to the end of the parent table as a view: The SQL statement we're using: SELECT a.*, (SELECT max(b.inspectiondate) FROM CriticalFacilitiesInspectionsTable_evw AS b WHERE a.facilityid=b.facilityid) AS lastprocessed, DATEDIFF(day,(SELECT max(b.inspectiondate) FROM CriticalFacilitiesInspectionsTable_evw AS b WHERE a.facilityid=b.facilityid), GETDATE()) AS DaysSinceLastProcessed FROM ssgravitymain_evw AS a ... View more

Well my EEAP tech guru suggested I could turn off editor tracking prior to do any copying/appending/etc. and turn it back on once I get the data where I want it.  This seems to work quite well.  I'd still however like to be able to situate the fields in the Survey 123 viewer based on customer requests. ... View more

Did this ever get resolved?  Will it work in the expression builder now? Update: I just tried this and unfortunately it doesn't work.  Strangely, the TextFormatting.NewLine option is available under the "Constants" tab, but when you click the help button you get this message even though the test box is showing it as working: ... View more

Well it looks like that won't work based on what i read in this post: https://community.esri.com/thread/204340-editing-multiple-feature-services-in-a-single-form-in-survey123-for-arcgis  I added a new field (set to a yes/no domain) to the parent service and republished it.  I suppose I could have the field crews manually set the "needs attention" field to 'Yes' for now until I can figure out a way to have Survey123 automatically set it to 'Yes' upon submission.  I saw a few people saying that they pulled it off using webhooks, so maybe I'll look into that a bit further. ... View more

Great idea!  I'll try it out this afternoon and let you know how it goes.  I'm betting that it will work.  Thanks for you reply!   ... View more

Hi there, I'm trying to get this working, but I need the field to update for one single specific row.  Is that possible?  I imagine some sort of selection would need to take place.  Here's what I'm trying to do: Feature Point layer>>related table (written to via Survey 123) with globalIDs from parent feature point layer. I need GeoEvent to watch that related table for new entries, and when a new one is created, set a "needs attention" flag to "Yes" on the parent feature layer (determined via the globalID).  Once a user responds to the request, they can just edit the parent point layer and change the flag to "No".  Any help would be much appreciated! Thanks, David Forbuss ... View more

Yeah I really wish they'd fix this.  I need the halos for displaying labels over aerial imagery.   ... View more

Well...I couldn't get it to work the way I wanted to because neither my feature class or the related table are hosted features, so the last option "save as a hosted view", which enables live updating wasn't available.  I ended up digging through my email to find an old SQL statement that my ESRI tech adviser helped me put together that creates a view on the geodatabase and then published that view as a service.  I only needed a one-one join to get the most recent inspection date, so I'm not sure how this would work with 1-M joins.  For what I need though, it seems to be working pretty well so far.  Interestingly, we were previously on a postgreSQL backend and the view was so slow I couldn't hardly use it.  Now that we've switched over to SQL server it seems quite a bit faster.  Anyway, here is the statement that I used...modify as needed:   SELECT a.*, (SELECT max(b.inspectiondate) FROM CriticalFacilitiesInspectionsTable_evw AS b WHERE a.facilityid=b.facilityid) AS lastprocessed, DATEDIFF(day,(SELECT max(b.inspectiondate) FROM CriticalFacilitiesInspectionsTable_evw AS b WHERE a.facilityid=b.facilityid), GETDATE()) AS DaysSinceLastProcessed FROM ssgravitymain_evw AS a Good Luck!  Feel free to contact me if you need any help!  **Disclaimer: I'm not super good at SQL but I'm working on it : ) ... View more

I'm now running into this issue now as well.  My feature class and the table I want to join are technically accessible, but they are not set to "public".  Since the tool is hosted outside of the network, do they need credentials in order to perform the join?  Would temporarily setting them to "public/everyone", then creating the join, then setting them back to restricted permissions work? ... View more

We use AWS to run our desktop products and connect to our enterprise server at another site.  Keep in mind that ArcGIS Pro requires the graphics package from AWS and the price is quite a bit more.  I'm currently running the non-graphics package with 16GB of memory and it runs all of the desktop products very well, but ArcGIS Pro struggles a bit.  It's usable for doing table edits and running some geoprocessing tools, but it bogs down quite a bit when viewing the map.  I really wish ESRI would separate out the the 3D fuctionality of Pro so those of us that don't need it can run it on machines w/o a graphics card. ... View more

150+/night is about the going rate for hotels anywhere these days.  In a place like San Diego I'd honestly expect them to be even higher. ... View more

I'm running into this problem as well. Without a doubt, most my changes are happening after the users have gotten a chance to use the surveys.  It's really frustrating that I risk losing the data they've already created if the changes to the survey are drastic.  I've gotten around this somewhat by creating a copy of the feature service, setting it up the way I want, and then appending the "old" set to the newly created one.   ... View more

#thepowerofthedarkside ... View more