I have a need to reassign a Campaign Response record when it is created, to a specific user field on either the Lead or the Contact's Parent Account.
I was going to do this by setting up a Workflow on the creation of the record but it seems there is no relationship between the Campaign Response & the Lead or the Contact because instead it uses a 'Customer' field.
Does anyone have any suggestions of how I can achieve this?
What I was hoping for was along the lines of:
- When Campaign Response is created
- Check if the Campaign Response is from a Lead
- If Yes, reassign Campaign response to Lead: 'Sales Rep' field
- Check is the Campaign Response is from a Contact
- If Yes, reassign to Company Name (Account): 'Sales Rep' field
- Check if the Campaign Response is from a Lead
If I added a lookup field for Lead, Contact & Account to the Campaign Response entity, would they update automatically based on the Customer field, or would I need another Workflow to update those first, and would that even be possible??
Thanks for your help!