Latest Contributions by JustinWolff

‎11-06-2025

Thank you Shengdi, that got me pointed in the right direction. Now to figure out formatting bold/italic based on the conditions...

‎11-04-2025

In ArcGIS Online, I have a Filter widget applied to some polygons representing project areas. I have a Text widget configured to dynamically display the name of the project. When no filter is applied (ALL projects are visible) I would like the dynamic text to display something like 'Select a Filter' or just appear blank or something - right now it always shows the first project record as a default when no project is selected in the filter. I think this can be accomplished with a text widget arcade expression but I'm not sure how to put it together. I've tried the 'View for empty selection' of the data source and switching 'Default' and 'Selected features' in the text widget and dynamic content properties but nothing changes. Thanks. The Arcade script for the Text widget looks like this: // Documentation: https://arcg.is/18ejKn3 function getFilteredFeatureSet(ds) { var result = ds.layer; var queryParams = ds.queryParams; if (!IsEmpty(queryParams.where)) { result = Filter(result, queryParams.where); } if (!IsEmpty(queryParams.geometry)) { result = Intersects(result, queryParams.geometry); } return result; } // Projects // The filteredFeatureSet1 has already been filtered using spatial filters and attribute filters. // var filteredFeatureSet1 = getFilteredFeatureSet($dataSources["dataSource_2-1989fddf1cf-layer-14"]); // selectedFeatures1 is the selection view of data source. // var selectedFeatures1 = $dataSources["dataSource_2-1989fddf1cf-layer-14"].selectedFeatures; // NOTE: When using selectedFeatures, cases with no selected features must be handled manually. return { value: '', text: { // size: 14, // color: 'rgb(0, 0, 255)', // bold: true, // italic: false, // underline: false, // strike: false }, };

‎08-06-2025

Thank you, Laura, I think that's the route I'm going to have to go.

‎08-04-2025

We have a hosted feature layer in AGO containing one (1) polygon feature class, and three (3) tables with multiple relationships: Tracts (Polygon) -> 1:Many -> Tract Notes (Table), relationship fields OBJECTID -> TractGUID Project (Table) -> 1:Many -> ProjectNotes (Table), relationship fields OBJECTID -> ProjectGUID Project (Table) -> 1:Many -> Tracts (Polygon), relationship fields OBJECTID -> ProjectGUID So one Tract may have multiple TractNotes records, one Project may have multiple ProjectNotes records, and one Project may have multiple Tract features. In Experience Builder, I would like to filter the Project table on the 'Project Name' field, and have it also work against the Tracts polygons in the map. Ideall, the Edit widgets configured to add records to Tracts, TractNotes and ProjectNotes would default the ProjectGUID values in Tracts and ProjectNotes. We are currently using a Survey widget to add polygon features, pulling geometry and some attributes from another map layer, and an Edit widget to add records to the TractNotes and ProjectNotes tables. I'm hung up on the initial Project filter - how do I configure a Filter to work against related records? Based on what I'm finding elsewhere in Community this may not be an option? Thanks

‎03-06-2025

Thanks Glen, that works well. As a follow-on, my test data only has one layer [0]. I'll have other situations where there are multiple sublayers. I'm a bit confused how to use gis.content to return the separate layers. Any help pointing me in the right direction is appreciated. Thanks again.

‎03-05-2025

and if I use field_to_add outside of any brackets it completes without any errors but doesn't add any fields feature_layer.manager.add_to_definition({"fields":field_to_add}) with the print statements as they currently are: Field 'newfield1' will be added. Field 'newfield2' will be added. Field 'newfield3' will be added. [{'name': 'newfield1', 'alias': 'New Field 1', 'type': 'esriFieldTypeInteger'}, {'name': 'newfield2', 'alias': 'New Field 2', 'type': 'esriFieldtypeInteger'}, {'name': 'newfield3', 'alias': 'New Field 3', 'type': 'esriFieldtypeInteger'}] {'name': 'newfield1', 'alias': 'New Field 1', 'type': 'esriFieldTypeInteger'} {'name': 'newfield2', 'alias': 'New Field 2', 'type': 'esriFieldtypeInteger'} {'name': 'newfield3', 'alias': 'New Field 3', 'type': 'esriFieldtypeInteger'} Am I missing something in the field definition?

‎03-05-2025

