Salesforce Implementations

Dynamic Component with Rerender issue

2014-09-01T11:43:00.000+05:30

Issue:

Dynamic Visualforce Component feature causing issues with reRender if the component being reRendered , because of this we will loose the values which was filled in that section in case if we refresh the same section based on Ajax action.

I hope even though if we are using dynamic visualforce components we should have the view state in the partial refresh. Dynamic in the sense is not only just displaying the components on the fly, along with that we should have all the platform features available but we are not getting those. To hold the old values in case of AJAX rerendering we should have our own way of scripting which is bizarre.

I hope salesforce is not doing the dynamic components really dynamic, we should right our own scripts to hold the old values in case of new section creations using dyaminc components feature......

I did my own way of scripting to hold the values and happy to share the solution incase if any one in need.

Here is the information from salesforce
http://help.salesforce.com/apex/HTViewSolution?id=000170864&language=en_US

Thank you....

Continued... Salesforce URL Hacking to Prepopulate Fields on a Standard Page Layout using Tooling API

2014-03-07T12:58:00.003+05:30

Here are the pros and cons using Tooling API in force.com development purpose. In my earlier post here to get the CustomField Ids and auto populate some of the CustomObject field values on Standard layout I used Tooling API to get it done. But......

Cons:

1. This process won't work other Salesforce users apart from Admins or equivalent privileged users only. This is no where documented, but this API meant for external languages to build tools for force.com, in this way some what very clear that we should be careful while using these type of APIs.

2. Only work with CustomFields on CustomObjects

Pros:

1. Not required to store the static CustomField Ids in a CustomSettings or CustomObject.

2. Not required to hack the URL with static CustomField Ids.

So I did a work around as inserting the Tooling API information in a CustomObject so that I can use this CustomObject to fetch the fieldIds and auto populate the values for the same for Salesforce users who are not admins.

Happy coding.....

Salesforce URL Hacking to Prepopulate Fields on a Standard Page Layout using Tooling API

2014-03-04T13:02:00.000+05:30

To build Salesforce URL’s to standard pages for creating records, that can be applied to Custom Buttons in order to pre-populate field values when a user clicks a button native using Tooling API.

Tooling API support for Custom Object and Custom Fields

This can query (REST or SOAP) the CustomObject and CustomField objects (which are not accessible via Apex SOQL).As we know every object in Salesforce has an ID and thia API has the means to obtain the custom field Id’s.

We have Apex wrapper for the Tooling API which can referred here

I tried to use the REST and getting a CustomObject's CustomFields Ids by using the below approach..

This code is just my work according to my requirement and can be extended up to your requirements..

NOTE: This supports only for CustomObjects and CustomFields.

To test this send the object name to the below method.

FieldIdUtil.findFieldIds('CustomObjectName') //Don't Append '"__c" for example

FieldIdUtil.findFieldIds('Implementation') //Don't Append '"__c"

You should give the object name but not the API name

This method will return map of custom fields with the respective field IDs from which we can grab the fields what ever we want to pre-populate

1. Consider the objectname is 'Implementation' and the fields in this are 'Field1', 'Field2';

1:  public class FieldIdUtil   
2:  {  
3:       public Static Map<String,String> fieldIdsMap = new Map<String,String>();  
4:       public Static String objectId; 
         
         public static List CustomApexTypes = new List();
 
 public class CustomApexType
        {
           public String Id;
           public String DeveloperName;
        }

5:       public static Map<String,String> findFieldIds(String ObjectName)   
6:    {  
7:         String objectIdQuery = 'Select Id From CustomObject Where DeveloperName = \''+ObjectName+'\'';  
8:      sendCallout(objectIdQuery, true);  
9:      if(objectId != null)  
10:      {  
11:        String fieldIdsQuery = 'Select Id, DeveloperName From CustomField Where TableEnumOrId = \''+objectId+'\'';  
12:        sendCallout(fieldIdsQuery, false);  
13:      }  
14:         return fieldIdsMap;  
15:       }  
16:       private static void sendCallout(String query, boolean flag)  
17:       {  
18:            String strIdValue,devName;  
19:            HttpRequest req = new HttpRequest();  
20:      req.setHeader('Authorization', 'Bearer ' + UserInfo.getSessionID());  
21:      req.setHeader('Content-Type', 'application/json');  
22:      String environmentURL =   
23:          URL.getSalesforceBaseUrl().toExternalForm() + '/services/data/v28.0/tooling/query/?q=' + EncodingUtil.urlEncode(query, 'UTF-8');  
24:      req.setEndpoint(environmentURL);  
25:      req.setMethod('GET');  
26:      Http h = new Http();  
27:      HttpResponse res = h.send(req);  
28:      JSONParser parser = JSON.createParser(res.getBody());  
29:      while (parser.nextToken() != null)
  {
      if ((parser.getText() == 'records'))
      {
          parser.nextToken();
  
          CustomApexTypes = (List<CustomApexType>)parser.readValueAs(List<CustomApexType>.class);
      }
  }  
64:   }  
65:  }

