Latest Contributions by NorthSouthGIS

When a layer has a hosted view, you cannot add new values to a list. You can't edit the schema of the original layer at all (which is understandable), but I need to be able to add new values. For example, I have a layer that stores all of the trees I manage. However, some trees are for a specific city while others are for another. I would like to be able to share a city's trees back with them through a hosted view. Then when I get a new client, I can add their name in the City field list and create a new hosted view.  Same for adding new fields - I would like to add a new field specific for that city. This way I can have a field crew managing trees around multiple cities but also share back to the city a dashboard showing progress. This is very important for my business workflow. Ultimately, I would like the ability to Add only to the schema when there is a hosted view.  ... View more

My asset layers, like utilities or leases, etc. have the same fields in them over and over to denote buildings related to the asset. The fields represent the building names and I am storing a boolean value in the fields (y/n). If an asset is associated with a building I place a 'y'. This is probably not ideal, but it is how it is being done. I want to show a list of buildings in the pop up so I put together this functional arcade script. Sharing it here for others that might find it helpful.      //Create list of fields that store Y/N for if a building is associated var building_flds = ['Str_100', 'Str_101', 'Str_102']; //If new building fields are added, then add them to this list var buildings = []; //If a building has been marked as Yes, then add the alias to a concatenated list for display in the popup for (var i in building_flds){ if ($feature[building_flds[i]] == 'Y') { var aArray = Schema($layer)["fields"]; for(var j in aArray) { var dict = aArray[j]; if (dict['name'] == building_flds[i]){ push(buildings,dict['alias']); }; }; } } iif (Count(buildings)==0,push(buildings,'<em>None</em>'),buildings) var Expression2 = concatenate(buildings, ", ")     ... View more

I have a table of related work history on a point asset layer. For each point representing an asset, there are multiple related records storing the work history. Here is the Arcade expression I used to display in the pop up.  Note: This only works right now when set up as an Arcade Expression content type, rather than an arcade expression referenced in a Text content type.   // Get the related work orders var includedFields = ['Type','completion_date','real_price']; var history = FeatureSetByRelationshipName($feature, 'relationshipName', includedFields); if (count(history) > 0){ // Get the schema of the WorkOrders table var woSchema = Schema(history); // Get the fields from the schema var fields = woSchema.fields; // Define an array to store the table headers var headers = []; // Loop through the fields and add a header to the array for each one for (var i in fields) { var field = fields[i]; if(Includes(includedFields, field.name)) { Push(headers,'<th style="border: 1px solid #ddd;padding: 8px;background-color: #eee;">' + field.alias + '</th>'); } } // Define the HTML table header row var headerRow = '<tr style="border: 1px solid #ddd;padding: 8px;">' + concatenate(headers) + '</tr>'; // Define an array to store the HTML table rows var rows = []; // Loop through each related work order and add an HTML table row to the array for (var i in history) { var wo = i; // Define an array to store the data for the current row var rowData = []; // Loop through the fields and add the value of each field to the rowData array for (var j in fields) { //Skip Object ID Field if(fields[j].alias != 'OBJECTID_1') { Push(rowData, '<td style="border: 1px solid #ddd;padding: 8px;">' + wo[fields[j].name] + '</td>'); } } // Concatenate the rowData array into a string with table data tags var row = '<tr style="border: 1px solid #ddd;padding: 8px;">' + concatenate(rowData) + '</tr>'; // Push the resulting string into the rows array push(rows, row); } // Define the HTML table using the header row and the rows array var table = '<p><h3>Work History</h3></p><div><table style="font-family: arial, sans-serif;border-collapse: collapse;text-align: left;">' + headerRow + concatenate(rows) + '</table></div>'; // Return the HTML table return { type : 'text', text : table //this property supports html tags } //return table; } else { return { type : 'text', text : '<p><h3>Work History</h3></p><p>No related work history</p>' //this property supports html tags } } ... View more