Hi,

is it possible to create an opportunity line item tab?

We've created a custom owner field on the opportunity products for our specialty sales departments.

They can't use the list views in opportunities (f.e. my open opportunities, my lost opps etc) so they need one based on opportunity line items. Is this possible?

I hope someone can point me in the right direction.

Thanks 

Hi,

I've created a button on my event page that will copy some fields into a new g-mail message.

But when the description field is too long, g-mail will give me an error. 

Is it possible to change the code so g-mail will accept the description field with more than f.e. 1000 characters?

javascript:popw='';Q='';x=document;y=window;if(x.selection) {Q=x.selection.createRange().text;} else if (y.getSelection) {Q=y.getSelection();} else if (x.getSelection) {Q=x.getSelection();}popw = y.open('https://mail.google.com/mail?view=cm&tf=0' + escape(document.title) + '&su=Event - at {!Event.Accountname__c} in {!Event.Location} on {!Event.ActivityDate}' + '&to=' + '&body=Dear colleague,'+ escape('\n') + escape('\n') + 'Check out my event summary:'+ escape('\n')+ escape('\n')+ 'Subject: {!Event.Subject}' + escape('\n')+ 'Type event: {!Event.Type_of_event__c}' + escape('\n') + 'Event: {!Event.Event__c}' + escape('\n') + escape('\n') +'{!JSENCODE(Event.Description)} '  ,'gmailForm','scrollbars=yes,width=680,height=510,top=175,left=75,status=no,resizable=yes');if (!document.all) T = setTimeout('popw.focus()',50);void(0);

 Thanks!

Juul

Hi,

Due to security issues we need to rebuild the contract object in a new custom object.

Is there a posibility to clone the contract object (with all the fields 100+) and records to a new custom object?

thanks

juul

Hi,

I want to add the Campaign Member Summary using Google Charts item on my campaign page. But I'm getting an error when saving the test class:

unexpected token: 'testMethod' in line 1

What do I need to change to get it working?

static testMethod void testVFController_Sidebar_Summary() {
         
        // Create Campaign
        Campaign c = new Campaign();
        c.Name = 'Test Campaign';
        insert c;
         
        // Create Lead
        Lead l = new Lead();
        l.LastName = 'Last Name';
        l.Company = 'Company';
        insert l;
         
        // Create Campaign Member
        CampaignMember cms = new CampaignMember();
        cms.CampaignId = c.id;
        cms.LeadId = l.id;
        insert cms;
         
        test.startTest();
         
        ApexPages.StandardController sc = new ApexPages.StandardController(c);
        VFController_CampaignMemberStatusChart controller = new VFController_CampaignMemberStatusChart(sc);
        String s1 = controller.getChartData();
         
        test.stopTest();
    }
 
}

Hi ,

What do I need to change to refer to a thank you page after pressing the button "Update"?

Class:

public class UpdateCampaignMemberClass{

    public final CampaignMember cm;

    private ApexPages.StandardController cmController;

    public UpdateCampaignMemberClass(ApexPages.StandardController controller) {
        cmController = controller;
        this.cm= (CampaignMember)controller.getRecord();
    }

    public PageReference UpdateAction() {
             try{
            update cm;
            }
            catch(DmlException ex){
            ApexPages.addMessages(ex);
            }
       
       return new PageReference('http://test.force.com/web2campaign/?id=' + cm.id );
    }   public string getStatus(string Status){
            return 'Test__c';
            return 'Test_2__c';
   } 
    
      
       
 }

VF:

<apex:page standardController="CampaignMember" extensions="UpdateCampaignMemberClass" sidebar="false" showHeader="false">

<script type="text/javascript"> 

function getQueryVariable(variable) {
var query = window.location.search.substring(1);
var vars = query.split("&");
for (var i=0;i<vars.length;i++) {
var pair = vars[i].split("=");
if (pair[0] == variable) {
return pair[1];
}
} } 

function showAlert(variable){
    alert(variable);
    }
</script>

<apex:form >
    <b>Campaign Member ID </b><apex:inputfield value="{!campaignmember.Id}"/><br/><br/>
            Status <apex:inputfield value="{!campaignmember.Test__c}"/><br/><br/>
            Status <apex:inputfield value="{!campaignmember.Test_2__c}"/><br/><br/>
    <apex:commandButton value="Update" action="{!UpdateAction}" />
    
    
    

