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.
Is there a way this could be re-considered as new functionality. I would argue not that Attribute Rules have been released that this functionality is still needed in ArcGIS Pro. The scenario I have at the moment is data coming from a Feature Service from a 3rd party ArcGIS Server (but could be any other Feature Service source). It would be really nice to be able to add a Computed (Virtual) column that only exists within my ArcPro Map that would allow me to continue to use the feature service, but would allow me to add a column that the original data owner doesn't have a use for. As an example. I am working with some pipe data which has 3 columns, a Pipe Shape, Pipe Height and Pipe Width. For display purposes I would really like to calculate a Pipe Cross Sectional Area based on those 3 columns for display purposes as I would like to show larger pipes with different symbols. And yes I know I can do this by rendering the layer multiple times for each formula needed for the various Pipe Shapes, but that requires multiple calls to the service with multiple definition queries defined, which results in less than optimum performance, whereas if this Computed (Virtual) column functionality were possible, it would be a single trip to the service, with a calculation applied as the data is rendered for the map.
Is there a similar in ArcGIS Online (in a way it Google Spreadsheet does)? Arcade?
Retrieving data ...