There are instances where users wanted to source a value from a Checkbox of an Invoice record to its related Sales Order record. Since we cannot select Invoice under the Sourcing & Filtering subtab of a Custom Field checkbox, we can have a workaround that uses a Saved Search and Workflow. To do this, we need to create a Saved Search first.
- Navigate to Reports > Saved Searches > All Saved Searches > New
- Search Title: Enter Title
- Click Transaction
- Click Criteria
- Click Standard
- Set up the fields below:
After saving the Saved Search, we can now create the Workflow. Kindly follow the steps below:
- Navigate to Customization > Workflow > Workflows > New
- Basic Information:
- Name: Enter Name
- Record Type: Select Transaction
- Sub Types: Select Sales Order
- Execute As Admin: Enter Checkmark
- Event Definition:
- On Create: Enter Checkmark
- On View or Update: Enter Checkmark
- Click Save
- Click State 1
- Click New Action
- Click Set Field Value
- Trigger On: Select After Record Submit
- Condition:
- Saved Search Condition: Select the Saved Search created in Step 1
- Parameters:
- Field: Select the Custom Field Checkbox
- Value: Select Static Value
- Checked: Enter Checkmark
- Click Save
Let us know if you have other workarounds that we can use for this one!