Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About DougBrowning
DougBrowning
MVP Esteemed Contributor
since
07-04-2014
Online
5259
Posts created
2868
Kudos given
518
Solutions
2746
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(34 Idea Submissions)Latest Contributions by DougBrowning
|
POST
|
It is a python in_memory table (not a FC) which in my experience acts just like a GDB. When I make a test copy into a GDB and use my cast query in a Definition Query it works great. Which should simulate the interface directly. I have tried int, INT, Interger, INTEGER, SHORTINT, and a few others. thanks
... View more
07-18-2018
09:52 AM
|
0
|
1
|
496
|
|
POST
|
10.5.1 I tried the * and still get Invalid SQL statement. I also tried different queries before to make sure the code was right and it worked. It is just the cast that gives the error. thanks
... View more
07-18-2018
07:27 AM
|
0
|
0
|
3258
|
|
POST
|
I thought a found a slick way to compare on a number in a string field. CAST(SoilDepthLower AS INTEGER) < 70 This works in a ArcMap definition query just fine. But when I try to use it in a SearchCursor Query it says Invalid SQL Statement. whereClause = "CAST(SoilDepthLower AS INTEGER) < 70" keyField1 = arcpy.ListFields(tableLayer)[1].name keyField2 = arcpy.ListFields(tableLayer)[2].name fieldList = ["SoilDepthLower", keyField1, keyField2] with arcpy.da.SearchCursor(tableLayer, fieldList, whereClause) as cursor: I have tried smallint, double, etc - using both uppercase and lower case. This help page says it is supported http://pro.arcgis.com/en/pro-app/help/mapping/navigation/sql-reference-for-elements-used-in-query-expressions.htm What is the issue? Thanks
... View more
07-17-2018
02:39 PM
|
0
|
11
|
3983
|
|
POST
|
All those people touching one form would scare me but like you said late now. On part 3 I agree that table support in AGOL and really all Esri products is quite poor. My first idea is to set the search settings to the table but it will only allow that on FCs (boo!). I did see though that if you open a attribute table of a table in AGOL map there is a Filter option in the attribute table box. That will filter than they can edit right there in the table. You could also use the Items page data tab with a browser search but that is hard when the table gets long.
... View more
07-12-2018
01:18 PM
|
0
|
1
|
2332
|
|
POST
|
I would make each visit a new form instead. Many advantages like editor tracking on each visit, GPS on each visit, no issues with different techs on each visit, etc. Use a Primary key of some sort with a relationship class to connect them back to the main point. I suggest loading the trap locations in Collector then launch Survey123 passing the Primary Key. Many advantages to this as well like directions to, etc. I do this now with 9 forms all launched from each point - with 9 relationships back. Works slick. For the lab techs I would just have them edit the table in AGOL. Hope that helps.
... View more
07-12-2018
12:31 PM
|
0
|
3
|
2332
|
|
POST
|
Try putting int (no brackets or spaces) in the very last field called bind::type. That did it for me.
... View more
07-12-2018
07:31 AM
|
1
|
0
|
3638
|
|
BLOG
|
Tested on a Samsung S2 v7 and a Google Pixel 1 v8.1. I sent the form to Jonathan on June 28 and James in April so hopefully they are looking into it. Do I need to republish the form under v3? I just used the new app. It is in production at the moment but I think a republish would be ok. Thanks
... View more
07-09-2018
07:03 AM
|
0
|
0
|
7878
|
|
BLOG
|
Any news on making the drop downs faster with External Selects on Android? Tested v3 32 and 64 bit and it is no better. I have been battling a form for months and it is turning the field people off from Survey123. It is taking 1 second per load of a 1,300 item list. I have 8 of these in a repeat which means 8 to 10 seconds for every single hit of the repeat +. I was really counting on v3 to fix this but it is no better. My guys are having to preload the repeats at night before they go to the field. I kept them at bay saying it will be fixed soon. But now I found out the iPad is taking less than 2 seconds! (both v2 and v3). So it is an Android issue. We want to go national next year but these lists will stop the project. Thanks
... View more
07-06-2018
02:24 PM
|
0
|
0
|
7878
|
|
POST
|
We when had this issue in SDE we turn off editor tracking, join, field calc the fixes, turn editor tracking back on. But in your case an Append is NEW data so not sure how you would ever expect keep old dates that way. You need to join and copy the changed fields over instead. Turning off editor tracking while doing so. I would test this to make sure AGOL does not up and remove the editor fields (it does not in SDE). What also may work is to Append in the new records, join to the old records, then field calc over the editor tracking fields. Not sure it will let you do that but it might allow it if tracking is turned off. Good luck
... View more
07-02-2018
09:52 AM
|
2
|
0
|
1450
|
|
POST
|
YES! I need to attach csv files for my project bad. I see no reason not to open it up.
... View more
06-29-2018
09:19 AM
|
0
|
0
|
2320
|
|
POST
|
In my project I did my labels like this since while using the autocomplete style Survey123 will find string combos in the code or name just fine. Typing in ABL or Hook would get you the first one on this list. label ABLA Abies lasiocarpa (Hook.) Nutt. subalpine fir ACGL Acer glabrum Torr. Rocky Mountain maple ACMI2 Achillea millefolium L. common yarrow ACHY Achnatherum hymenoides (Roem. & Schult.) Barkworth Indian ricegrass ACNE9 Achnatherum nelsonii (Scribn.) Barkworth Columbia needlegrass ACRI8 Achnatherum richardsonii (Link) Barkworth Richardson's needlegrass
... View more
06-25-2018
01:34 PM
|
0
|
1
|
1823
|
|
POST
|
Did you create a brand new GDB? For me it was not the Relationship classes but something in the GDB. Create a brand new GDB. Copy and paste your layers in to this new GDB. Then publish. In the end I think it was because I had several "redos" while creating the project. Somewhere all that deleting, creating, and copying messed it up. Possibly due to domains since it complained about them already being there sometimes.
... View more
06-18-2018
01:45 PM
|
0
|
1
|
3924
|
|
POST
|
selected(${Customers},'Other') https://community.esri.com/thread/184917-relevant-field-syntax-for-multiple-choice-questions
... View more
06-15-2018
12:48 PM
|
2
|
0
|
1419
|
|
POST
|
I think it only wraps words so you need a space in there.
... View more
06-15-2018
12:47 PM
|
3
|
0
|
1154
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 3 | Tuesday | |
| 1 | Tuesday | |
| 6 | Tuesday | |
| 3 | Tuesday | |
| 1 | 04-10-2026 08:18 AM |
Activity Feed
- Got a Kudo for Re: Roll back the June 2026 update?. 12m ago
- Kudoed Re: Roll back the June 2026 update? for CarlaSouza. 2 hours ago
- Kudoed Re: June 2026 Update - Dashboards performance issues for Alfie_Kelly. 2 hours ago
- Kudoed Re: June 2026 Update - Dashboards performance issues for PanGIS. 2 hours ago
- Kudoed Re: Before June 2026 update my Dashboards were working great, now they look like this: for SnappedToGrid. yesterday
- Posted Re: Before June 2026 update my Dashboards were working great, now they look like this: on ArcGIS Dashboards Questions. yesterday
- Posted Re: Editing a related table in a Web Map not honoring the relationship set on ArcGIS Online Questions. yesterday
- Kudoed June 2026 update - Indicators randomly stop working upon changing map selection for Neal_t_k. yesterday
- Kudoed Editing a related table in a Web Map not honoring the relationship set for Clubdebambos. yesterday
- Kudoed Re: June 2026 update - Category Selector no longer respect field formatting from AGOL for DanPatterson. yesterday
- Got a Kudo for Re: Roll back the June 2026 update?. yesterday
- Kudoed June 2026 update - Category Selector no longer respect field formatting from AGOL for Neal_t_k. yesterday
- Kudoed Before June 2026 update my Dashboards were working great, now they look like this: for PanGIS. yesterday
- Kudoed June 2026 Upgrade crashes Dashboards for KimOllivier. yesterday
- Kudoed Reinstate the ability to add dynamic text and html for no data and no selection for Alfie_Kelly. yesterday
- Posted Re: June 2026 Update - Calculated expressions not working correctly in edit widget on ArcGIS Experience Builder Questions. yesterday
- Kudoed June 2026 Update - Calculated expressions not working correctly in edit widget for WillyG. yesterday
- Kudoed Layer duplicated in REST services directory for Scott_Sambell. yesterday
- Got a Kudo for Re: Roll back the June 2026 update?. Tuesday
- Got a Kudo for Re: Roll back the June 2026 update?. Tuesday
Contact Me
| Online Status |
Online
|
| Date Last Visited |
28m ago
|