The below code will generate the URL and the parameters from the above methods and do the redirect to a standard page by auto populate the specified values

1:  public PageReference doredirect()  
2:    {  
3:         Map<String,String> fieldIdsMap = new Map<String,String>();  
4:          Set<String> fieldAPINames = new Set<String>  
5:        {'Field1','Field2'};  
8:         fieldIdsMap = FieldIdUtil.findFieldIds('Implementation');//Passing the custom object name  
9:         PageReference pr = new PageReference(URL.getSalesforceBaseUrl().toExternalForm() + '/' + Implementation__c.SObjectType.getDescribe().getKeyPrefix() + '/e');  
10:         Map<String, String> params = pr.getParameters();  
           //we will be able to get the Master or Lookup id like this '00N11000000GysA' but inorder to refer in page we should add "CF"
            to the ID"
11:         //params.put('CF00N11000000GysA', Opp.Name);  // if you have parent object like opportunity we need to do this bit
12:      //params.put('CF00N11000000GysA' + '_lkid', Opp.Id);  // if you have parent object like opportunity we need to do this bit

13:         for(String fieldAPIName : fieldAPINames)  
14:         {  
15:           params.put(fieldIdsMap.get(fieldAPIName), (String) Opp.get(fieldAPIName));  
16:            }  
17:         params.put('saveURL',opp.id);  
18:      params.put('retURL', opp.id);  
19:         pr.setRedirect(true);   
20:         system.debug('*************' + pr);  
21:         return pr;  
22:    }

This is just my initial thoughts and worked solution for me ..There may be some changes and best practices you may found to change in this code....

here is my experience in making this solution before taking to Production.

Direct download an attachment from a link in Visualforce page

2013-09-27T17:26:00.000+05:30

In many cases we need to download a file instead of opening the same.

A simple HTML5 trick to do the same like below



{!attachment.name}

(this will simply open the file)

here main attributes are we should have docType="html-5.0" and download="{!attachment.name}" for the respective components as highlighted above...

Here I used the standard controller you can construct the same using controllers/Extensions to achive the same.

Happy coding...........

Drop-down button in a Visualforce Page

2013-08-21T11:36:00.000+05:30

creating a drop-down button in a vf page..this is simple hack using standard salesforce styles

Code:
<apex:page>

  <div class="menuButton" id="MyMenu">

    <div class="menuButtonButton" id="MyMenuButton">

       <span id="menuLabel" tabindex="0" style="">MyMenu</span>

    </div>

    <div class="menuButtonMenu" id="MyMenuMenu">

      <a href="/" class="menuButtonMenuLink firstMenuItem">Left VoiceMail</a>

      <a href="/" class="menuButtonMenuLink">Call in 1 day</a>

      <a href="/" class="menuButtonMenuLink">Call in 3 day</a>
      <a href="/" class="menuButtonMenuLink">Call in 5 day</a>

    </div>

  </div>
<script type="text/javascript">new MenuButton('MyMenu', false);</script>
  
</apex:page>

you can associate the actions by replacing the anchor tags with commandlinks or use ajax

Happy coding.....

Standard Salesforce DatePicker not working?

2013-08-02T12:47:00.002+05:30

Some times Visualforce page with rerender sections, that standard DatePicker field based on Date or DateTime inputField tag was not working?

This was happend to me recently when I am developing some vf page. For this, a small hack that we can use is

if you have any field which is date or datetime, try to create the block which executes on every load with out and conditional renderings . This will allow to initialize the script and works for our custom inputField in vf page..

<div style=”display:none”>
<apex:inputField value=“{!Account.Date_field__c}”/>
</div>

if you don't have any field which is date or datetime on the standard controller then create a property for the extension if you have any(if not you may need to created a date field on the standard controlller..but this doesn't make sense...in order to cover an issue we are not supposed to create field..) which contains a set up object date or datetime field and make use of the same. like

public opportunity oppObj {get;set;}