</apex:form>
</apex:page>

Hi,

I've created a visualforce template with help of this app: https://appexchange.salesforce.com/listingDetail?listingId=a0N300000016cYlEAI

When I generate a test (email) with myself as user and a test opportunity everything is working fine. It displays all the product data.
But when the workflow is triggered and I receive a notification email, there is no data visible in the email.

What's going wrong? (sorry for the Dutch text...)

<messaging:emailTemplate recipientType="User"
    relatedToType="Opportunity"
    subject="Je bent zojuist toegevoegd aan de dienstenlijst van de Opportunity: {!relatedTo.name}">
    
<messaging:htmlEmailBody >        
    <html>
        <body>
         <STYLE type="text/css">
               TH {font-size: 11px; font-face: arial;background: #CCCCCC; border-width: 1;  text-align: center } 
               TD  {font-size: 11px; font-face: verdana } 
               TABLE {border: solid #CCCCCC; border-width: 1}
               TR {border: solid #CCCCCC; border-width: 1}
         </STYLE>
                  <font face="arial" size="2">
        <p>Beste collega,</p>
        <p>Je bent zojuist toegevoegd aan de dienstenlijst van de Opportunity:<b> {!relatedTo.name}</b>.</p>
        <p>Controleer voordat je wijzigingen wil doorvoeren of je aan het opportunity team van deze opportunity bent gekoppeld, anders krijg je de foutmelding dat je hier geen rechten voor hebt.</p>
        <p>Mocht je nog niet aan het opportunityteam zijn gekoppeld neem dan contact op met {!relatedTo.owner.name}.</p>
        
        <br/>Account: <i> {!relatedTo.Account.name}  </i>  
        <br/>Opportunity eigenaar: {!relatedTo.owner.name}
        <br/>Opportunity fairshare waarde: {!ROUND(relatedTo.Amount,0)} 
        <br/>Opportunity gunningsdatum: {!relatedTo.CloseDate}  
   
        <p/>                  
       <table border="0" >
                 <tr > 
                     <th>Actie</th><th>Dienstnaam</th><th>Dienst specificatie</th><th>Hoeveelheid</th><th>Verkoopprijs</th><th>Totale fairshare waarde label</th>
                  </tr>
    <apex:repeat var="opp" value="{!relatedTo.OpportunityLineItems}">
       <tr>
           <td><a href="https://emea.salesforce.com/{!opp.id}">View</a> |  
           <a href="https://emea.salesforce.com/{!opp.id}/e">Edit</a></td>
           <td>{!opp.PriceBookEntry.name}</td>
           <td>{!opp.Service_specification__c}</td>
           <td>{!ROUND(opp.Quantity,0)}</td>
           <td>{!ROUND(opp.UnitPrice,0)}</td>
           <td>{!ROUND(opp.TotalPrice,0)}</td>
       </tr>
    </apex:repeat>                 
       </table>
       <p />
 </font>
       
        </body>
    </html>
</messaging:htmlEmailBody> 
    
<messaging:plainTextEmailBody >
Beste collega,
 
Je bent zojuist toegevoegd aan de dienstenlijst van de Opportunity: {!relatedTo.name}
Controleer voordat je wijzigingen wil doorvoeren of je aan het opportunity team van deze opportunity bent gekoppeld, anders krijg je de foutmelding dat je hier geen rechten voor hebt.
Mocht je nog niet aan het opportunityteam zijn gekoppeld neem dan contact op met {!relatedTo.owner.name}.

Account: {!relatedTo.Account.name}
Opportunity eigenaar: {!relatedTo.owner.name}
Opportunity fairshare bedrag: {!ROUND(relatedTo.Amount,0)} 
Opportunity gunningsdatum: {!relatedTo.CloseDate}  


[ Dienst Naam ] - [ Dienst specificatie ] - [ Hoeveelheid ] - [ Verkoopprijs] - [ Totale fairshare waarde label ]
----------------------------------------------------------------------------------------------------------------------------------------------

<apex:repeat var="opp" value="{!relatedTo.OpportunityLineItems}">
[ {!opp.PriceBookEntry.name} ] - [ {!opp.Service_specification__c} ] - [ {!ROUND(opp.Quantity,0)} ] - [ {!ROUND(opp.UnitPrice,0)} ] - [ {!ROUND(opp.TotalPrice,0)} ]
</apex:repeat>

</messaging:plainTextEmailBody>       
        
</messaging:emailTemplate>

Hi,

I need some help with my URL hacking. I want to create a new button on the accountpage to create a child account.

So I only need to pre-populate the parent name and the recordtype. When clicking on the new button it opens a new account, with the correct recordtype but without the name of the account in the parent field.

I'm not sure if I have to use the fieldnames for Parent and ParentID, perhaps there are some other ID's for these fields.....

/001/e?Parent={!Account.Name}&ParentId={!Account.Id}&RecordType=01220000000Q3wo&retURL=/{!Account.Id} 

Thanks

Hi,

I'm trying to create a trigger on attachment. If the attachment contains the text "RFP" then the checkbox "RFP_check__c" has to be checked.

// Trigger to update the RFP_check__c custom checkbox field in Opportunity (Opportunity) if it has an attachment containing RFP.

            trigger TiggerName on attachment (after insert)

            {

                        List<Opportunity> co = [select id, Attachment__c from Opportunity where id =: Trigger.New[0].ParentId];

                        if(co.size()>0) && att.Name.toLowerCase().contains('RFP')) 

                        {

                                    co[0].RFP_check__c = true;

                                    update co;

                        }                                                                   

            }

 Eclipse is giving me the error : Unexpected token &&

And the following error:

Hi,

I've tried to create a workflow to copy the field accountstage (invisible for users, just for reporting) to a new event. But this is not possible unfortunately.

Is it possible to create a trigger only on event creation that copies the field accountstage to the custom field Accountstage on event? Does anyone have an example or an idea, triggers are not my specialty :)

Hi,

Does anyone have an example how to create a trigger (and test class) to update all contracts, when the lastmodified date of a custom object is changed?

I need this because I created some cross-object date formulas on the contract object, which have to be updated every time a change has been made in the custom object. A workflow (time-trigger) will send the owner a warning several days before. 

I've already tried this app http://appexchange.salesforce.com/listingDetail?listingId=a0N300000023bFjEAI

but it's only working for standard objects, unless you pay. 

Thanks

Hi,

can someone help me in creating a good test class.....

this is my working trigger:

trigger Postalcodelookup on Account (before insert, before update) {
    List<String> Postalcodes4dig = new List<String>(); 
    
    for (Account a:Trigger.new){
        Postalcodes4dig.add(a.Postalcode_4dig__c);
    }

    List <Postalcode__c> PostalCodeList = [Select ID, Name from Postalcode__c where Name in :Postalcodes4dig];

    for (Integer i = 0; i <Trigger.new.size(); i++){
        if (PostalCodeList.size() > 0 && Trigger.new[i].Postalcode_4dig__c !=null){
                        for (Postalcode__c z:PostalCodeList){
                if (Trigger.new[i].Postalcode_4dig__c == z.name){
                        Trigger.new[i].PostalcodeLookup__c = z.ID;
                                }
                        }
        }
        else{
        Trigger.new[i].PostalcodeLookup__c = null;
        }
        
    }
}

And I start my test with the following:

@isTest
// test for the 'Postalcodelookup'trigger
private class Postalcodelookup {
static testMethod void test() {

        account[] Accounttest = new account[]{
         new account(Name='TEST', Shippingstreet = 'Street 10', Shippingpostalcode = '1100 AA', Shippingcity = 'Stad', Shippingcountry = 'Nederland', Phone = '077-5401111',Type = 'Prospect', Potential_amount__c = 1000000,Industry = 'Hospitality', Sub_Industry__c = 'Cultuur', Business_Unit__c = 'Zuid', Account_stage__c = 'Suspect'),
         new account(Name='TEST', Shippingstreet = 'Street 10', Shippingpostalcode = '1000 CD', Shippingcity = 'Stad', Shippingcountry = 'Nederland', Phone = '077-5401111',Type = 'Prospect', Potential_amount__c = 1000000,Industry = 'Hospitality', Sub_Industry__c = 'Cultuur', Business_Unit__c = 'Zuid', Account_stage__c = 'Suspect')
         };

But I don't know how to make it complete with system.assert etc....

Can someone please help :)

thanks 

Hi,

Does anyone have an example how to write a trigger to update a lookupfield with a custom field in the same object?

My example:

I want to insert the field "Postalcode 4 dig" into the lookup field "Postcode". See screenshot:

When I manually insert the "Postalcode 4 dig" into the lookup field "Postcode" two fields will automatically be filled with help of a cross-object formula. So everything is working fine, except I don't want that the users have to copy the 4 digit postalcode into the lookup field.

Thanks!

Hi,

This is the first trigger I'm trying to write, and ofcourse I retrieve an error:

System.StringException: Invalid id: 5911

To explain. I managed to create  a lookup relation between Account and an object with postalcodes.

By inserting a 4 digit postalcode into the lookupfield "Postcode__c"  three fields are automatically filled, this is working perfectly. 

This trigger needs to populate the lookup field "Postcode__c" with the value from the formula field

"Postalcode_4dig__c" (this is a left formula getting only the numbers from the shippingpostalcode) --> so that the user doesn't have to manually copy the "Postalcode_4dig__c" into the lookupfield.

// This trigger populates the field "Postcode"
trigger tgrPopulatePostcode on Account (before insert, before update) { 
for(Account a : trigger.new){ 
// write custom lookupfield "Postcode" 
a.Postcode__c = a.Postalcode_4dig__c;
} 
}

Testclass

@isTest
// test for the 'Populate Postcode' trigger
private class tstPopulatePostcode {
static testMethod void test() {
// create dummy Account
Account a = new Account(Name='TEST', Shippingstreet = 'Street 10', Shippingpostalcode = '5911 BB', Shippingcity = 'Stad', Shippingcountry = 'Nederland', Phone = '077-5401111',Type = 'Prospect', Potential_amount__c = 1000000,
Industry = 'Hospitality', Sub_Industry__c = 'Cultuur', Business_Unit__c = 'Zuid', Account_stage__c = 'Suspect');

insert a;

// get the custom "Postcode" field value
a.Postcode__c = [SELECT Postalcode_4dig__c FROM Account WHERE
Id = :a.Id LIMIT 1].Postalcode_4dig__c;

// test "Postcode" 
System.assert( a.Postcode__c == a.Postalcode_4dig__c);

}
}

What am I doing wrong?

Thanks

Hi,

is it possible to create an opportunity line item tab?

We've created a custom owner field on the opportunity products for our specialty sales departments.

They can't use the list views in opportunities (f.e. my open opportunities, my lost opps etc) so they need one based on opportunity line items. Is this possible?

I hope someone can point me in the right direction.

Thanks 

Hi,

Due to security issues we need to rebuild the contract object in a new custom object.

Is there a posibility to clone the contract object (with all the fields 100+) and records to a new custom object?

thanks

juul

Hi ,

What do I need to change to refer to a thank you page after pressing the button "Update"?

Class:

public class UpdateCampaignMemberClass{

    public final CampaignMember cm;

    private ApexPages.StandardController cmController;

    public UpdateCampaignMemberClass(ApexPages.StandardController controller) {
        cmController = controller;
        this.cm= (CampaignMember)controller.getRecord();
    }

    public PageReference UpdateAction() {
             try{
            update cm;
            }
            catch(DmlException ex){
            ApexPages.addMessages(ex);
            }
       
       return new PageReference('http://test.force.com/web2campaign/?id=' + cm.id );
    }   public string getStatus(string Status){
            return 'Test__c';
            return 'Test_2__c';
   } 
    
      
       
 }

VF:

<apex:page standardController="CampaignMember" extensions="UpdateCampaignMemberClass" sidebar="false" showHeader="false">

<script type="text/javascript"> 

function getQueryVariable(variable) {
var query = window.location.search.substring(1);
var vars = query.split("&");
for (var i=0;i<vars.length;i++) {
var pair = vars[i].split("=");
if (pair[0] == variable) {
return pair[1];
}
} } 

function showAlert(variable){
    alert(variable);
    }
</script>

<apex:form >
    <b>Campaign Member ID </b><apex:inputfield value="{!campaignmember.Id}"/><br/><br/>
            Status <apex:inputfield value="{!campaignmember.Test__c}"/><br/><br/>
            Status <apex:inputfield value="{!campaignmember.Test_2__c}"/><br/><br/>
    <apex:commandButton value="Update" action="{!UpdateAction}" />
    
    
    

</apex:form>
</apex:page>

Hi,

I've created a visualforce template with help of this app: https://appexchange.salesforce.com/listingDetail?listingId=a0N300000016cYlEAI

When I generate a test (email) with myself as user and a test opportunity everything is working fine. It displays all the product data.
But when the workflow is triggered and I receive a notification email, there is no data visible in the email.

What's going wrong? (sorry for the Dutch text...)

<messaging:emailTemplate recipientType="User"
    relatedToType="Opportunity"
    subject="Je bent zojuist toegevoegd aan de dienstenlijst van de Opportunity: {!relatedTo.name}">
    
<messaging:htmlEmailBody >        
    <html>
        <body>
         <STYLE type="text/css">
               TH {font-size: 11px; font-face: arial;background: #CCCCCC; border-width: 1;  text-align: center } 
               TD  {font-size: 11px; font-face: verdana } 
               TABLE {border: solid #CCCCCC; border-width: 1}
               TR {border: solid #CCCCCC; border-width: 1}
         </STYLE>
                  <font face="arial" size="2">
        <p>Beste collega,</p>
        <p>Je bent zojuist toegevoegd aan de dienstenlijst van de Opportunity:<b> {!relatedTo.name}</b>.</p>
        <p>Controleer voordat je wijzigingen wil doorvoeren of je aan het opportunity team van deze opportunity bent gekoppeld, anders krijg je de foutmelding dat je hier geen rechten voor hebt.</p>
        <p>Mocht je nog niet aan het opportunityteam zijn gekoppeld neem dan contact op met {!relatedTo.owner.name}.</p>
        
        <br/>Account: <i> {!relatedTo.Account.name}  </i>  
        <br/>Opportunity eigenaar: {!relatedTo.owner.name}
        <br/>Opportunity fairshare waarde: {!ROUND(relatedTo.Amount,0)} 
        <br/>Opportunity gunningsdatum: {!relatedTo.CloseDate}  
   
        <p/>                  
       <table border="0" >
                 <tr > 
                     <th>Actie</th><th>Dienstnaam</th><th>Dienst specificatie</th><th>Hoeveelheid</th><th>Verkoopprijs</th><th>Totale fairshare waarde label</th>
                  </tr>
    <apex:repeat var="opp" value="{!relatedTo.OpportunityLineItems}">
       <tr>
           <td><a href="https://emea.salesforce.com/{!opp.id}">View</a> |  
           <a href="https://emea.salesforce.com/{!opp.id}/e">Edit</a></td>
           <td>{!opp.PriceBookEntry.name}</td>
           <td>{!opp.Service_specification__c}</td>
           <td>{!ROUND(opp.Quantity,0)}</td>
           <td>{!ROUND(opp.UnitPrice,0)}</td>
           <td>{!ROUND(opp.TotalPrice,0)}</td>
       </tr>
    </apex:repeat>                 
       </table>
       <p />
 </font>
       
        </body>
    </html>
</messaging:htmlEmailBody> 
    
<messaging:plainTextEmailBody >
Beste collega,
 
Je bent zojuist toegevoegd aan de dienstenlijst van de Opportunity: {!relatedTo.name}
Controleer voordat je wijzigingen wil doorvoeren of je aan het opportunity team van deze opportunity bent gekoppeld, anders krijg je de foutmelding dat je hier geen rechten voor hebt.
Mocht je nog niet aan het opportunityteam zijn gekoppeld neem dan contact op met {!relatedTo.owner.name}.

Account: {!relatedTo.Account.name}
Opportunity eigenaar: {!relatedTo.owner.name}
Opportunity fairshare bedrag: {!ROUND(relatedTo.Amount,0)} 
Opportunity gunningsdatum: {!relatedTo.CloseDate}  


[ Dienst Naam ] - [ Dienst specificatie ] - [ Hoeveelheid ] - [ Verkoopprijs] - [ Totale fairshare waarde label ]
----------------------------------------------------------------------------------------------------------------------------------------------

<apex:repeat var="opp" value="{!relatedTo.OpportunityLineItems}">
[ {!opp.PriceBookEntry.name} ] - [ {!opp.Service_specification__c} ] - [ {!ROUND(opp.Quantity,0)} ] - [ {!ROUND(opp.UnitPrice,0)} ] - [ {!ROUND(opp.TotalPrice,0)} ]
</apex:repeat>

</messaging:plainTextEmailBody>       
        
</messaging:emailTemplate>

Hi,

I need some help with my URL hacking. I want to create a new button on the accountpage to create a child account.

So I only need to pre-populate the parent name and the recordtype. When clicking on the new button it opens a new account, with the correct recordtype but without the name of the account in the parent field.

I'm not sure if I have to use the fieldnames for Parent and ParentID, perhaps there are some other ID's for these fields.....

/001/e?Parent={!Account.Name}&ParentId={!Account.Id}&RecordType=01220000000Q3wo&retURL=/{!Account.Id} 

Thanks

Hi,

I'm trying to create a trigger on attachment. If the attachment contains the text "RFP" then the checkbox "RFP_check__c" has to be checked.

// Trigger to update the RFP_check__c custom checkbox field in Opportunity (Opportunity) if it has an attachment containing RFP.

            trigger TiggerName on attachment (after insert)

            {

                        List<Opportunity> co = [select id, Attachment__c from Opportunity where id =: Trigger.New[0].ParentId];

                        if(co.size()>0) && att.Name.toLowerCase().contains('RFP')) 

                        {

                                    co[0].RFP_check__c = true;

                                    update co;

                        }                                                                   

            }

 Eclipse is giving me the error : Unexpected token &&

And the following error:

Hi,

I've tried to create a workflow to copy the field accountstage (invisible for users, just for reporting) to a new event. But this is not possible unfortunately.

Is it possible to create a trigger only on event creation that copies the field accountstage to the custom field Accountstage on event? Does anyone have an example or an idea, triggers are not my specialty :)

Hello everyone,

Is there any way to update an Opportunity field when a Sales Team (Opportunity Team Selling) is specified?  We prefer Salesforce tools, we won't develop APEX code for this.

Thanks in advance!

I need to write some validatio/trigger on attachment object. Is there any possibility of doing that ?

I'm using the Campaign Membership Manager 1.0 app by Force.com Labs. Unfortunately, it seems that having mutli-currency enabled is causing a problem with the code. 

Invalid field CurrencyIsoCode for SObject CampaignMember 

I attempted to resolve this problem myself by updating the query in the app controller by adding the CurrencyIsoCode to both the CampaignMember and Campaign queries. But, I get this error when I try to save in Eclipse:

No such column 'CurrencyIsoCode' on entity 'CampaignMember'.

I have double checked the spelling and actually copied the api name from the Setup > Campaign Members field listing. So, I know that it exists on the CampaignMember object. I'm just confused as to why it won't let me include that field.

It's pretty pointless because we aren't using the Multi-Currency field. We enabled it in the past because a consultant told us to but we are only using dollars.

Here is the query that I am updating:

        for( CampaignMember cm: [ Select Id, CurrencyIsoCode, LeadId, Lead.Company, Lead.Email, Lead.FirstName, Lead.LastName, Lead.OwnerId, Lead.City, ContactId, 
        							Contact.Account.Name, Contact.Email, Contact.FirstName, Contact.LastName, Contact.OwnerId, Contact.MailingCity, Status
        							from CampaignMember 
        							WHERE CampaignId =: selectedCampaign AND ( Contact.OwnerID =: userName OR Lead.OwnerID =: userName ) 
        							ORDER BY Lead.LastName, Contact.LastName ] ){
        								
            this.campaignMemberList.add( new MyCampaignMember( cm ) );
        }
        

Any tips as to why this may be happening or how I can reformat the query?

Hi,

I want to update the Campaign Member Status using the Force.com Sites. I just want ot know how i can pass the Campaign Member Id the Force.comSites URL. I have written one Custom Controller which will update the Camapign Status. Here i hardcoded the Campaign Member. Please suggest me how to pass theCampaign Member Id to the Sites URL.

Ex Site URL:http://Mysites-developer-edition.na6.force.com/test?id=701800000009EWSX

"701800000009EWSX" This isCampaign Member Id.

Thanks

Srikanth.K