Salesforce Developer Community

Medhanie Habte
NEWBIE
125 Points
Member since 2014

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
22

Questions
17

Replies

Including commas and and's in formula for combining line items

Hi all,

I have a formula field that I built in a custom object that combines various fields into this one field for a mail merge. The custom object is called Product Donations, and there are about 12 fields referencing various line items that are referenced here.

SUBSTITUTE( 
IF(ISBLANK(NEW_Letters__c),"", Letter_Count__c) 
&IF(ISBLANK(Gators__c),""," "&TEXT(Gators__c) & " handmade gators,") 
&IF(ISBLANK(Paracords__c),"", " "&TEXT(Paracords__c) & " paracord bracelets,") 
&IF(ISBLANK(Cool_Ties__c),"", " "&TEXT(Cool_Ties__c) & " handmade cool ties,") 
&IF(ISBLANK(Phone_Cards__c),"", " "&TEXT(Phone_Cards__c) & " phone cards,") 
&IF(ISBLANK(Battalion_Buddy__c),"", " "&TEXT(Battalion_Buddy__c) & " battalion buddies,") 
&IF(ISBLANK(Comic_Books__c),"", " comic books,") 
&IF(ISBLANK(Magazines__c),"", " magazines,") 
&IF(ISBLANK(Books__c),"", " books,") 
&IF(ISBLANK(Handmade_Cards__c),"", " handmade cards,") 
&IF(ISBLANK(Care_Kits__c),""," care kits,") 
&IF(ISBLANK(Gift_Cards__c),""," gift cards,") 
&IF(ISBLANK(Socks__c),"", " socks,") 
&IF(ISBLANK(Girl_Scout_Cookies__c),"", " "&TEXT(Girl_Scout_Cookies__c) & " boxes of Girl Scout cookies,") 
&IF(ISBLANK(Food_And_Snacks__c),"", " snack foods,") 
&IF(ISBLANK(Toys_Animals_Bears__c),""," assorted toys,") 
&IF(ISBLANK(Beanie_Babies__c),"", " "&TEXT(Beanie_Babies__c)& " Beanie Babies,") 
&IF(ISBLANK(Hats__c),"", " "&TEXT(Hats__c) & " handmade hats," ) 
&IF(ISBLANK(Scarves__c),"", " "&TEXT(Scarves__c)& " handmade scarves,") 
&IF(ISBLANK(Video_Games__c),"", " "&TEXT(Video_Games__c)& " video games,") 
&IF(ISBLANK(CDs_DVDs__c),"", " "&TEXT(CDs_DVDs__c)& " CD's,") 
&IF(ISBLANK(CDs_DVDs__c),"", " "&TEXT(DVDs__c)& " DVD's,") 
&IF(ISBLANK(Candy_lbs__c),"", " "&TEXT(Candy_lbs__c)& " Lbs of candy,") 
&IF(ISBLANK(Assorted_Items__c),""," assorted items,") 
&IF(ISBLANK(Recyclables__c),"", " recyclable items,")& " ", 

",.", 

"" 
)

On the letter count, if there are additional itmes, I notice that a comma does not appear after it, it reads for example letters 1 scarves, 20 paracords, assorted items. Additionally, I am also looking for a way to include the word "and" after the comma if multiple line items exist. In this case, it should read as

letters 1 scarves, 20 paracords and assorted items.

Instead of

letters 1 scarves, 20 paracords, assorted items

Also is there a formula to singularize items that have a 1 in it. For instance 1 scarves should just say scarf.

I can help with any further questions, even set up a trigger if needed.

Hope this helps.

Medhanie Habte
May 11, 2016
Like
0

1 replies

Bypass Salesforce Standard Account Lookup with Visualforce page

Greetings, I have been working on a Visualforce popup page that mimics Salesforce's Contact and Account Lookup Dialog and QuickCreate functionality as part of app I'm building for batch creating records for a custom object.

This VF page, based on Jeff Douglas's Rollup your own Salesforce Lookup Popup enables our users to create Contact records. Now I recently created another lookup like this one for accounts, where when a user types an account or looks up an account to connect a new contact to an existing Salesforce account. I added some Javascript to force the Account lookup to open and run the custom Account lookup I created, however, with the script, I still get the Salesforce standard lookup, where should I place this code (attached below) or what should I add to enable the custom page I built to open.

Hope it helps.

Code for the Visualforce page

