Workflow to update the Quota Distribution "Resource" within an Opportunity

(0) Share

Report

Posted on by Community Member

Hello,

Within my Opportunity form, a user is allowed to create as many Sales Quota Distributions as they'd like. Sales Quota Distribution is a separate entity, and the first field that shows on the Sales Quota Distribution grid is "Resource". When an Opportunity is created, one Sales Quota Distribution is added to the grid, and the "Resource" shows the "Owner" of the Opportunity form. A user is allowed to manually add more Sales Quota Distributions. However, the first Sales Quota Distribution's resource should always be the Opportunity Owner. How can I create a workflow that updates the first Sales Quota Distribution Resource when the Owner of the Opportunity is updated?

My initial thought was to have the workflow get triggered when the Owner of the Opportunity gets updated, then update the first Sales Quota Distribution record attached to the form, but this doesn't seem to be possible.