By using an Event Based Workflows, users need to edit and save a Record in order to execute the Workflow. To avoid this, users have an option to use a Scheduled Workflow to execute the Workflow without Editing or Saving a record. The Workflow will run continuously based on a scheduled set by the user.
In this sample scenario, a user needs to update a Custom Field if the Sales Order has reached its Approval Status is Approved. Kindly follow the steps below to create Scheduled Workflow that will update the record:
Create a Saved Search that will identify the Approved records
- Navigate to Reports > Saved Searches > All Saved Searches > New
- Click Transaction
- Search Title: Enter Title of the Saved Search
- Click Criteria
- Filter: Type
- Description: is Invoice
- Filter: Approval Status
- Description: is Approved
- Click Results
- Click Remove all
- Click Columns
- Field: Select the Custom Field that needs to be updated
- Summary Type: Select Maximum
- Click Available Filters
- Filter: Select Internal ID
- Click Save
Create a Scheduled Workflow
- Create a Workflow by navigating to Customization > Workflow > Workflows > New
- Name: Enter the Name of the Workflow
- Record Type: Select Transaction
- Sub Types: Select Invoice
- Execute as Admin: Enter checkmark
- Release Status: Select Testing (If the Workflow is feasible on your end, change the Release status to Released)
- Initiation:
- Select Scheduled
- Schedule:
- Saved Search Filter: Select the created Saved Search in Step 1
- Frequency: Select the preferred Frequency (in this scenario, Every 30 minutes was used)
- Click Save
- Click State 1
- Click New Action
- Click Set Field Value
- Trigger On: Entry
- Parameters:
- Select the Custom Field
- Under Value, enter the preferred value for the field
- Click Save
With the setup above, the Scheduled Workflow will run Every 30 minutes, which is the selected Frequency of the Workflow. The Scheduled Workflow will only work for Approved Invoice records, since it is the Criteria of the applied Saved Search.
To our other members that have some useful tips about using Scheduled Workflows, feel free to share it in our community!