Latest Contributions by DougBrowning

‎01-29-2025

Usually using bad field names. You should see little green boxes in any fields it does not like. Posting the form would help.

‎01-29-2025

Correct it is ignoring the selection which was a very weird thing to leave out. It has us at a standstill on converting now. Last I heard it was "coming soon" but I still do not see it working.

‎01-29-2025

Code for it is not too bad. Excel is prob the easiest. Or even a Dashboard. import os, time from arcgis.gis import GIS import tempfile # Setup inputs configFile = r"config.txt" # config format is just FriendlyName,ServiceItemID backupDir = r"" #-------------------------------------------- # Make a connection to ArcPro gis = GIS('pro') # read in the config file for list of HFS for Survey123 BackupAllAGOHFSConfigFile = open(configFile, 'r') HFSList = BackupAllAGOHFSConfigFile.read().splitlines() BackupAllAGOHFSConfigFile.close() for HFS in HFSList: HFSname = HFS.split(",")[0] itemId = HFS.split(",")[1] # this now comes from the main AGO page with all the settings. # Start the export to GDB job dt = time.strftime("%Y%m%d_%H%M%S") #out_file = os.path.join(backupDir,"{}_{}".format(HFSname,dt)) out_file = os.path.join(backupDir,"{}_{}.zip".format(HFSname,dt)) print ("Export job started for " + HFSname + dt) fsLink = gis.content.get(itemId) result = fsLink.export("export" + HFSname + dt, "File Geodatabase") # Save to file system print ("Saving final downloaded FGDB to {}...".format(out_file)) result.download(backupDir, out_file) # Remove the extracted FGDB from AGOL (cleanup) print ("Removing the export file from AGOL") deleteResult = result.delete() print ("Delete result is " + str(deleteResult))

‎01-29-2025

I cannot remember but I think $editcontext.editType was different if they copied an existing point and that messed some stuff up. I would check that.

‎01-29-2025

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

‎01-28-2025

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

‎01-27-2025

Some more info here with ticket numbers https://community.esri.com/t5/arcgis-experience-builder-ideas/related-tables-in-arcgis-web-experience-builder/idi-p/1033962/page/2#comments

‎01-27-2025

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.

‎01-27-2025

If I am following you may get farther by creating a unique key. Looks like site + plot + tree may work. Use this for the lookup.

‎01-23-2025

I am not sure but I think it does send the entire repeat table. That is why we could not use it. So keep an eye on it for sure. If it works mark as a solution please.

‎01-23-2025

Looks like you have 3 periods when it should be 2 in position. I would actually use ${NameofRepeat} instead as it is safer.

‎01-23-2025

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

‎01-23-2025

It should not clear the list. Do you have a relevant or something on? If you can post or send the form I can look at it. Not seeing anything off in your images.

‎01-22-2025

Mmm maybe 123 has support but not the reporting. @ZacharySutherby ?

‎01-22-2025

Check the actual data type in the AGOL service though. I would also add time to the report just to see what time it has. Probably midnight. I do not do much reports so not sure. I do remember that starting a field name with a _ is an issue. Esp layer in queries. I do not think that is this issue though.

Online Status	Online
Date Last Visited	Thursday

My Ideas

Latest Contributions by DougBrowning

Re: Error Code 701 and 400 when working in templates

Re: Use selected features as input to analysis tool

Re: Any way to download submitted responses as .json payloads?

Re: Sequential numbering for newly created features in ArcGIS Field Maps

Re: Sequential numbering for newly created features in ArcGIS Field Maps

Re: Any way to download submitted responses as .json payloads?

Re: Experience Builder Cannot Support Relational Databases because it Cannot Support Related Data

Re: Calculating the nearest location from a .CSV file

Re: survey123 connect using csv file to select a subset of data

Re: Attempting to make the default value of a repeat question the value at previous index

Re: Attempting to make the default value of a repeat question the value at previous index

Re: Attempting to make the default value of a repeat question the value at previous index

Re: Remove options from a dynamic select one in a repeat or create a list of chosen option in a repeat

Re: Survey123 Date Only shows incorrectly on Report

Re: Survey123 Date Only shows incorrectly on Report

Re: how to prepopulate a question from a layer by ...

Re: how to prepopulate a question from a layer by ...

Re: how to prepopulate a question from a layer by ...

Re: how to prepopulate a question from a layer by ...

Re: Roll back the June 2026 update?

ArcGIS Arcade