Skip to main content

How to Use Workflows to Bulk Update BD Rep Assignments Based on Referral Source Ownership (CRM)

How to use workflows to automatically assign BD representatives to opportunities based on the owner of their referral source. This is useful when you've imported large numbers of records without BD rep assignments and need to update them in bulk.

Before You Begin

  • You must have workflow creation permissions in your Dazos CRM

  • Ensure your opportunities have referral sources assigned (but are missing BD rep assignments)

  • Verify that referral sources have owners assigned to them

  • Consider excluding certain referral source types like 'Readmit' or 'Internet Search' from this process

Steps

  1. Navigate to Workflows: Go to your CRM settings and access the Workflows section.
    ​

  2. Create New Workflow: Click "Add Workflow" button to create a new workflow.

  3. Set Target Module: Select "Intake Opportunities" as the module this workflow will target.

  4. Configure Workflow Conditions: Set up the following conditions in the "All" section (these must all be true):

    • Referral Source field "is not empty"

  5. Set Workflow Actions: In the actions section, configure:

    • Field to update: "BD Rep"

    • Value source: Select the option to pull from a related field

    • Related field: "Referral Source Assigned To"

  6. Save and Activate: Save your workflow configuration and activate it.

  7. Run Bulk Update (if needed): If you need to update existing records immediately, you may need to use the Time Interval trigger method to process all matching records at once, then change back to the normal trigger.

Verification / Expected Result

After running the workflow, you should see:

  • Opportunities with assigned referral sources now have BD reps assigned

  • The BD rep matches the owner of the referral source

  • Opportunities with "Readmit" or "Internet Search" referral sources remain unaffected

  • Future opportunities that match the criteria will automatically get BD rep assignments

Troubleshooting / Common Errors

  • No Updates Occurring: Verify that your workflow conditions correctly identify opportunities without BD reps but with valid referral sources.

  • Wrong BD Rep Assigned: Check that the referral sources have the correct owners assigned before running the workflow.

  • Excluded Sources Still Getting Updated: Double-check that your exclusion conditions for "Readmit" and "Internet Search" are properly configured.

⚠️ Important: Test your workflow on a small subset of records first to ensure it's working correctly before applying it to thousands of opportunities.
​

πŸ’‘ Pro Tip: This approach avoids the need to manually update hundreds of individual referral sources, saving significant time when dealing with large imports.
​

Related Resources

Did this answer your question?