• barbkuntz
  • NEWBIE
  • 25 Points
  • Member since 2004

  • Chatter
    Feed
  • 1
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 4
    Questions
  • 7
    Replies

We are having our Sites-based website translated into 3 new languages.  As part of the process, we are adding directive tags <!--….--!> to tell the translator robots what to do with certain pieces of information.  The trouble is, Salesforce.com is changing the text between those tags to asterisks <!--*****--!> which renders them unreadable.  How can I keep Salesforce from doing this?

Company seeking Salesforce.com Administrator in Orange County, California.  Some local (Los Angeles) travel required.  Position is contract to hire. Strong candidate will have 2 or more years hands-on experience as an Enterprise Salesforce.com administrator in an organization with 75 or more users.  Working knowledge of Java, Apex, and ASP is a plus, but not required.  Contact Jordan Wohl (jwohl@surrex.com) for more information about this opportunity.
I have a new requirement for my lead scoring formula.  I need a line that says "If HasOptedOutOfEmail" equals "True" score the entire lead as 0. 
 
My existing formula reads:
 
__________________________________________________________
 
IF( OR(
       ISPICKVAL ( Status , "Duplicate Lead" )  ,
       ISPICKVAL ( Status , "No Potential" )
       ) ,
      0  ,
      IF(
          OR(
             Contains (Email, "yahoo" ) ,
             Contains (Email, "hotmail" ) ,
             Contains (Email, "gmail" ) ,
             Contains (Email, "rr.com" ) ,
             Contains (Email, "aol" ) ,
Contains (Email, "earthlink"),
             Contains (Email, "verizon" )
            ) ,
            2 ,                   
            +(
                CASE ( LeadSource ,
                       "Advertising", 4,
                       "Directory Listing (paid)", 3,
                       "Directory Listing (unpaid)", 1,
                       "Email", 4, "E Newsletter", 5,
                       "Inbound Call MUC", 5,
                       "Inside Sales", 1,
                       "Other", 1,
                       "Press Release", 3,
                       "Rep Lead", 1,
                       "Seminar / Conference", 4,
                       "Technical Article", 4,
                       "Top 10", 1,
                       "Tradeshow", 5,
                       "Web", 5,
                       "Organic - Google", 5,
                       "PPC - Google", 5,
                       "Google AdWords", 5,
                        0)
                  +
                CASE (Industry ,
                       "Aerospace", 5,
"Alternative Energy", 5,
"Automation", 3,
"Automotive", 4,
"Batteries", 4,
"Chemicals", 2,
"Communications", 3,
"Computers & Peripherals", 3,
"Contract Mfr", 3,
"Crystal", 2,
"Defense/Military", 4,
"Displays", 4,
"Electronic Components", 4,
"Heating Elements", 3,
"Home Appliance", 2,
"LED", 1,
"Lighting", 3,
"Manufacturing", 1,
"Medical", 5,
"Misc", 1,
"Motors & Coils", 3,
"Nuclear Power", 5,
"Photonics", 4,
"Semiconductors", 3,
"Solar Cells", 5,
"Technology", 1,
"Telecom", 2,
"Tools", 2,
                       0)
                )
         )
  )
Hi there -
 
I'm new (really new!) to formula writing and need some help with a lead scoring formula.
 
What I want to achieve is this (in English):  If the lead status is 'duplicate lead' or 'no potential' score the entire lead as zero.  If the above does not apply and the email address contains 'yahoo,' 'gmail,' 'rr.com,' 'aol,' 'verizon,' 'pacbell' or 'att,' score the entire lead as '1.'  If neither of the above apply, score the lead (see below).
 
Here's what I have so far which works for scoring the leads, but doesn't take the first two IF's into account - I need to move the last IF statement as it isn't working where it is.
 
Can someone help please? 
 
CASE (LeadSource , "Advertising", 1, "Directory Listing (paid)", 3, "Directory Listing (unpaid)", 1, "Email", 4, "E Newsletter", 4, "Inbound Call MUC", 4, "Inside Sales", 1, "Other", 1, "Press Release", 1, "Rep Lead", 1, "Seminar / Conference", 3, "Technical Article", 2, "Top 10", 1, "Tradeshow", 4, "Web", 4, "Organic - Google", 4, "PPC - Google", 4, "Google AdWords", 3,0)+
CASE (Industry , "Solar Cells", 4, "Medical", 3, "Electronic Components", 3, "Automotive", 3, "Alternative Energy", 4, "Batteries", 4, "Aerospace", 3,0)+
 IF( CONTAINS("yahoo:hotmail:gmail:rr.com:aol:verizon:pacbell:att", Email ) , 0, 2)
 
Thanks!
Barbara
 
 


Message Edited by barbkuntz on 11-18-2008 11:47 AM

