RE: Can we cascade activity records based on status?
Hi,
I was stewing on this last night and thought of a no-code way to do this (well, you're not writing any custom code at least). You'll need to install Workflow Elements at https://KaskelaSolutions.com or the AppSource. It's free.
You'll need several workflows: a main workflow that runs on assign of account, and one workflow per type of activity you want to cascade (fax, email, etc). Set your cascading rules to none.
In the activity workflow, just update the current activity record's owner to the related Account's owner.
The main account workflow should run after the owner changes. You'll have one step per type of activity you want to cascade. The custom step you call is 'Query – Run Workflow on Results'. With this activity, you can pass in a query and a workflow and it'll run the workflow on those records. For the input parameters, set your workflow for type Appointment and pass in a query for related active appointments. The second step will be the workflow for Phone Call and query for related active phone calls, etc.
Here's the documentation on calling the custom activity, and how to limit your results to just the related records: kaskelasolutions.com/activity-run-workflow-on-query-results One caveat of this, I don't know if there's a limit to the number of workflows spawned so you may hit issues if you have a ton of related records to update. My guess is that there ought not be too many open activities though.
Hope this helps! I'd appreciate if you'd mark this as Answering your question.
Thanks,
Aiden
Share
Report
All responses (
Answers (
19,692
