Latest Contributions by DavidSolari

‎04-25-2024

Our team has a project that requires all attachments have a very specific name based on a field in the parent feature. We currently "solve" this using a Python cursor to ensure all attachments are named correctly. Not only does this take several hours to chew through the table but every renamed attachment creates a new record in the archive table, effectively doubling the size of every attachment. Enforcing the proper name via Arcade at the database level would solve all of these issues.

‎04-18-2024

I haven't found a way to do this in Survey123 alone, but if your survey data is backed by an Enterprise Geodatabase you can use Attribute Rules to flip the read-only switch on submission

‎04-15-2024

It looks like the "modified" property on each service item aligns with when it was last updated. You'll get some false positives for items that were edited after the service was overwritten but this should be good enough for most purposes. Take another look at Carsten's code for tips on getting the date out in a readable format.

‎04-08-2024

I ran into a similar issue in the past and unfortunately there wasn't a workaround. To my understanding FeatureSetByName must take name of the table as a string literal or it'll create an error. I have to assume there's some hacky pre-processor nonsense that goes on with this function, either way you'll just have to type out the right name for every rule. If you're writing the rule multiple times you might want a script tool that uses Add Attribute Rule to save some time. As an aside, that method of getting the max ID isn't optimal for large datasets, even with an index on the ID field. You may want to look into combining a database sequence with NextSequenceValue to get a new ID in constant time.

‎03-22-2024

This is symptomatic of a bigger problem, which is that everything in Field Maps works off the Smart Form definitions and the APIv4 popup definitions except for Edit Multiple which reads the APIv3 popup definitions (i.e. the "fieldInfos" object at the root of the "popupInfo"). I have a sneaking suspicion this is related to the lack of standardized multi-feature editing in the new API somehow, but either way updating Edit Multiple to use the Smart Form definition is a must, there's no reason for the editing workflows to be disjoint.

‎03-20-2024

Tweaking a layer based on the current datetime relative to a field in the layer is a common request in my org. Usually it's a symbol that we set using Arcade but filtering comes up too and jumping into AGOL Assistant is less than ideal.

‎02-01-2024

Is your data in an EGDB? You can write a database view that UNIONs every layer into 1 big table with a "score" field, something like: SELECT ROW_NUMBER() [OBJECTID], tbl.[LayerName], tbl.[Score], tbl.[Shape] FROM ( SELECT 'Layer1' [LayerName], 1 [Score], Shape FROM A.B.Layer1 UNION SELECT 'Layer2' [LayerName], 1 [Score], Shape FROM A.B.Layer2 ) tbl You'll have to find the appropriate function to get a unique row number for your database, here's some info for SQL Server. Once the view works you can register it to the EGDB, publish it as a layer and drop that in your app for use with widgets.

‎02-01-2024

Will the changes actually remove records or just some fields? If the row count remains the same across the board, you can download the old data, make the changes, join the old data to the new data on the common key field and then field calculate the old data over to the new format. Whipping up a dummy survey to test the workflow is a good idea, you can never tell what Survey123 might do on schema changes!

‎01-25-2024

You could maybe get jagged arrays working with a ValueTable but you might run into ergonomics issues. My preferred solution is a multivalue string parameter where each value is delimited with a known character. As long as you validate each value in the updateParameters validation step you should be good to go.

‎01-25-2024

Does subclassing the tool and overriding the category work? You'd have to duplicate things like metadata between both tools but this seems like the lowest cost solution.

‎01-11-2024

If all the info you need is in the same record, the Field Calculator is the usual solution, here's an overview. If you need to work other records into each record's results, you might find something appropriate in the Analysis toolbox. If that fails, you may need to dig into arcpy and use the cursor objects to implement a custom solution.

‎01-11-2024

As a one-line function: def sub_to_zero(a, b): return a - b if a > b else 0

‎12-22-2023

Just create a new project in each user's share folder, this includes a gdb and toolbox along with all the other project items. That said, treating Pro like ArcMap is going to lead to endless friction. If you structure your work around what you're doing vs. who's doing it then you can create projects for each discrete task. Client wants a new set of maps? Make a project! Need to process a big folder of soil samples or road network updates? Make a project! Projects also work for long running jobs, like keeping all your web service sources in one place.

‎12-19-2023

This would be a massive boon for our org, our #1 source of user issues is failing to login correctly. The two biggest features we'd like to see are: A customizable header that includes our logo and instructions. The ability to make one of the login options much less prominent (in our case, the ArcGIS Login section). The current login layout treats both methods as equally valid which is unsuitable for 99% of our users and leads to confusion, an option to make that section harder to interact with would be great.

‎12-01-2023

You can do this by: Looking for a text file with config options in a known location and populating those values in the tool's validation section if they exist, and Writing the user's chosen values to said config file if no default value exists. For the location of the file, the best practice for Windows is to use a folder with your team's name in the %APPDATA% folder, which is set per user. You can get the config file like so: import os from os import path folder = path.expandvars("%APPDATA%\\AlfredSoft") if not path.exists(folder): os.mkdir(folder) config_path = path.join(folder, "tool_config.json") # Or whatever format works for you if path.exists(config_path): with open(config_path) as config: pass # Work with the file here! As for creating or editing the config file, you should do that in the tool itself or in the validator's updateParameters method, depending on how you want to lay your code out. If you get reading working then writing shouldn't be much more work.

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by DavidSolari

Re: Allow attachments to be named and made required similar to survey123

Re: Calculate right after hitting the submit button

Re: Using Python to extract all web services's last modified date

Re: Arcade Attribute Rule ignores current layer

Re: Control edit multiple at the field level of a form

Re: Map Viewer - Date Filter (today/after today/Date Range)

Re: Find a widget/ solution in WebApp builder to return the sum of values within the buffer

Re: Replacing Survey123 Data

Re: ArcPy script tool parameter for nested arrays?

Re: PYT: Add tools to multiple categories

Re: update values

Re: Python code to subtract a value but don't go below 0

Re: How effectively set the default geodatabase and toolbox when there are many users using ArcGIS Pro?

Re: Customizable Portal Sign-in Page

Re: Set default values for parameters in toolbox for each user?

Re: Are changes to ArcPy scripts needed when acces...

Re: Update feature geometry?

Re: Arcade: Get Measure from Coordinate?

Re: Why Must Survey 123 Folders Change When Changi...

Re: Creating a dynamic field?

Experience Builder Custom Widgets