We are having our Sites-based website translated into 3 new languages.  As part of the process, we are adding directive tags <!--….--!> to tell the translator robots what to do with certain pieces of information.  The trouble is, Salesforce.com is changing the text between those tags to asterisks <!--*****--!> which renders them unreadable.  How can I keep Salesforce from doing this?

Company seeking Salesforce.com Administrator in Orange County, California.  Some local (Los Angeles) travel required.  Position is contract to hire. Strong candidate will have 2 or more years hands-on experience as an Enterprise Salesforce.com administrator in an organization with 75 or more users.  Working knowledge of Java, Apex, and ASP is a plus, but not required.  Contact Jordan Wohl (jwohl@surrex.com) for more information about this opportunity.
I have a new requirement for my lead scoring formula.  I need a line that says "If HasOptedOutOfEmail" equals "True" score the entire lead as 0. 
 
My existing formula reads:
 
__________________________________________________________
 
IF( OR(
       ISPICKVAL ( Status , "Duplicate Lead" )  ,
       ISPICKVAL ( Status , "No Potential" )
       ) ,
      0  ,
      IF(
          OR(
             Contains (Email, "yahoo" ) ,
             Contains (Email, "hotmail" ) ,
             Contains (Email, "gmail" ) ,
             Contains (Email, "rr.com" ) ,
             Contains (Email, "aol" ) ,
Contains (Email, "earthlink"),
             Contains (Email, "verizon" )
            ) ,
            2 ,                   
            +(
                CASE ( LeadSource ,
                       "Advertising", 4,
                       "Directory Listing (paid)", 3,
                       "Directory Listing (unpaid)", 1,
                       "Email", 4, "E Newsletter", 5,
                       "Inbound Call MUC", 5,
                       "Inside Sales", 1,
                       "Other", 1,
                       "Press Release", 3,
                       "Rep Lead", 1,
                       "Seminar / Conference", 4,
                       "Technical Article", 4,
                       "Top 10", 1,
                       "Tradeshow", 5,
                       "Web", 5,
                       "Organic - Google", 5,
                       "PPC - Google", 5,
                       "Google AdWords", 5,
                        0)
                  +
                CASE (Industry ,
                       "Aerospace", 5,
"Alternative Energy", 5,
"Automation", 3,
"Automotive", 4,
"Batteries", 4,
"Chemicals", 2,
"Communications", 3,
"Computers & Peripherals", 3,
"Contract Mfr", 3,
"Crystal", 2,
"Defense/Military", 4,
"Displays", 4,
"Electronic Components", 4,
"Heating Elements", 3,
"Home Appliance", 2,
"LED", 1,
"Lighting", 3,
"Manufacturing", 1,
"Medical", 5,
"Misc", 1,
"Motors & Coils", 3,
"Nuclear Power", 5,
"Photonics", 4,
"Semiconductors", 3,
"Solar Cells", 5,
"Technology", 1,
"Telecom", 2,
"Tools", 2,
                       0)
                )
         )
  )
Hi there -
 
I'm new (really new!) to formula writing and need some help with a lead scoring formula.
 
What I want to achieve is this (in English):  If the lead status is 'duplicate lead' or 'no potential' score the entire lead as zero.  If the above does not apply and the email address contains 'yahoo,' 'gmail,' 'rr.com,' 'aol,' 'verizon,' 'pacbell' or 'att,' score the entire lead as '1.'  If neither of the above apply, score the lead (see below).
 
Here's what I have so far which works for scoring the leads, but doesn't take the first two IF's into account - I need to move the last IF statement as it isn't working where it is.
 
Can someone help please? 
 
CASE (LeadSource , "Advertising", 1, "Directory Listing (paid)", 3, "Directory Listing (unpaid)", 1, "Email", 4, "E Newsletter", 4, "Inbound Call MUC", 4, "Inside Sales", 1, "Other", 1, "Press Release", 1, "Rep Lead", 1, "Seminar / Conference", 3, "Technical Article", 2, "Top 10", 1, "Tradeshow", 4, "Web", 4, "Organic - Google", 4, "PPC - Google", 4, "Google AdWords", 3,0)+
CASE (Industry , "Solar Cells", 4, "Medical", 3, "Electronic Components", 3, "Automotive", 3, "Alternative Energy", 4, "Batteries", 4, "Aerospace", 3,0)+
 IF( CONTAINS("yahoo:hotmail:gmail:rr.com:aol:verizon:pacbell:att", Email ) , 0, 2)
 
Thanks!
Barbara
 
 


Message Edited by barbkuntz on 11-18-2008 11:47 AM
Hey Folks,
When I select a product from a pricebook, I see its description in the list of products.  I would like to copy that description into the "line description" field in the opportunity-products mini-form.
 
Can anyone give me a tip on how to do this?
 
Thanks,
-Joe