I'd like to add fields to the Campaign Object which would show 1) the total leads (after filtering), 2) the total Opportunities (also with filtering), and 3) the total accounts (also with filtering). This would allow the Campaign Manager to see how many leads and how many opportunities have been generated by the Campaign.
Alternately, rather than show these on the Campaign object, I'd like to show them on a Custom object which is linked to the Campaign object.
I know how to do this with a custom object and Master-Detail relationships. But that requires being able to create a Master-Detail relationship in all three Standard Objects -- and you can't do that.
I found something that might work, but I lost my reference to it and can't find it. It had me create a report and pass the values to the object using the URL. I believe this is the answer, but I can't find the information about it.
So any ideas are greatly appreciated.
Thank you.
3 answers
I will tell you that I cannot write code from start to finish, yet I have been able to find enough code online to create every trigger I have ever used. You just need to do a lot of google searches. The Developer Boards are very helpful as well, as sometimes if you post your question, especially with a portion of code, you will get developers who will fix your code or show you how to fix it.
Sometimes you will find triggers that do the same type of action as you want, they just do it to other objects and all you need to do is change where the code is pointing to.Good Luck.
