What would be the best way to update a parent account based on a picklist field on the child account?  I have a child account with International in a territory picklist and I want to update the parent account field with a checkbox showing there is a International child account.

So I understand we cannot trigger off of the OpportunityContactRole object but someone said I could query the object and then update the opportunity.  I can't seem to figure out the best way to accomplish this.  I have some code that was given to me but I am not sure how I can then populate the opportunity with the contact ID.  Can someone please help?

trigger Contact_Role_Update on Opportunity (after insert) 
{Map<ID, OpportunityContactRole> roles = new Map<ID, OpportunityContactRole>([SELECT Id, Contact.Name, ContactId, IsPrimary, OpportunityId from OpportunityContactRole where OpportunityId in :opportunityidlist ]);

I would like to create an APEX trigger that pulls the Contact Id from the contact role object and into the opportunity record.  I was in Eclipse and this doesn't seem to be possible.  Is there any way to do this?

We have advanced currency enabled on our SFDC and I was wondering if anyone had figured out a way to do a roll-up for the amount field off of opportunities through a trigger or some other code.  I welcome any good advice as to the best way around this.

I am trying to update the contact with the most recent campaign id from the campaignmember table but I am missing something.


trigger Update_Contact_Recent_Campaign on CampaignMember (after insert,after update) {

List<Contact> myContactUpdate =
[SELECT CampaignId FROM CampaignMember WHERE ContactID <> 'null' order by SystemmodStamp desc limit 1];
Recent_Campaign_ID__c = CampaignId
update myContactUpdate;

I am trying to get an idea of how best to create this trigger.  I want to update new opportunities with the contact associated most recent campaign in the primary campaign source.  Can this be done with a trigger or what might be a better option?

I have a create opportunity call in which I am trying to recreate the standard functionality that auto-populates the Primary Campaign source field with the most recent campaign related to the contact.  Does anyone know how I could add to my call to have it do this?

We are creating an opportunity integration and would like to capture the most recent campaign on the contact associated with an opportunity in the primary campaign source.  How can this be done?

I am integrating my ERP with Salesforce and we have all of our products loaded and active in Salesforce but how can I take the product code and attach it to the opportunity.  The pricebook entryid table is empty.

I want to add a query to my web to case for on our website that will look for the contact based on their email and populate the contact id.  How can I do this?

We are looking to find a consultant that has experience with Scribe software.  This will be a short project with additional projects possible.  Please email me your resume and contact information if you are interested.

Thanks,

Kim Stites

Sales & Marketing Automation Specialist

CPP, Inc.

1055 Joaquin Road, 2nd Floor

Mountain View, CA 94043

kstites@cpp.com

Office:  650.691.9105   |    Fax:  650.623.9273

Be Better.  At making your organization great.  At helping others be their best.

800-624-1765  :  www.cpp.com  :  The Myers-Briggs® experts

Myers-Briggs Type Indicator, Myers-Briggs, MBTI, Step I, Step II, Step III, Introduction to Type, and the MBTI logo are trademarks or registered trademarks of the MBTI Trust, Inc. California Psychological Inventory, CPI, CPI 260, FIRO, FIRO-B, FIRO Business, SkillsOne, Strong Interest Inventory, and the CPI 260, CPP, FIRO, FIRO-B, FIRO Business, Strong, and TKI logos are trademarks or registered trademarks of CPP, Inc.

I have a create opportunity call in which I am trying to recreate the standard functionality that auto-populates the Primary Campaign source field with the most recent campaign related to the contact.  Does anyone know how I could add to my call to have it do this?

What would be the best way to update a parent account based on a picklist field on the child account?  I have a child account with International in a territory picklist and I want to update the parent account field with a checkbox showing there is a International child account.

I would like to create an APEX trigger that pulls the Contact Id from the contact role object and into the opportunity record.  I was in Eclipse and this doesn't seem to be possible.  Is there any way to do this?

We have advanced currency enabled on our SFDC and I was wondering if anyone had figured out a way to do a roll-up for the amount field off of opportunities through a trigger or some other code.  I welcome any good advice as to the best way around this.

I am trying to update the contact with the most recent campaign id from the campaignmember table but I am missing something.


trigger Update_Contact_Recent_Campaign on CampaignMember (after insert,after update) {

List<Contact> myContactUpdate =
[SELECT CampaignId FROM CampaignMember WHERE ContactID <> 'null' order by SystemmodStamp desc limit 1];
Recent_Campaign_ID__c = CampaignId
update myContactUpdate;

I am integrating my ERP with Salesforce and we have all of our products loaded and active in Salesforce but how can I take the product code and attach it to the opportunity.  The pricebook entryid table is empty.