Latest Contributions by DougBrowning

Is the pulldata in any kind of a if statement or other statement?  If so that is a known issue.  It can also fire before the field you are picking at times.  Setting a relevant can help here. You really need to post the lines affected or a form in order to troubleshoot at all. ... View more

Is the pulldata inside an if or other function?  If so that is a known issue.  You really need to post the code or form or we are just guessing. ... View more

Have you looked at this page https://doc.arcgis.com/en/survey123/get-started/integratewithotherapps.htm You did not post the actual URL you are using so not much to go on here. ... View more

If you need to move it one time lots of good info here.  Mostly page 4 https://community.esri.com/t5/arcgis-survey123-questions/transfer-ownership-of-survey-to-another-user/td-p/787623/page/4  ... View more

Looks like topnumber you are not sorting in descending order with OrderBy See here  https://developers.arcgis.com/arcade/function-reference/featureset_functions/#orderby  in counter you are taking the max so I do not think you even need orderby really.  But then you are adding onto objectid and not the actual count of records.  This may be ok though since it would cover you on deletes. this may work var counter = Number(Max(numberlist,'OBJECTID')) Also if the user does not take all the records offline this could fail on you.  Overall we just gave up on numbering as we do not really need it anymore. ... View more

@JeffBarrette   Could this explain my issue here? https://community.esri.com/t5/arcgis-pro-ideas/set-symbology-s-lower-value-manually-in-arcgis-pro/idc-p/1584218#M33756   ... View more

I am stuck trying to do this script.  If the range is really small like =.0003 to .00003 it will completely ignore my custom breaks and use a totally made up scale.  If the range is medium the breaks take but then the map gets all one color - the min value color.  This is totally wrong and users get the wrong idea.  In my case I have -100 to 100 for percent's.  If the range is -7 to 8 then I get ALL of the map getting the color of -40.  These maps are generated in a GP tool on the fly and need them all to have the same symbology. Totally stuck.  Any ideas.     sym = rasterLayer.symbology sym.updateColorizer('RasterClassifyColorizer') # was Condition Number sym.colorizer.colorRamp = project.listColorRamps('Prediction')[0] sym.colorizer.classificationField = "Value" sym.colorizer.breakCount = 10 #sym.colorizer.noDataColor = {'RGB': [255, 255, 255, 100]} # manual breaks # this will fail on small time periods if len(sym.colorizer.classBreaks) == 10: sym.colorizer.classBreaks[0].upperBound = -100 sym.colorizer.classBreaks[0].label = "Over -40%" sym.colorizer.classBreaks[1].upperBound = -40 sym.colorizer.classBreaks[1].label = "-30% to -40%" sym.colorizer.classBreaks[2].upperBound = -30 sym.colorizer.classBreaks[2].label = "-20% to -30%" sym.colorizer.classBreaks[3].upperBound = -20 sym.colorizer.classBreaks[3].label = "-10% to -20%" sym.colorizer.classBreaks[4].upperBound = -10 sym.colorizer.classBreaks[4].label = "0% to -10%" sym.colorizer.classBreaks[5].upperBound = 10 sym.colorizer.classBreaks[5].label = "0% to 10%" sym.colorizer.classBreaks[6].upperBound = 20 sym.colorizer.classBreaks[6].label = "10% to 20%" sym.colorizer.classBreaks[7].upperBound = 30 sym.colorizer.classBreaks[7].label = "20% to 30%" sym.colorizer.classBreaks[8].upperBound = 40 sym.colorizer.classBreaks[8].label = "30% to 40%" sym.colorizer.classBreaks[9].upperBound = 100 sym.colorizer.classBreaks[9].label = "Over 40%" else: arcpy.AddMessage("Warning Trend Rasters may not work with short time frames. Trying reduced symbols.") sym.updateColorizer('RasterStretchColorizer') sym.colorizer.colorRamp = project.listColorRamps('Condition Number')[0] sym.colorizer.stretchType = "StandardDeviation" rasterLayer.name = "Total Change" rasterLayer.symbology = sym      If I save out the map I got the correct range but colors are wrong. Why is it getting blue? Also really wish we could set an exact range.  This upper bound thing is so confusing esp with negative numbers.  Plus what I want to leave certain values out?  Let me set a upper and lower and call it a day please. Then if I add a interval in Pro it still lumps -7 to -100 at the top.  This seems way wrong right?   thanks   ... View more

I do this in several forms. You need to sum at each level of the repeats.   You have a parent, child, grandchild if triple nested.  Add a sum() at the child level that sums up the grandchildren then add a sum at the parent level that sums up the child sum field.  This will get them all. Hope that helps ... View more

@jeffhyderBRVA  For Excel take a look at ArcGIS for Excel.  You can connect to the service directly live time.  No need to download anymore.  My guess is no special license needed either.  Can add maps and even edit with domains in Excel. ... View more

Grids are about as close as you can get.  https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-groups-grids-and/ba-p/895267 Yours may be a bit too many fields to fit but you could try some variations. ... View more

Running into this today.  Waited over an hour to just delete 86,000 records.  Brand new map twice.  I was able to calc a field in a few minutes. Usually some of this caused by relates where a parent delete will go Null all the child keys on you - which it really should NOT do since it is a "unmanaged" relationship class. ... View more

You have several dup field names like generated_note_field_70.  You also have several using reserved words like label and final.  You also end some in _ which is not a good practice. Looks like you are not using the template is your biggest issue.  It will check for all of this for you and mark then in green for reserved. And in Red for dups.   I suggest you start with a brand new blank template and bring over each column - MAKING SURE to use Right click Paste Values.  This way the formulas in excel to check all this is not overwritten. Then all of this is easy to see.  You never want to mess up the template.  Not even sure how\why you did this. Hope that helps     ... View more

Please wrap text everywhere always!  Attribute table I'm looking at you.  But seriously just make it a standard habit. ... View more

You need to go into the AGOL item page for the feature service and delete it there. As far as order that is always a pain that Esri really needs to fix already.  If its a AGOL webmap then you can change it in the popup and it respects that - well sometimes. ... View more