Latest Contributions by deleted-user-8TVt6oc0ewsX

I have a spreadsheet that has 2 MS SQL Server Queries with about 2000 records each.  The queries run quickly and the map I created plots the points quickly.  If I save the spreadsheet and then reopen and refresh the queries each query takes up to 2 minutes to run and update the map (I have "Refresh data when opening the file" toggled ON).  I found a python script to run REFRESH ALL to refresh the data offline.  However when I then try to open the spreadsheet after running the script I get an immediate error, "An error has occurred" and the map doesn't open.  I usually saw this error if I did not have "Enable background refresh" enabled for the query.  I think the error has to do with verifying sign-in to AGOL) My python updating would solve my problem if I can get past this error (I would disable the "Refresh data when opening the file). Does anyone have a suggestion to either fix the problem or improve performance of refreshing a query to ensure users see the latest data when they open the spreadsheet. ... View more

Currently when you click on "Show only selected rows", the tool just adjusts column heights.  Ideally this tool would have option or by default, apply a FILTER to the column.  This would allow you to select the rows in the spreadsheet.  Currently if you try just to select and copy the highlighted rows Excel selects the ENTIRE column (all rows) for a cut-and-paste.  If a Filter  was applied the cut-and-paste would only operate on the selected rows.   ... View more

When You click on "Export Selected Rows" in MS Excel you have no idea of the progress of the task.  All you do is click on the took again and you get a message,  There needs to be some kind of progress bar for this.  This often takes a very log time to operate. ... View more

When using Locate Features Along Routes I would want an option to MATCH Route_ID input to Route_ID output to force the measure to appear on a particular route.  I want ROUTE to be used to match input/output records only have the tool compute measures only.  I don't want to tool to search for the closest route.  I want to explicitly define the route to use.  This is the most common use case.  Data collectors know the route.  The primary use of this tool for us is to generate measures.  Without this option we risk matching to wrong route or have no data returned at all. ... View more

I am looking for a workflow where I filter 1 or more layers using one of the query, filter attribute filter tools in WebAppBulder and then when I go to the screener tool I want the screener tool to HONOR any existing filters on a layer.  As an option I would be happy if the screener tool would allow me to apply an ATTRIBUTE filter within the screener tool for a particular layer before printing.   I would also want to sort on an attribute before printing. ... View more

I have 2 date fields and want to filter/display on number of days elapsed (Date2 - Date1).  Is there any way to perform a calculation to be used for a "Date Selector", "Indicator", or "List"?  Is there any part of a Dashboard where a field calculation can be used? ... View more

My dispatcher map has 4000 signs grouped into 160 routes with 24 signs linked to a route.  When I preform a search on a route-id, the map only returns 12 of the 24 signs.  The same query works fine in the Map Layer Filter and all other queries.  In the example below I am search on "Driver_6".  You can clearly see many (12) features that are labeled, "Driver_6", where not included in the results (they don't have the blue box). This happens for all routes.  Where can this be controlled/set?  Is there a 12 record return limit on "Locate" results? ... View more

We want to store SIGNs at an offset off the roadway.  Things are fine when building the event layer but after we edit a sign using RCE the sign snaps back to the road.  Does anyone know how to PRESERVE the offset after an edit? ... View more

I am trying to use a custom tile layer as a map backdrop - ONLINE use.  I cannot get it to work.  I have edited the *.info file and placed the URL but with no success.  I published the layer using ArcGIS Pro.  The layer displays in AGOL Maps.  Here is my layer... https://tiles.arcgis.com/tiles/UTBp78iglGpbqp1B/arcgis/rest/services/slrrppc_tile/MapServer 1) The documentation below shows some examples with various stuff after the /tile/  is this important? ${z}/${y}/${x}   - is this a "format" where you substitute your values or is this a sort of wild card?.  Is this required? The documentation shows... Esri default basemap—http://services.arcgisonline.com/ArcGIS/rest/services/World_Topo_Map/MapServer/tile/{{z}}/{{y}}/{{x}}.png Uses DOUBLE {{}} - is this a typo?  If not, what do double brackets mean? 2) Is the "tile template URL" format documented anywhere? 3) Are there any map project requirements? 4) Do I need the "*.png" piece? I tried... https://tiles.arcgis.com/tiles/UTBp78iglGpbqp1B/arcgis/rest/services/slrrppc_tile/MapServer/${z}/${y}/${x}.png https://tiles.arcgis.com/tiles/UTBp78iglGpbqp1B/arcgis/rest/services/slrrppc_tile/MapServer/${z}/${y}/${x} I tried forcing a single tile... https://tiles.arcgis.com/tiles/UTBp78iglGpbqp1B/arcgis/rest/services/slrrppc_tile/MapServer/tile/11/828/390 https://doc.arcgis.com/en/survey123/desktop/create-surveys/includemap.htm ... View more

When creating a Dashboard it is often hard to accurately place widgets.  For example I have 5 indicators stacked.  I want them to appear the same size.  I have to "eyeball" this.  I would like the cursor XY to be exposed so I can accurately calculate position.  A GRID overlay, much like "GUIDES" appear in a serial chart, for the workspace would be also very helpful.  In the short-term just showing the XY of the cursor would be a huge help. ... View more