That gives the same error, except it doesn't add the first field, when left out of brackets: feature_layer.manager.add_to_definition({"fields":fields_to_add_list}) And does not create the first field when placed in brackets: feature_layer.manager.add_to_definition({"fields":[fields_to_add_list]}) but gives a bit different error: Exception: Unable to add feature service layer definition. Invalid definition for System.Collections.Generic.List`1[ESRI.ArcGIS.SDS.FieldInfo] Unable to cast object of type 'System.Object[]' to type 'System.Collections.Generic.IDictionary`2[System.String,System.Object]'. (Error Code: 400)

‎03-05-2025

I'm attempting to add new fields to a hosted feature layer if they don't already exist. Currently my code will add the first field in the list (dictionary), but then fails with the message: Exception: Unable to add feature service layer definition. Invalid definition for System.Collections.Generic.List`1[ESRI.ArcGIS.SDS.FieldInfo] Object reference not set to an instance of an object. (Error Code: 400) If it's run a second time it does not add the second field and gives the same error. I added the sleep thinking it may help but it doesn't. Any suggestions appreciated. Thanks. from arcgis.gis import GIS from arcgis.features import FeatureLayer import time username = '' password = '' gis = GIS("<url>", username, password, verify_cert=False) item_id = "<item_id>" feature_layer_item = gis.content.get(item_id) feature_layer = FeatureLayer.fromitem(feature_layer_item) #feature_layer = FeatureLayer.fromitem(feature_url) fields = feature_layer.properties.fields existing_field_names = [field.name for field in fields] new_fields = [ {"name":"newfield1", "alias": "New Field 1","type": "esriFieldTypeInteger"}, {"name":"newfield2", "alias": "New Field 2","type":"esriFieldtypeInteger"}, {"name":"newfield3", "alias": "New Field 3","type":"esriFieldtypeInteger"} ] fields_to_add_list = [] # this is named 'list' but is actually a dictionary for new_field in new_fields: if new_field["name"] not in existing_field_names: fields_to_add_list.append(new_field) print(f"Field '{new_field['name']}' will be added.") else: print(f"Field '{new_field['name']}' already exists.") for field_to_add in fields_to_add_list: print(field_to_add) feature_layer.manager.add_to_definition({"fields":[field_to_add]}) time.sleep(20)

‎02-04-2025

Thanks @AndreasHall - I've have an indicator to give me total attachments (see below), but I just need a list with a count for every feature/record. I'm drawing a blank today... var portal = Portal('https://------.maps.arcgis.com'); var assets = FeatureSetByPortalItem( portal, 'item_id', 0, ['*'], false ) var photo_count = 0 for(var feat in assets){ photo_count += Count(Attachments(feat)) } return photo_count

‎02-03-2025

I've discovered the hard way that the Arcade function Count(Attachments($feature)) cannot be used in a Field Maps Calculated Expression to automatically update and return a count of the attachments, because the attachments can't be counted until the record is submitted. Fine. Is there a way to display the number of attachments per record in a Dashboard List? I cannot figure out how to make this work. I'm doing all of this in AGO using hosted data. Any chance @jcarlson has done something like this? Thanks

‎11-12-2024

