Select to view content in your preferred language

Field calc bar in attribute table

959
5
07-03-2014 08:48 AM
Status: In Product Plan
Labels (1)
FranzLeonardo
Frequent Contributor
It would be interesting if the attribute table, you can insert formulas like in Excel. 
 
It would also be important if you can update manually / automatically formulas. 
 

QGIS is on the right track.

Field calc bar in attribute table

 

5 Comments
by Anonymous User

How is this not part of ArcGIS, I am mystified.

Basically, exactly this.  Have formulas like Excel that automatically keep a field updated. It could be as simple as summing two other attributes, or averaging, or something complex, involving geometry, etc.  

So, basically Attribute Assistant. Except, easy to use. And also that continuously updates. From my understanding, Attribute Assistant only updates during an Edit session, drastically reducing usefulness.  

Now, it would be nice for geometry attributes especially.  For example, calculating Acres.  I can never trust a field with measurements for something, if it is very, very important. Because I never know the last time it was calculated. (related thread about storing geoprocessing/field calculator lineage in the metadata would be useful to that end but even still...may not be current enough).  So, you say, what about update frequency? What if it's SDE?  I guess just let us have an 'update frequency' parameter. Problem solved.

Right?  Esri - any plans?

DrewFlater
Status changed to: Under Consideration
 
DrewFlater

Refactoring the Calculate Field tool into a toolbar in the attribute table view is being researched for a near term release.

Attribute Rules provide a lot of the functionality described above for storing a calculation expression with a field and automatically performing the calculation on data changes. Learn more about calculation attribute rules here: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/calculation-attribute-rules... 

MargaretCrawford
Status changed to: In Product Plan
 
MargaretCrawford

This idea is in the product plan for the ArcGIS Pro 3.6 release! You can use the new Calculate Field Toolbar to make field calculations directly in the attribute table view. 
In the toolbar, you can specify the field you want to calculate on (e.g., POP_DENSITY below), the expression (!TOTAL_POP/!AREA_SQMILES!) then click Calculate to run the tool directly in the table view.

MargaretCrawford_0-1759176036790.png