Note:I tried this only with the LEN function and i hope it works with other formula functions as well. My requirement: I wanted to calculate the length of a couple of fields of data type Text Area, and put the number into a new field. As usual, i created a formula field and used the LEN function. When i tried to INSERT my...
So, i did a data export from salesforce.com and wanted to get the month from a date time field... The general format of DateTime fields is like this 2012-01-15T18:34:00.000Z If suppose you have this in column D in excel, just type in the following formula in an adjacent column Say you do it in E1 =SUBSTITUTE(SUBSTITUTE(D1,”T”,” “),”.000Z”,”") This eliminates the time part and...
VF dashboards
Advanced reporting and Dashboards in Salesforce: Google Visualization with Visualforce
3:35 PM If you haven't yet tried your hand with Google Visualization API's this is the best time to start... Here is the link to the documentation to get started .. http://code.google.com/apis/chart/interactive/docs/reference.html A very cool feature of this is you could generate charts just by passing parameters in the URL. It's as simple as this, click the link https://chart.googleapis.com/chart?cht=p3&chs=450x100&chd=t:30,20,20,15,15&chl=Open|In Progress|On Hold|Pending Confirmation|Closed As you can...