idea Table formatting based on a different definition Query in ArcGIS Pro Ideas

Table formatting based on a different definition Query

RobertBorchert — Wed, 05 Oct 2022 13:25:38 GMT

What I would like to see as part of a definition query is a separate query that will result in custom formatting of the attribute table.

As an example. I have a Look Up Table of Substations and busses for use in matching up Arc flash and grounding data. As new locations are added to the feed I need to update the LUT with a location number and the data source Join Field.

What I would like in the LUT after adding the new locations have those rows where the Location is Null in the join be highlighted a different color.

This way I can go through my LUT, which currently has 1200 entries, sort them Alphabetically based on the Name and easily see those without a Location number.

Yes, I could definition query out to only show those without a Location or Select by attributes.

Something like the below image. In this example I need to add BlackLake_12.47 to the LUT. It is actually the same location as BlackLakeD_69 but just a different voltage. All I would need to do is transcribe the Location number.

Re: Table formatting based on a different definition Query - Status changed to: Needs Clarification

KoryKramer — Thu, 28 Jul 2022 19:47:34 GMT

Thanks for submitting this idea @RobertBorchert I think we need some more info to better understand the request.

You refer to an image, but I don't see any image posted. Please add that.

Is the request really about definition queries or about conditional formatting in an attribute table? i.e. If <some condition> then format a cell a certain way? If so, I think that is captured in this idea https://community.esri.com/t5/arcgis-pro-ideas/conditional-formatting-in-attribute-table/idi-p/929898 Please review and provide clarifying details.

Thank you

Re: Table formatting based on a different definition Query

KoryKramer — Thu, 15 Sep 2022 17:47:12 GMT

Hi @RobertBorchert I wanted to check in with you again to see if you can provide any details per my above comment. Please let us know. Thanks!

Re: Table formatting based on a different definition Query - Status changed to: Closed

KoryKramer — Wed, 05 Oct 2022 13:25:17 GMT

Closing this pending clarification. We can reassess the idea once we have answers to the questions asked. Thank you!