Latest Contributions by FrankPrice

‎12-16-2016

This tool helps: https://community.esri.com/docs/DOC-6496

‎04-21-2016

Thanks for your help with it!

‎04-21-2016

Well, not very concise but I guess it does the job...

‎04-21-2016

Check out the attached. I deleted most of the fields but tested and still have the same problem. Try the Obs_data_temp field.

‎04-21-2016

I tried that previously and again when you suggested. It doesn't throw an error but doesn't select anything either (yes, there are definitely numbers in the field I'm querying).

‎04-21-2016

Thanks, but I just get "An invalid SQL statement was used". Is the PATINDEX function specific to SQL Server? I need something that will work on a file geodatabase...

‎04-21-2016

Does anyone know what the appropriate SQL syntax is for selecting any record that contains any number within a text string in a field using Select by Attributes with a file geodatabase feature class. The help page mentions using the pound sign as a numeric wildcard but this isn't working for me so maybe it only works for personal geodatabases? And I know I can use the field calculator and python or VB to do this in various ways but it just seems like there should be a quicker way to do it with SQL using Select by Attributes. I'm thinking there should be something like Field_name LIKE '%#%' where the pound sign is any number. Thanks for any pointers!

‎03-22-2016

In case anyone else runs into this issue, ESRI says this is intended functionality: The reasoning for this is so the user doesn't have to see anything they can't fill out yet. The order is not honored because users will fill out a form from top to bottom. If a field suddenly showed up above, they would likely miss seeing it because they would have to scroll back up and then back down to continue filling out the form. That's why its placed the way it is, to avoid inserting fields into areas that the user already completed or skipped past. Having them grayed out would still be an issue. Be sure to check the github page for geoform issues: GitHub - Esri/geoform-template-js: GeoForm is a configurable template for form based data editing of a Feature Service.

‎03-04-2016

I need to create a geoform with subtypes and default values for some fields. I have a problem with fields with default values assigned. Any field with a default value will not be visible until the subtype is picked and then it shows up in the wrong order. If I remove the default value for this field or don’t use subtypes everything works fine. This seems to be a reproducible problem. Here is an example: http://arcg.is/1Ys1wYJ There is a field (titled “Field that moves”) that doesn’t show up until you select the subtype (first field) and then it shows up in the wrong order (this field is set up to be last in the list). Any insight?

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by FrankPrice

Re: How to copy all records from a Map/Feature Service

Re: SQL syntax for numeric wildcard in file geodatabase

Re: SQL syntax for numeric wildcard in file geodatabase

Re: SQL syntax for numeric wildcard in file geodatabase

Re: SQL syntax for numeric wildcard in file geodatabase

Re: SQL syntax for numeric wildcard in file geodatabase

SQL syntax for numeric wildcard in file geodatabase

Re: issues with subtypes in Geoform

issues with subtypes in Geoform

Re: issues with subtypes in Geoform

Re: How to copy all records from a Map/Feature Ser...