Thank you erica_poisson. I am attempting to use this in a survey to collect new features for an internal 'GeoGuessr' style game for GIS Day. When I enter a duplicate value, it does not identify it as being duplicate until the very end of the survey, not at the beginning as anticipated. Everything else is working, but it doesn't provide an error message until the end of the survey. Attached is a sanitized .xlsx to remove our URLs/IDs, etc. and a screenshot of the data for reference and the messages we receive during (after!) entry. I think I'm missing something small/basic somewhere... Thanks for any help! /* * JavaScript functions for Survey123 */ function returnFeatures(map_user, token, debugmode) { // Output value. Initially set to an empty string (XLSForm null) let outValue = ""; let layerURL = "https://<our service url>"; let response =""; // Set up query parameters let f = "f=json"; let where = `where=map_user='${map_user}'`; let outFields = "outFields=*"; let returnGeometry = "returnGeometry=false"; let returnCount = "returnCount=1"; let parameters = [f,where,outFields,returnGeometry,returnCount].join("&"); let url = `${layerURL}/query?${parameters}`; if (token){ url = url + "&token=" + token; } // Create the request object let xhr = new XMLHttpRequest(); // Make the request. Note the 3rd parameter, which makes this a synchronous request xhr.open("GET", url, false); xhr.send(); // Process the result if (xhr.readyState === xhr.DONE) { if (xhr.status !== 200) { // The http request did not succeed return "bad request: " + url } else { // Parse the response into an object response = JSON.parse(xhr.responseText); if (response.error) { return (debugmode? JSON.stringify(response.error):""); } else { if (response.features[0]) { return "That Player name is already taken, please enter a different name." //JSON.stringify(response.features[0]); } else { if (map_user !== "") { return "Player name entered."} //(debugmode? "No Features Found":""); } } } } }

‎06-12-2023

Is there a way to create a point symbol callout with a leader tangent to the point symbol, in my case a circle? In the attached image I'd like to display the callout leader like the markup in red. Thanks

‎06-12-2023

jschuckert - This was a while ago, and under a previous employer, but I believe I used the output .csv from the code above as input to arcpy.conversion.TableToTable, and specified a field map which contained all the necessary fields. -Justin

‎05-01-2023

Thanks GK. I was trying this earlier, but $map isn't recognized, and I'm not sure how to define it as a variable, if it's possible. I no longer have access to ArcGIS Assistant but would be curious to look at the .json of the Dashboard List element in ArcGIS Assistant Beta. Maybe that would have a clue how a 'default' Dashboard element is referencing the $map.

‎05-01-2023

Hello, I have an Arcade expression put together for a Dashboard List, using FeatureSetByPortalItem to reference a Portal feature service. The purpose is to create a list that sorts tracts by the latest date in any of three date type fields. Because this is directly referencing the source feature service, and not the web map in the Dashboard, several Actions are unavailable, including 'Show Popup' and 'Zoom'. Instead of using FeatureSetByPortalItem(<Portal>,<Portal Item ID>), is there a way to reference the layer from a web map, or otherwise define the popup so that can be displayed as an action? Below is the Expression referencing the Portal feature service item and layer directly. I just can't use this to zoom or display a pop-up. var portal = Portal(<portal>); var fs = FeatureSetByPortalItem(portal,"<id>",<layer>,['*'],false); var date_dict = { fields: [{name: "MaxDate", type: "esriFieldTypeString"},{name: "Tract", type: "esriFieldTypeString"}], geometryType: "esriGeometryPolygon", features: [], }; var acq_sql = "Appraisal IS NOT NULL and Survey IS NOT NULL and Opinion IS NOT NULL"; var acq_filter = Filter(fs, acq_sql); for (var feature in acq_filter){ var max_appr = Number(feature['Appraisal']) var max_surv = Number(feature['Survey']) var max_titl = Number(feature['Opinion']) var tract_num = (feature['tracts']) var max_date = Text(Max(max_appr, max_surv, max_titl)); Push(date_dict.features, {"attributes": {"MaxDate": max_date,"Tract": tract_num},geometry: Geometry(feature)}) }; var newFeature = FeatureSet(Text(date_dict)); var orderFS = OrderBy(newFeature, 'MaxDate desc') return orderFS A temporary workaround I have set is an action from this data expression list to filter another list using the same filter criteria but sorted by 'tracts'. Users have to click twice, but that's not a huge deal - would be nice to be one click though.

Online Status	Offline
Date Last Visited	yesterday

My Ideas

Latest Contributions by JustinWolff

Re: Display no value for Dynamic Text when no filter applied

Display no value for Dynamic Text when no filter applied

Re: Filter map layer and related tables

Filter map layer and related tables

Re: Adding multiple fields to hosted feature layer

Re: Adding multiple fields to hosted feature layer

Re: Adding multiple fields to hosted feature layer

Adding multiple fields to hosted feature layer

Re: Show Attachment Count per Record in Dashboard List

Show Attachment Count per Record in Dashboard List

Re: Stop Survey123 Entry if Duplicate Project ID Entered

Tangent point symbol callout leader?

Re: replace commas from .csv

Re: Arcade expression Feature Set from Map

Arcade expression Feature Set from Map

Re: replace commas from .csv

MAX Date GROUP BY id in Model Builder

Re: error handling and cursors

Re: arcpy.da.UpdateCursor too few parameters

Re: new users unable to login to Portal after 10.7...