AX1328
Add Identity Record command
Use the Add Identity Record command to create a new record in an identity table.
NOTE: If you want to create a new plan file in an on-demand file group (which also requires creating a new record in the identity table), then you should use the Add Plan File command instead. The Add Identity Record command only creates a record.
Can be used in
- Axiom forms
When the Add Identity Record command is selected from the Command Library as the shortcut target, it displays as command://AddIdentityRecord or command://AddIdentityRecordCommandAdapter (legacy syntax).
Shortcut parameters
This command uses the following shortcut parameters:
| Item | Description |
|---|---|
|
Identity Table |
The table in which you want to create a new record. You can select any reference table that has an identity column as the key column. |
|
Optional target cell for new record ID |
Optional. The target cell in the source file to place the ID of the new record after it has been created. For example: If a target cell is specified, then the source file will be calculated after the value is placed in the cell. |
|
Processing Step |
Specifies when the command will be executed during the form update process. By default, this is set to Form - After Updating Values, which means that the command will be performed in the Axiom form context, and after any changed values in the Axiom form have been submitted back to the source file. If desired, you can specify a different processing step for the command. For more information, see Timing of command execution and Axiom form update process. |
Column values
This command also supports defining Column Values. This section can be used to apply values to columns in the identity table when the new record is created. This section is required if the identity table contains any alternate key columns or validated columnsColumns that have been assigned a lookup column. The lookup column contains the set of allowed values for the validated column., because those columns must be populated with valid values when the new record is created. For example, if the target table has a validated column named Dept with an assigned lookup column of Dept.Dept, then you must specify a value for Dept when creating the new record.
NOTE: It is not possible to omit validated columns or leave them blank when using Add Identity Record, even if the validated columns have valid default values defined in the column properties.
To add a row to this section, click the plus icon 
. Enter the column name in the left hand box and enter the value in the right-hand box. As an alternative to "hard-coding" a value, you can instead read the value from the form source file by entering a cell reference in brackets, such as: [Report!A2].
Example shortcut properties for Add Identity Record
Visibility
In Axiom forms, the command used does not impact whether the button is visible or enabled.
Remarks
-
The user does not need to have any security access to the target table in order to create the record. It is assumed that if the user can access the form and perform the save, then the record should be created.
- This command is intended to be used in form dialogs, as part of customized solutions that require creating records in an identity table. It is not intended as a substitute for the Add Plan File command. If the target identity table is the plan code table for an on-demand file group, there must be a process in place to later create the plan files for the records created using this command.
