Use Case:
Users may encounter the following error when attempting to assign the Internal ID of a Matrix Subitem Record into another Custom Field using a Workflow:
Field 'internalid' Not Found
This occurs because the Internal ID field cannot be referenced directly in the workflow. Creating a custom formula field that stores the record ID allows the value to be used in workflows.
How It Works:
- Navigate to Customization > Lists, Records, & Fields > Item Fields > New
- Enter the following field details:
- Label: Enter a label
- Type: Select Free-Form Text
- Store Value: Remove the checkmark
3. On the Applies To tab and enable the following:
- Inventory Item: Check the box
- Non-Inventory Item: Check the box
- Assembly/Bill of Materials: Check the box
4. On the Validation & Defaulting tab:
- Check the Formula box
- In the Default Value field, enter: {id}
5. Click Save
Note:
The newly created Custom Field can now be used in a Workflow to assign the Internal ID of the Matrix Subitem Record to another Custom Field.