Latest Contributions by RhettZufelt

You didn't say what format the data is in, or what 'type' of selections you are making. But, I have some people that want a table with all the attributes from several feature class layers features that have been added in the last month. So, since my data is in SQL Server, I just connected several workbooks in an Excel spreadsheet to the SQL tables for the feature classes I need.  Then, put custom filter on each table that only shows values for the next month. Then, all they have to do is open the Excel spreadsheet to refresh the data, and look at the worksheets as needed. So, if your data is Enterprise, and your selections are by code (not manual), this could be a potential solution for you. R_ ... View more

are you needing an attribute rule, or just looking for a way to concatenate? Easiest way is probably with the Field Calculator.  Open the attribute table in Pro, enable editing, right click on the field you want to update, select Calculate Field  (or use Claculate Field GP Tool), then set expression to:   !field1! + " " + !field2!   will concatenate the two field values into one field with a space separating them.  (remove the + " " to get rid of the space) If you are wanting this 'automatically' when you add/edit the data, then an attribute rule is probably what you are after. R_ ... View more

I thought you were mainly focused on symbology, so offered a suggestion that didn't take any 'calculations' and updates the symbology when you change the value(s), but also doesn't update any fields either. Re-reading your post, it sounds like you want to update that field for ALL features in the featureclass so that any that match the past 30 days, it sets Status field to Re-inspect. In a similar inspection process, since is Enterprise data, I set up an update trigger on the table in SQL Server Management Studio that calculates the value of the "Status" field each time there is an update made to that table.  Since this fires on the backend in SQL Server, the update is pretty much instantaneous any time you make changes to the table.  If you also allow adds to the data in the field, you could fire the trigger on update and add.  The same script could be used to not only update the Status field, but the last inspected and next inspection fields as well. If 'waiting' for a change isn't frequent enough of an update, you could also copy the similar SQL to a scheduled job that updates daily, hourly, whatever frequency you need. I use this on non-versioned and versioned - 'moving edits to base' with no issues.  Not sure if doing it this way would bloat out the versioning tables on full versioned data or not.  Would probably want to test that out if using full versioning. If this isn't an option, I think you will be needing a scheduled GP Tool, python/notebook script as mentioned above. R_ ... View more

Looking into this some more, I am seeing the same thing, but not sure why. However, after the first one, it is returning data, but ONLY the system managed fields (Creator, GlobalID, OBJECTID, etc.) that I don't have in the excludeFields list. So, for whatever reason, it only system-maintained fields after the initial popup until I select another layer then switch back. I have also noticed that it only behaves this way when I have editing capabilities.  If I open share this and open it with just read, then I never get the full popup, just the non-excluded system fields... Maybe this will help someone figure out why? R_   ... View more

Well, sounds like you added a field, not a row.  Not sure what happened as I generally avoid Shapefiles whenever possible.  I generally convert to featureclass as @DanPatterson commented above. Depending on where it is stored, and the setting on that computer,  sometimes you can right click on the folder containing the shapefile (in windows explorer) and get properties.  If it is enabled, you will see a Previous Versions tab and can copy 'backups' from date/times available in the previous version tab.  If so, remember a shapefile is a group of files all with the same name but different extensions and you need to copy all of them for a 'valid' shapefile. Also, have you tried the Repair Geometry GP Tool?  Sometimes this can fix issues like this. If all else fails, though probably won't get you anywhere, I would open the shapefilename.dbf file in Excel and make sure there aren't any weird/invalid characters, values, etc. in there, and if so, remove/replace them, save the dbf, and try the shapefile again.  Of course, would only test this on a copy of the data, just in case... R_   ... View more

Kind of depends on what the potential values of the Status field are. If the values of the Status field are all based on the date since last, then one option would be to just use the Arcade in the symbology based on the Next InspectionDate field and current date.  WHEN the date difference is less than 30 days, symbolize it one color, if date difference is more than 30 days, symbolize it a different color. This way it would all be handled by symbology, and there would be no need for scripts/att rules, etc. to update values in a field. This would also work regardless of what software was used to make the updates. R_ ... View more

Is there anything under the Attribute Expressions section: R_ ... View more

I don't really see any difference in performance using this vs. the Field List but I only have 33 fields and 1100 features. I'm pretty new to this kind of Arcade myself, but saw this post and had the need to incorporate it into some existing maps. However, I do not see a way to have it non alphabetical.  The script seems to be returning the Fields in the right order, but they get automagically re-ordered in the popup. Hopefully @gis_KIWI4 or someone with a better understanding of this can figure out a way. If I get a chance in the future, may dive into this more. R_ ... View more

To get this to work, I had to remove the field list, then add a new Arcade content and embed the code there. Then it will draw the popup table correctly.   R_     ... View more

Did you use the Data Design Fields context menu or the Add Field GP Tool to add the field? That error message almost sounds like you added a row to the table without geometry, not a new field. R_ ... View more

Sure, match (or make similar to the one that served us so well in ArcMap for so long. At least give us the ability to return all results and show what layer and Field the result was found in, as well as letting us sort by the Value/Layer/Field results: And a way to search all 'In" layers for value in specific field: And, no need to add a 'not called for field' in the results and rename it to something that doesn't make sense ( below from Pro, I do NOT have a field named "Description" in any of the datasets, why oh why does it list one?) If you are putting a value there that wasn't requested in the search, at least label it with the proper Field name, not the value of some other cryptic field set in the Display options for that particular layer.... R_ ... View more

You can use the Locate tool and do a Layer Search:  (With display field set)   You can have it only select certain fields BUT, only if you search One FC at a time (see the menu of CleanOut under Seach in layer above). It will search all layers and all fields using the Search in all layers option, and you can change to detailed view to see what FC/field it was found in:  (default display field) However, it can be a bit confusing.  If you see above, I searched for H1-021 which should be in AsBuilt# or Project field, but it is reporting some other value in the Description (K-891). Turns out the "Description" is the display field for that layer, so if you set the Display field to the one you want to search: then the results are easier to make sense of. (first image above is with Display field set, second one shows default behavior) You can then select what you want in the results pane and right click, add to selection as well. I see that in earlier versions (3.1.3) the "Match exact" doesn't' work and it does a "Match any part" always, however, in 3.2.1 that seems to have been fixed. I also miss the good old days of ArcMap where tools like this actually functioned as expected. R_ ... View more