<apex:page controller="ContactLookupControl"
  title="Search"
  showHeader="false"
  sideBar="false"
  tabStyle="Contact"
  id="pg">
  <apex:form >
  <apex:outputPanel id="page" layout="block" style="margin:5px;padding:10px;padding-top:2px;">
  <apex:tabPanel switchType="client" selectedTab="name1" id="tabbedPanel">
    <!-- SEARCH TAB -->
      <apex:tab label="Search" name="tab1" id="tabOne"> 
      <apex:actionRegion > 
      <apex:outputPanel id="top" layout="block" style="margin:5px;padding:10px;padding-top:2px;">
        <apex:outputLabel value="Search" style="font-weight:Bold;padding-right:10px;" for="txtSearch"/>
        <apex:inputText id="txtSearch" value="{!searchString}" />
          <span style="padding-left:5px"><apex:commandButton id="btnGo" value="Go" action="{!Search}" rerender="searchResults"></apex:commandButton></span>
      </apex:outputPanel>
   
       <apex:outputPanel id="pnlSearchResults" style="margin:10px;height:350px;overflow-Y:auto;" layout="block">
        <apex:pageBlock id="searchResults">
          <apex:pageBlockTable value="{!results}" var="a" id="tblResults">
            <apex:column >
              <apex:facet name="header">
                <apex:outputPanel >Name</apex:outputPanel>
              </apex:facet>
               <apex:outputLink value="javascript:top.window.opener.lookupPick2('{!FormTag}','{!TextBox}_lkid','{!TextBox}','{!a.Id}','{!JSENCODE(a.Name)}', false);self.close();" rendered="{!NOT(ISNULL(a.Id))}">{!a.Name}</apex:outputLink>    
            </apex:column>
        <apex:column >
              <apex:facet name="header">
                <apex:outputPanel >Account Name</apex:outputPanel>
              </apex:facet>
               {!a.Account.Name}   
            </apex:column>
        <apex:column >
              <apex:facet name="header">
                <apex:outputPanel >Street</apex:outputPanel>
              </apex:facet>
               {!a.MailingStreet}   
            </apex:column>
  <apex:column >
              <apex:facet name="header">
                <apex:outputPanel >City</apex:outputPanel>
              </apex:facet>
               {!a.MailingCity}   
            </apex:column>
 <apex:column >
              <apex:facet name="header">
                <apex:outputPanel >State</apex:outputPanel>
              </apex:facet>
               {!a.MailingState}   
            </apex:column>
 <apex:column >
              <apex:facet name="header">
                <apex:outputPanel >Postal Code</apex:outputPanel>
              </apex:facet>
               {!a.MailingPostalCode}   
            </apex:column>
<apex:column >
              <apex:facet name="header">
                <apex:outputPanel >Phone</apex:outputPanel>
              </apex:facet>
               {!a.Phone}   
            </apex:column>
<apex:column >
              <apex:facet name="header">
                <apex:outputPanel >Email</apex:outputPanel>
              </apex:facet>
               {!a.Email}   
            </apex:column>
          </apex:pageBlockTable>
        </apex:pageBlock>
       </apex:outputPanel>
      </apex:actionRegion>
    </apex:tab>
    <!-- NEW CONTACT TAB -->
    <apex:tab label="New Contact" name="tab2" id="tabTwo">
        <apex:pageBlock id="newContact" title="New Contact" >
          <apex:pageBlockButtons >
            <apex:commandButton action="{!saveContact}" value="Save & Close"/>
          </apex:pageBlockButtons>
          <apex:pageMessages />
          <apex:pageBlockSection columns="2">
              <apex:inputField value="{!Contact.FirstName}"/>
              <apex:inputField value="{!Contact.LastName}"/>
              <apex:inputField value="{!Contact.AccountId}"/>
              <apex:inputField value="{!Contact.MailingStreet}"/>
              <apex:inputField value="{!Contact.MailingCity}"/>
              <apex:inputField value="{!Contact.MailingState}"/>
           <apex:inputField value="{!Contact.MailingPostalCode}"/>
           <apex:inputField value="{!Contact.MailingCountry}"/>
           <apex:inputField value="{!Contact.Phone}"/>
           <apex:inputField value="{!Contact.Email}"/>
          </apex:pageBlockSection>
        </apex:pageBlock>   
        <script>
        if({!Contact.id!=null}){
            //alert('{!Contact.Name} {!Contact.id}');
            top.window.opener.lookupPick2('{!FormTag}','{!TextBox}_lkid','{!TextBox}','{!Contact.Id}','{!JSENCODE(Contact.Name)}', false);self.close();
        }
        </script>
         <script>
var overwriteObj3="001"; var overwriteObjConf="Account";   var overwriteObjC="003"; var overwriteObjConfC="Contact";
function getParameterByName( name ,url){
  name = name.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]");
  var regexS = "[\\?&]"+name+"=([^&#]*)";
  var regex = new RegExp( regexS );
  var results = regex.exec( url );
  if( results == null )
    return "";
  else
    return decodeURIComponent(results[1].replace(/\+/g, " "));
}

