Latest Contributions by DougBrowning

Typically I see people using the Arcade IIf(IsEmpty($feature.observation_number) for example to only calc if empty. But as others posted this all falls apart offline.  Also if you have multiple users creating features at the same time (a user adds a feature then spends say 10 minutes filling it out then user 2 starts a add during that time).  Coming up with your own id field or using a GUID (or even calc the globalid into a static field) is usually a better way to go. In order to calc at insert into the database only a backend server can do that using attribute rules - but this is not available in AGOL yet (I heard it was coming but have not seen anything lately).   As others posted we never do more than one visit to a site in a day so we use a date stamp like this.  You could add time to this as well. Concatenate($feature.PointID, "_", text(ToLocal($feature.FieldEvalDate), "Y-MM-DD")) Hope that helps ... View more

The item page in AGOL will let you download all kinds of formats including JSON.  I use it all the time and it works great up to about 10 GB then it gets cranky.   I also have a nightly python backup script that backups my AGOL service to GDB.  It does about 15 every night.  I can even backup by layer to remove attachments and cut the size down. You may be able to do some things with ArcGIS for Sharepoint but not sure there.  I would also look into ArcGIS for Excel if you want to see multiple forms and tables all at once.  Just make a map of all your forms then in Excel click and they add in.  Plus its all live time for updates.  You can even edit right there. Hope that helps ... View more

The search appearance has an intersects option but pretty sure it only works against a spatial layer that is a URL to a service.  So not to a csv and they would need to be online.   See here  https://community.esri.com/t5/arcgis-survey123-blog/dynamic-choice-lists-using-search-appearance/ba-p/1060838 What we do is instead is calculate the distance from their current location to where they are supposed to be and then warn them in Red if it is too far.  We do this as part of a Field Maps workflow where they tap the point and it passes lat/long into the form (you could look into this also as its good for helping crews find the location).    You could do a pulldata to the csv based on the location they select then give a big red text warning if they are too far or even a constraint - but be careful if their GPS is off it could stop them. The distance calc looks like this..  SampledMidLatitude is a pulldata from the geopoint question and DesignLat and Long are the static from the CSV (or Field maps). round(acos(sin(${SampledMidLatitude} * pi() div 180)*sin(${DesignLat} * pi() div 180) + cos(${SampledMidLatitude} * pi() div 180)*cos(${DesignLat} * pi() div 180)*cos((${DesignLong} * pi() div 180)-(${SampledMidLongitude} * pi() div 180))) * 6371000,2)  Hope that makes sense and helps. ... View more

Kinda sorta not really.  See my post here for all the details.  For sure my number 1 ask the last few years now. https://community.esri.com/t5/arcgis-survey123-questions/prepopulate-answers-in-a-repeat-with-last-values/m-p/1567256#M60455   ... View more