Latest Contributions by DougBrowning

My guess is your intersect is getting nothing so when you try to use First it fails.  I would break that out and test the is empty on the result of the intersect before trying to use First.  Happened to me. ... View more

One trick to not recalc on you is once(position()).  But note position has issues when it is nested.  Check to make sure you are not getting a loop error at the top right on Connect.  If you do I had to go back to the old way of once(count(dummyfield of 1)). To get the sum or max correct it has to be 1 level above what you want to count.  It does get tricky in nested.  But just roll up as you go. But big note all of this falls apart if the user goes back a few records in the repeat and deletes a record.  Then you got a dup.  We mostly just stopped using indexes.  In an attribute table they order how they were added anyway so we just don't really need them anymore. ... View more

Have you tried find instead?  Set the Search paramas in the web map to the layer and field you want then use find. https://www.arcgis.com/apps/mapviewer/index.html? webmap=8152694dd9594393a1db4d62d2020fe3&find=redlands california Also to use xy you use Center not Find   &center=<x>,<y> https://community.esri.com/t5/arcgis-survey123-ideas/add-ability-to-link-back-to-feature-from-survey123/idc-p/1560938#M3151  ... View more

Only issue I see here is users manually typing in IDs.  This is the whole reason we went to read only IDs and passing them in as the crews got them wrong all the time.  In fact the last 3 jobs the biggest QA issue was users typing in IDs.  With GPS in every form you can figure them out and fix them but its work.  You could add a distance from where you say calc but then you have to keep a csv of lat/longs up to date.   ... View more

We have been adding big Do Not Use thumbnails and it helped.  Then we add nice thumbnails to the correct one. ... View more

This is what we do with up to 15 forms related to the main parent.  The trick was to use Field Maps as the base.  This actually works out well since Field Maps is spatial it is great for crews getting to the location. We preload all the sample locations they are to visit with all the important attributes.  In the popup of these we have launch links that open the different 123 forms sending several fields over to dynamically change the form for that site and pass over the relationship key.  This way all the sub forms are related back to the main form.  We do NOT use globalid for the relates, well its still there we just have a second related id that we pass back and forth.  If you ever export or import your data around globalid falls apart on you fast. In another project we even fill out a site visit related record in Field Maps and add some info like measurements of the site then use arcade to calc some numbers and a on the fly, and an ID that uses the current date, then we use that to send to the form.   I did a big write up on this awhile back here  https://community.esri.com/t5/arcgis-survey123-questions/mapping-with-survey123-within-a-polygon-or-admin/td-p/836112 I know this is 2 apps but Field Maps is good with well maps and 123 is good for forms so they work really well together.  Works slick.   ... View more

You do this in the choices tab.  Again its List Name, Data stored text, Friendly text ... View more

You are putting the list name in the name column.  This should be the text that will be stored instead. It works like list_name    name                     label list_name   TextStoredInDB   UserFriendlyText ... View more

I got access to edit on the server now.  If I comment out the code and publish it takes less than a minute.  Then I go in and uncomment out the script server side.  This is a trick we have had to use for years now.  Something is wrong with the repathing part of publishing.  Still 20+ minutes each time.  Overwrite fails every other time.  What would cause such a lag?  I can send script if needed.  @ChrisUnderwood  ... View more

Pulldata often does not like being inside a calculation.  I would simply remove the round.  No need to reduce the accuracy.  See if that works. ... View more

Is this showing a field name that starts with underscore?  ${_0_farm_identification}  If so I have seen that break forms. ... View more

I would make this a repeat and keep the history.  You can then use join to display the history easily.  I do not think what you have will work out the way that 123 is built. ... View more