<apex:inputField value="{!oppObj.closeddate}" rendered="false"/>

Hope this will help those we stuck with this kind of issue...Thank you.

Setting Id Fields on sObjects for Updates

2013-07-05T18:18:00.002+05:30

Starting with Apex code saved using Salesforce.com API version 27.0, the Id field is now writeable

list<Account> lstA = [select id,name from account limit 1];
Account a1 = new Account();
a1.id = lstA[0].id;
a1.name = 'update through ID';
update a1;

but attempting to insert these sObject instances results in an error.

Extend the default Number object with a formatMoney() method

2013-06-17T12:37:00.000+05:30

// usage: someVar.formatMoney(decimalPlaces, symbol, thousandsSeparator, decimalSeparator)
// defaults: (2, "$", ",", ".")
Number.prototype.formatMoney = function(places, symbol, thousand, decimal) {
places = !isNaN(places = Math.abs(places)) ? places : 2;
symbol = symbol !== undefined ? symbol : "$";
thousand = thousand || ",";
decimal = decimal || ".";
var number = this,
negative = number < 0 ? "-" : "",
i = parseInt(number = Math.abs(+number || 0).toFixed(places), 10) + "",
j = (j = i.length) > 3 ? j % 3 : 0;
return symbol + negative + (j ? i.substr(0, j) + thousand : "") + i.substr(j).replace(/(\d{3})(?=\d)/g, "$1" + thousand) + (places ? decimal + Math.abs(number - i).toFixed(places).slice(2) : "");
};
var n = new Number(12000);
document.getElementById('{!$Component.lblMoney}').value=n.formatMoney(2, "$", ",", ".");

Some useful links: http://josscrowcroft.github.io/accounting.js/

Salesforce to Acquire ExactTarget

2013-06-04T21:32:00.004+05:30

Here is the info....

http://dealbook.nytimes.com/2013/06/04/salesforce-to-buy-exacttarget-for-2-5-billion/?ref=technology

Dreamforce #DF13

2013-05-27T15:48:00.000+05:30

JOIN THE CUSTOMER COMPANY REVOLUTION --> DF13

2013-05-24T10:57:00.000+05:30

Google I/O keynote..amazingly terrific.....

Please watch here Google 2013 I/O keynote

NO_MASS_MAIL_PERMISSION, Single email is not enabled for your organization or profile issue in salesforce

2013-05-23T17:22:00.001+05:30

This issue will generally come from spring13 release, when you refreshed a full sandbox and trying to send e-mails via Apex this may lead you to an issue saying that
"NO_MASS_MAIL_PERMISSION, Single email is not enabled for your organization or profile. Single email must be enabled for you to use this feature".

To get rid of this issue

go to Administer > Email Administration > Deliverability and then you will have options to select like No access,System email only, All email. select All email from the list.

• No access: Prevents all outbound email to and from users.

• System email only: Allows only automatically generated emails, such as new user and password reset emails.

• All email: Allows all types of outbound email. Default for new, non-sandbox organizations.

You have uncommitted work pending. Please commit or rollback before calling out issue workaround in salesforce

2013-05-13T14:42:00.002+05:30

Sometimes we need to create a record and then update it with information provided by a Web Service. However,a Web Service Callout may not occur after a DML statement within the same transaction.To achieve the required action, the transaction must be separated into two parts so that the DML transaction is completed before the Web Service Callout occurs and one workaround like below.

<apex:page controller="WsCalloutTest" tabstyle="Account">
    <apex:form >
        <apex:actionFunction action="{!firstcall}" name="firstcall" Rerender="statuses" status="Status1" oncomplete="WebServiceCall();"/>
        <apex:actionFunction action="{!WebServiceCall}" name="WebServiceCall" status="Status2" reRender="statuses, msg"/>
        <apex:outputPanel id="statuses">
            <apex:actionStatus id="Status1" startText="...Inserting Record Into DB..." />
            <apex:actionStatus id="Status2" startText="...Calling Web Service..." />
        </apex:outputPanel>
        <apex:outputPanel id="msg">
            <apex:pageMessages />
        </apex:outputPanel>
        <div><input name="DoAction" class="btn" type="button" value="Do Action" onclick="firstcall();return false;"/></div>
    </apex:form>
</apex:page>

public class WsCalloutTest{
    
    Contact myContact;
   
    public PageReference firstcall() {
        myContact = new Contact(name = 'Test Contact');
        insert myContact;
        return null;
    }
    