var lookupPickOrig=null;
$(document).ready(function(){
$("body").bind("OnRenderDone",function(){
    if(lookupPickOrig==null){
        lookupPickOrig= openLookup;//save old function if needed
    }
    openLookup=function(a, b,c, d,e,f,g,l){//overwrite with your custom code
    //alert(a+"~"+b+"~"+c+"~"+d+"~"+e+"~"+f+"~"+g+"~"+l);
    var ax=a;
    if(ax.indexOf("lktp=001”)>-1){
        var lknm=getParameterByName("lknm",ax);
        var lkfm=getParameterByName("lkfm",ax);
        var lksrch=getParameterByName("lksrch",ax);
        //alert(b+"~"+c+"~"+d+"~"+e+"~"+f+"~"+g+"~"+l);
        ax="/apex/AccountLookupControl?"+(ax.split("?")[1]+"&frm="+escape(lkfm)+"&txt="+escape(lknm)+d);
//        lookupPickOrig(ax, b,c, d,e,f,g,l);
        window.open(ax,"_blank","width=690,height=690");
    }else{
        lookupPickOrig(ax, b,c, d,e,f,g,l);
    }
    //put your code here
    }
});
});
</script>
    </apex:tab>
  </apex:tabPanel>
  </apex:outputPanel>
  </apex:form>
</apex:page>

The Script that should open the custom popup and bypass the standard Salesforce account lookup dialog

<script>
var overwriteObj3="001";
var overwriteObjConf="Account";
 
var overwriteObjC="003";
var overwriteObjConfC="Contact";

function getParameterByName( name ,url){
  name = name.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]");
  var regexS = "[\\?&]"+name+"=([^&#]*)";
  var regex = new RegExp( regexS );
  var results = regex.exec( url );
  if( results == null )
    return "";
  else
    return decodeURIComponent(results[1].replace(/\+/g, " "));
}

var lookupPickOrig=null;
$(document).ready(function(){
$("body").bind("OnRenderDone",function(){
    if(lookupPickOrig==null){
        lookupPickOrig= openLookup;//save old function if needed
    }
    openLookup=function(a, b,c, d,e,f,g,l){//overwrite with your custom code
    //alert(a+"~"+b+"~"+c+"~"+d+"~"+e+"~"+f+"~"+g+"~"+l);
    var ax=a;
    if(ax.indexOf("lktp=001”)>-1){
        var lknm=getParameterByName("lknm",ax);
        var lkfm=getParameterByName("lkfm",ax);
        var lksrch=getParameterByName("lksrch",ax);
        //alert(b+"~"+c+"~"+d+"~"+e+"~"+f+"~"+g+"~"+l);
        ax="/apex/AccountLookupControl?"+(ax.split("?")[1]+"&frm="+escape(lkfm)+"&txt="+escape(lknm)+d);
//        lookupPickOrig(ax, b,c, d,e,f,g,l);
        window.open(ax,"_blank","width=690,height=690");
    }else{
        lookupPickOrig(ax, b,c, d,e,f,g,l);
    }
    //put your code here
    }
});
});
</script>

Medhanie Habte
April 08, 2016
Like
0

0 replies

assign a contact to a Person Account (Silly Question?!)

Greetings our organization uses the Nonprofit Starter Pack and currently works with Person Accounts, one of the issues we run into with our accounts and contacts is that some there are instances in which we want to assign a contact to a record that may be a person account. For instance we have companies and businesses that do not provide an individual representative that come to our organization, so we simply create a contact record for that organization.

This allows us to send emails or generate correspondence in some of our reports. On some occassions, we will then receive a contact representative who is affiliated with the organization and we want to assign to a person account record that already exists, however, the trigger force-renames the account, which we don't want. In essence, we want to be able to assign a contact to an already existing account, even if that account may be a person account. Is there a trigger to address.

I've include a video to demonstrate here.
http://screencast.com/t/LE7AybwbAon

Hope it helps.

Medhanie Habte
March 04, 2016
Like
0

0 replies

External Data Source types

Greetings I am trying to determine how to have certain type picklist values appear in my External Data Source options. In my developer account I see FilesConnect, in my standard account I simply see LightningConnect. Is this a matter of having to purchase certain applications. Hope it helps.
User-added image

Medhanie Habte
December 24, 2015
Like
0

0 replies

External Data Source picklist values

Greetings I am trying to determine how to have certain picklist values appear in my External Data Source options. In my developer account I see FilesConnect, in my standard account I simply see LightningConnect. Is this a matter of having to purchase certain applications. Hope it helps.

User-added image

Medhanie Habte
December 24, 2015
Like
0

1 replies

Uploading Attachment files when creating a record

Greetings, I am trying to determine a way to be able to upload attachments when creating a record, as opposed to having to do so after the record has been created. The purpose here is that our organization is using a table grid to create records and we want to able to input an attachment prior to getting the record created. Is this possible? Hope it helps.

Medhanie Habte
December 21, 2015
Like
0