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 Features | Copies a feature when an attribute is updated to a specified value. |
| Create Linked Record | Creates a new record in a feature layer with a relationship to a table using a primary/foreign key relationship. |
| Create Perpendicular Line | Constructs a perpendicular line from the input point and an intersecting line. The line's length is specified by the Length parameter. |
| Create Perpendicular Line to Line | Constructs a perpendicular line from the input point to the nearest line. |
Copy Features
Copies a feature when an attribute is updated to a specified value.
To configure this method, populate the following in the DynamicValue table:
| Table Name | Field Name | Value Method | Value Info |
| Feature class from which features will be copied | Field to monitor for changes | COPY_FEATURE | Value|Target|{Template}|{Method}|{Field Pairs} |
Parameters
The method parameters are as follows:
| Parameter | Value | Description |
| Value | String or numeric value | Rule is triggered when this value is entered into the field of interest. |
| Target | Feature layer or feature class | Affected features are copied or moved to this feature layer. |
| Template (Optional) | Editing template | Editing template used to symbolize and attribute the copied or moved feature. The feature symbology will be updated when the edits are saved. |
| Method (Optional) | Copy | Copies features from original location to the target location, but does not delete original feature. Deleting or moving the feature is not supported. |
| Field Pairs (Optional) | String | Field map for transferring attribute values between the source and target features. Format: Source field-target field. |
Examples
Copies the current feature from the MasterStreets layer into the PropStreets layer when the STATUS field value is changed to Proposed:
- Table Name: MasterStreets
- Field Name: STATUS
- Value Info: Proposed|PropStreets
Copies the current feature from the wMain layer into the wAbandonedLine layer when the STATUS field value is changed to 0 (retired). When copying, the Abandoned Water Mains editing template is used for attributes and symbology. Map the source fields DIAMETER and MAT to DIAM and MATERIAL, respectively:
- Table Name: wMain
- Field Name: STATUS
- Value Info: 0|wAbandonedLine|Abandoned Water Mains|COPY|DIAMETER-DIAM,MAT-MATERIAL
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
Create Perpendicular Line
Constructs a perpendicular line from the input point and an intersecting line. The line's length is specified by the Length parameter.
To configure this method, populate the following in the DynamicValue table:
| Table Name | Field Name | Value Method | Value Info |
| Feature class | Blank or null | CREATE_PERP_LINE | Source|Length|Neighborhood|Snapping|Target|{Template} |
This rule can only be configured on point features.
Parameters
The method parameters are as follows:
| Parameter | Value | Description |
| Source | Line feature layer or feature class | Feature layer containing the existing line features. |
| Length | Field name or value | Field containing the length value for the line, or a single value to use for all features. |
| Neighborhood | Value | Maximum distance to search for nearest feature. |
| Snapping | True | Snap the new line to the existing line feature. |
| False | Do not snap the new line to the existing line feature. | |
| Target | Line feature layer or feature class | Feature layer to contain the new perpendicular lines. |
| Template (Optional) | Editing template | Editing template used to symbolize and attribute the new line feature. |
Examples
Creates a perpendicular line 100 units long starting at snapped point on the sewPipes layer within 5 units to the Tap feature. The new line is stored in the comPipes layer:
- Table Name: Taps
-
Field Name:
<Null> - Value Info: sewPipes|100|5|True|comPipes
Creates a perpendicular line 100 units long starting at Tap feature. The new line is perpendicular to the closest feature in the sewPipes layer within 5 units, but does not start on the snapped point, but the actual Tap feature. The new line is stored in the comPipes layer using the PerpLine edit template:
- Table Name: Taps
-
Field Name:
<Null> - Value Info: sewPipes|LINELENGTH|5|False|comPipes|PerpLine
Create Perpendicular Line to Line
Constructs a perpendicular line from the input point to the nearest line.
To configure this method, populate the following in the DynamicValue table:
| Table Name | Field Name | Value Method | Value Info |
| Feature class | Blank or null | CREATE_PERP_LINE_TO_LINE | Source|Neighborhood|Target|{Template} |
This rule can only be configured on point features.
Parameters
The method parameters are as follows:
| Parameter | Value | Description |
| Source | Line feature layer or feature class | Feature layer containing the existing line features. |
| Neighborhood | Value | Maximum distance to search for nearest feature. |
| Target | Line feature layer or feature class | Feature layer to contain the new perpendicular lines. |
| Template (Optional) | Editing template | Editing template used to symbolize and attribute the new line feature. |
Examples
Creates a perpendicular line from the wServiceConnection feature to the nearest line in the wMain layer within 100 units. The new line is stored in the wLateralLine layer:
- Table Name: wServiceConnection
-
Field Name:
<Null> - Value Info: wMain|100|wLateralLine
The new line is stored in the wLateralLine layer using the 2" Copper Commercial edit template:
- Table Name: wServiceConnection
-
Field Name:
<Null> - Value Info: wMain|100|wLateralLine|2" Copper Commercial