Latest Contributions by DurhamGIS

‎03-09-2021

Try the reply from TimothyMichael with the Excel cheat sheet in this post: https://community.esri.com/t5/arcgis-survey123-questions/auto-populate-in-survey123-from-existing-feature-attributes/m-p/795440/highlight/true#M9323 I think you can use the item ID for the feature service that includes the business name and then build the parameters with your desired fields. And mark the field that includes the parameter as read-only in the Survey123 spreadsheet. Kelly

‎03-03-2021

@KellyAlexander @BenVan_Kesteren All, Through several community posts and a lot of testing, I've strung together how to restrict multiple, but not all, special characters in a text field. Specifically, to restrict \ /, use not(regex(.,'[|\x5C/]')) I restricted ' \ & @ ; " / ? + # $ using not(regex(.,'[|\x27|\x5C&@;"/?+#$]')) For a single quote ' and backslash \, I found to use |\x%% with %% corresponding to the URL encoding code for the special character. To restrict use of all special characters and allow letters and numbers only, use regex(.,'^[A-Za-z0-9]*$')

‎06-23-2020

That is helpful to know but I was hoping for a REST API solution if possible in order to automate.

‎06-23-2020

My interest is in the registered data store details. We have several of them with some possible duplication based on the name that was given during the registration process. We didn't want to unregister any data stores without knowing what services are using them.

‎06-23-2020

Thanks Derrick, I really appreciate the guidance and screen grabs. I checked some hosted FeatureServer services and can see the datastore information but this information doesn't seem to be available for MapServer services.

‎06-22-2020

We're trying to track down the map services that are using a specific data store. It seems the closest I can get to that information is with the ArcGIS Data Store command utility's describedatastore (ArcGIS Data Store command utility reference—ArcGIS Data Store (Windows) Installation Guide | ArcGIS Enterprise) command which is limited to the number of current feature layer connections and nothing more. Is it possible to get these details some other way?

‎06-03-2020

Hello everyone, I'm trying to develop a workflow in Pro to convert our registered voter list with precinct, party, race, and ethnicity fields (an ArcGIS REST service table that is updated nightly that I've added to Pro) to a voter demographic statistics table broken down by precinct that will also be updated nightly. I have no experience with Pivot tables and there don't seem to be as many options for them in Pro as in Excel. I have also been trying to bring the REST service table into Excel to create the Pivot table and publish to AGO, but ran into issues with getting the table from the REST service. Any help with either doing this in Pro or Excel would be greatly appreciated. My end goal is to create a Voter Demographics dashboard using our precinct map and the statistics table.

Online Status	Offline
Date Last Visited	‎05-31-2023 05:57 PM

My Ideas

Latest Contributions by DurhamGIS

Re: Survey123 Tricks of the Trade: Web form URL parameters

Re: Can I restrict characters allowed in Survey123 text box?

Re: How to determine which map services are using a specific data store?

Re: How to determine which map services are using a specific data store?

Re: How to determine which map services are using a specific data store?

How to determine which map services are using a specific data store?

REST services Registered Voter table to demographic statistics using Pivot table

Re: Can I restrict characters allowed in Survey123...