Adding field with costumized formula that dynamicaly change the value based on the data entered on another fields. like in Excel
We had this functionality with Arc/Info's REDEFINE command.
See slide number 22 here:
REDEFINE let you pick out a column range from INFO's fixed width records, not exactly a formula, but related.
Please add this functionality so we can symbolize based on dynamically calculated fields. As an example, I have a point feature has 3 numeric attributes. A dynamic field should contain a formula like =(Field1+Field2)/Field3. This dynamic field could then be used to apply graduated symbols or thematic color ramps to the point feature. I know this can be done manually but the field must be re-calculated each time a new record is added or one of the attributes change.
Similarly, we need an Event Theme based on a formula, not just on given X and Y fields. Like, plot points based on X+2 and Y+3.
I voted for this, but I will point out that no database program that I know of does this directly in tables, only in query views, forms and reports. Potentially this can be done with a layer and table view since they are objects that sit on top of the table, but the table itself probably cannot have a calculated field like this in its schema, since that is not compliant with the databases ArcGIS uses (at least not all of them).
If you count Database triggers as a method for calculating a field in a database, then a work around in these cases where the fields can be stored in the table, you can use Attribute Assistant in the ArcMap Desktop environment to update the fields in response to geometry and/or other attribute edit events as well as user triggered events. There are a lot of methods available in Attribute Assistant. If you are not aware of Attribute Assistant, you owe it to yourself to check it out.
As Richard Fairhurst points out, this functionality is implemented in ArcMap through Attribute Assistant | ArcGIS Solutions
Attribute Rules will be coming to a future release of ArcGIS Pro to allow similar functionality.
Retrieving data ...