There is a requirement to auto-populate the Location column present in the Item Sublist by sourcing the value of the Location Field in the Main Line of the record. To do this, we need to create a Workflow that will use the Set Field Value Workflow Action to set the value of the Location column. Kindly follow the steps below:
- Create a Workflow by navigating to Customization > Workflow > Workflows > New
- Name: Enter the Name of the Workflow
- Record Type: Select Transaction
- Sub Types: Select Sales Order
- Execute as Admin: Enter checkmark
- Initiation:
- Select Events Based
- Event Definition:
- Select On Create and On View or Update
- Sublist: Select Item
- Click New Sublist Group
- Double-click State 1
- Click Save
- Click Save
- Click the Add Icon beside Sublist Action Group
- Click Set Field Value
- Under Parameters, set up the following fields:
- Field: Select Location(Line)
- Select From Field
- Record(Join Field): Select Current Record
- Field: Select Location(Main)
- Click Save
The Set Field Value Action should look like this:
With the Setup above, the Location(Line) field will source the value in Location(Main) field after saving the record.
Let me know if you have questions.