Latest Contributions by DavidSolari

Would Contingent Values solve this issue for you?

if not arcpy.GetSigninToken(): fail() portal = arcgis.GIS("Pro")

The logical endpoint of this is the geoprocessing modules feature, which allow you to bundle your Python toolbox(es) as members of a standard Python package. There's a very big learning curve and you're forced to deal with Python's perpetually half-baked build systems but your reward is a fully managed, easy to read bundle of code that you can load into different environments, complete with proper dependency management. And the toolboxes are accessed just like system tools which is pretty slick. Just watch out for using them in web tools, that's a whole other can of worms.

The field calculator doesn't use any types that are pass-by-reference, so you have to return what you want like so: def reclass(Date, DateType): if (DateType == "D"): return Date[3:5] return None

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.

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

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.

Online Status	Offline
Date Last Visited	Friday

My Ideas

Latest Contributions by DavidSolari

Re: How to show required field values in ArcGIS Field Maps

Re: Check to see what user (or if no user) is logged into Pro

Re: How to Make Python Toolbox Use It's Folder Location as The Working Directory?

Re: ArcGIS Pro field calculator if statements based on value of other field

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: How to show required field values in ArcGIS Fi...

Re: How to Make Python Toolbox Use It's Folder Loc...

Re: ArcGIS Pro field calculator if statements base...

Re: Calculate right after hitting the submit butto...

Re: Python code to subtract a value but don't go b...