The Value Method field in the DynamicValue table defines the actions that occur when the Attribute Assistant is enabled and features are modified or created in ArcMap. Four fields in the DynamicValue table (Value Method, Table Name, Field Name, and Value Info) must be configured to use an Attribute Assistant method. The remaining fields define when the Attribute Assistant method should be applied.
The following four Attribute Assistant methods can be configured in your DynamicValue table:
Method | Description |
Copy Linked Record | Updates an attribute of a feature with a value from a related table. |
Create Linked Record | Creates a new record in a feature layer with a relationship to a table using a primary/foreign key relationship. |
Link Table Asset | Updates a field in the table or layer with a value from a selected feature. |
Update Linked Record | Finds the related records in another table or layer and updates a field in those records. |
Copy Linked Record
Updates an attribute of a feature with a value from a related table.
To configure this method, populate the following in the DynamicValue table:
Table Name | Field Name | Value Method | Value Info |
Feature class to which value will be copied to from the source or related table | Field to store the copied value | COPY_LINKED_RECORD | Source|Source Field|Primary Key|Foreign Key |
Parameters
The method parameters are as follows:
Parameter | Value | Description |
Source | Table | Related table that a value will be copied from and placed in the triggering layer |
Source Field | Field name | Source table field containing the values to copy and place in the triggering field |
Primary Key | Field name | Field in the Triggering layer that is used to identify a feature in the source or related table |
Foreign Key | Field name | Field in the source table with a matching ID to the triggering layers ID in the Primary Key field |
Source | Field name | Numeric field to summarize; multiple fields can be specified as a comma-delimited list (for example, field1,field2,field3 ) |
Statistic | Min | Minimum value |
Max | Maximum value | |
Sum | Sum of all values | |
Mean | Mean value | |
Concat | Delimited string containing all the values with duplicates removed. | |
Delimiter (Optional) | Any character except | is valid; the default is , . |
Characters used as delimiters; only used when the statistic is Concat. |
SortOrder (Optional) | ASC | Sort the statistics in ascending order; only used when the statistic is Concat. |
DESC | Sort the statistics in descending order; only used when the statistic is Concat. |
Examples
Populates the ADDRESS field in the Parcels layer with the FNAME field in the Parcels_AddressPoints related table. The relationship was created with a primary key on the ParcelID field in Parcels and a foreign key on the PID field in AddressPoints:
- Table Name: Parcels
- Field Name: ADDRESS
- Value Info: Parcels_AddressPoints|FNAME|ParcelID|PID
Create Linked Record
Creates a new record in a feature layer with a relationship to a table using a primary/foreign key relationship.
To configure this method, populate the following in the DynamicValue table:
Table Name | Field Name | Value Method | Value Info |
Table or feature class | Field to monitor for changes (Optional) | CREATE_LINKED_RECORD | Target|Target Fields|Source Fields|Primary Key|Foreign Key|{Commit} |
Parameters
The method parameters are as follows:
Parameter | Value | Description |
Target | Table or feature layer | Related table |
Target Fields | Field names | List of fields the related record layer/table to which values will be copied. The list of field names are in the format field1,field2,etc. List must have the same number of values as the Source Fields. |
Source Fields | Field name | List of fields in the source record to copy to the target related record. The list of field names are in the format field1,field2,etc. List must have the same number of values as the Target Fields. |
Primary Key | Field name | Source features identifier used in the related table |
Foreign Key | Field name | Related table field with values corresponding to the source feature identifiers |
Commit (Optional) | Field name, Number of records to create or a Boolean for Commit | In the current release of this rule, the parameter is being used for two options. If you want to generate a number of related records, specify the field name that has a value with the number of records to create or specify the number of records to create. For the Commit option, by default, the new record is not stored in the geodatabase until all the rules for the edited feature are processed. If [TRUE], the data is stored so that any following rules can be processed. |
Examples
Generates a single record in the Related layer by storing the FACILITYID field of the Parent feature in the FACILITYKEY field of the Related layer. The OWNER field in the Parent layer will be copied to the RELOWNER field in the Related layer:
- Table Name: Parent
-
Field Name:
<Null>
- Value Info: Related|OWNER|RELOWNER|FACILITYID|FACILITYKEY
Generates ten records in the Related layer. The OWNER and COLOR fields in the Parent layer will be copied to the RELOWNER and COLOR fields, respectively, in the Related layer:
- Table Name: Parent
-
Field Name:
<Null>
- Value Info: Related|OWNER,COLOR|RELOWNER,COLOR|FACILITYID|FACILITYKEY|10
Generates a dynamic number of records in the Related layer. The number of records is defined by the RELCOUNT field in the Parent layer:
- Table Name: Parent
-
Field Name:
<Null>
- Value Info: Related|OWNER|RELOWNER|FACILITYID|FACILITYKEY|RELCOUNT
Generates a single record in the Related layer. This record is stored immediately so that it can be accessed by other Attribute Assistant rules:
- Table Name: Parent
-
Field Name:
<Null>
- Value Info: Related|OWNER|RELOWNER|FACILITYID|FACILITYKEY|TRUE
Link Table Asset
Updates a field in the table or layer with a value from a selected feature.
To configure this method, populate the following in the DynamicValue table:
Table Name | Field Name | Value Method | Value Info |
Table or feature class | The field to update. List multiple fields in the format field1,field2,etc. | LINK_TABLE_ASSET | Source|Source Field |
This rule can be configured on any field type.
Parameters
The method parameters are as follows:
Parameter | Value | Description |
Source | Layer or feature class | The feature layer or feature class from which the values will be copied. |
Source Field | Field name | The field to copy; if there are multiple fields, list them in the format field1,field2,etc. The number of fields here must match the number of fields listed in Field Name. |
Examples
Copies the value of the FACILITYID field of the selected feature in the wMain layer to the FID field of the current feature in the in the wHydrant layer:
- Table Name: wHydrant
- Field Name: FID
- Value Info: wMain|FACILITYID
Copies the values from the ADDRESS and OWNER fields into the HOUSEADDRESS and HOUSEOWNER fields, respectively:
- Table Name: proposedSites
- Field Name: HOUSEADDRESS,HOUSEOWNER
- Value Info: parcels|ADDRESS,OWNER
Update Linked Record
Finds the related records in another table or layer and updates a field in those records.
To configure this method, populate the following in the DynamicValue table:
Table Name | Field Name | Value Method | Value Info |
Table or feature class to monitor for changes | The field to monitor and copy | UPDATE_LINKED_RECORD | Target|Target Field|Primary Key|Foreign Key |
This rule can be configured on any field type. This method cannot be triggered from the Attribute Assistant toolbar.
Parameters
The method parameters are as follows:
Parameter | Value | Description |
Target | Layer or feature class | Related table into which the values will be copied. |
Target Field | Field name | The field to populate with the copied record. |
Primary Key | Field name | Source features identifier used in the related table. |
Foreign Key | Field name | Related table field corresponding to the source features. |
Examples
Monitors the ADDRESS field in the Parcels layer for changes; when this value is changed, copy it to the FNAME field in the Parcels_AddressPoints related table. The relationship was created with a primary key on the ParcelID field in Parcels and a foreign key on the PID field in AddressPoints:
- Table Name: Parcels
- Field Name: ADDRESS
- Value Info: Parcels_AddressPoints|FNAME|ParcelID|PID