    public PageReference WebServiceCall() {
        
        // Execute a call to a Web Service
        HttpRequest req = new HttpRequest();
        req.setEndpoint('http://yourserviceurl.com?id=' + myContact.Id);
        req.setMethod('GET');
        HttpResponse response = new Http().send(req);
        myContact.Name = 'Test Contact 2';
        update myContact;
  //if the update is successfull
        ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.CONFIRM, 'WebService Called on New Contact: ' + myContact.Name));
        return null;
    }
}

Number to Word conversion using Salesforce Apex

2013-05-02T17:48:00.000+05:30

1:  public with sharing class NumberToWord {  
2:      static String[] to_19 = new string[]{ 'zero', 'one',  'two', 'three', 'four',  'five',  'six',  
3:      'seven', 'eight', 'nine', 'ten',  'eleven', 'twelve', 'thirteen',  
4:      'fourteen', 'fifteen', 'sixteen', 'seventeen', 'eighteen', 'nineteen' };  
5:    static String[] tens = new string[]{ 'twenty', 'thirty', 'forty', 'fifty', 'sixty', 'seventy', 'eighty', 'ninety'};  
6:    static String[] denom = new string[]{ '',  
7:      'thousand',   'million',     'billion',    'trillion',    'quadrillion',  
8:      'quintillion', 's!xtillion',   'septillion',  'octillion',   'nonillion',  
9:      'decillion',  'undecillion',   'duodecillion', 'tredecillion',  'quattuordecillion',  
10:      's!xdecillion', 'septendecillion', 'octodecillion', 'novemdecillion', 'vigintillion' };  
11:    // convert a value < 100 to English.    
12:   public static String convert_nn(integer val) {  
13:      if (val < 20)  
14:        return to_19[val];  
15:      if(val == 100)  
16:          return 'One Hundred';  
17:      for (integer v = 0; v < tens.size(); v++) {  
18:        String dcap = tens[v];  
19:        integer dval = 20 + 10 * v;  
20:        if (dval + 10 > val) {  
21:          if (Math.Mod(val,10) != 0)  
22:            return dcap + ' ' + to_19[Math.Mod(val,10)];  
23:          return dcap;  
24:        }      
25:      }  
26:      return 'Should never get here, less than 100 failure';  
27:    }  
28:    // convert a value < 1000 to english, special cased because it is the level that kicks   
29:    // off the < 100 special case. The rest are more general. This also allows you to  
30:    // get strings in the form of "forty-five hundred" if called directly.  
31:    public static String convert_nnn(integer val) {  
32:      String word = '';  
33:      integer rem = val / 100;  
34:      integer mod = Math.mod(val,100);  
35:      if (rem > 0) {  
36:        word = to_19[rem] + ' hundred';  
37:        if (mod > 0) {  
38:          word += ' ';  
39:        }  
40:      }  
41:      if (mod > 0) {  
42:        word += convert_nn(mod);  
43:      }  
44:      return word;  
45:    }  
46:    public static String english_number(long val) {  
47:      if (val < 100) {  
48:        return convert_nn(val.intValue());  
49:      }  
50:      if (val < 1000) {  
51:        return convert_nnn(val.intValue());  
52:      }  
53:      for (integer v = 0; v < denom.size(); v++) {  
54:        integer didx = v - 1;  
55:        integer dval = (integer)Math.pow(1000, v);  
56:        if (dval > val) {  
57:          integer mod = (integer)Math.pow(1000, didx);  
58:          integer l = (integer) val / mod;  
59:          integer r = (integer) val - (l * mod);  
60:          String ret = convert_nnn(l) + ' ' + denom[didx];  
61:          if (r > 0) {  
62:            ret += ', ' + english_number(r);  
63:          }  
64:          return ret;  
65:        }  
66:      }  
67:      return 'Should never get here, bottomed out in english_number';  
68:    }  
69:  }

This will work for integer range values

Social.com

2013-04-24T12:24:00.000+05:30

Today Salesforce announced new advertising service for social networks---www.social.com

Field Label trick in Salesforce

2011-04-14T17:16:00.000+05:30

If you insert <br> into a field name, it will insert a return on the name making it two lines. This solves a long standing irritation list views where there was a long label, but short content.

Comparing object field values in the WHERE clause in Salesforce

2011-04-13T23:08:00.000+05:30

SOQL does not currently support comparing same object field values in the WHERE clause, but there's simple workaround

First, create a formula field Flag__c on the SObject that performs the same comparison function as the desired WHERE clause.
IF (OwnerId == CreatedById, "true", "false")