HOW TO USE SALESFORCE LONG TEXT AREA FIELDS IN FORMULAS? | Techila
1952
single,single-post,postid-1952,single-format-standard,ajax_updown_fade,page_not_loaded,,qode_grid_1300,footer_responsive_adv,hide_top_bar_on_mobile_header,qode-content-sidebar-responsive,qode-theme-ver-9.4.2,bridge,wpb-js-composer js-comp-ver-4.12,vc_responsive
 

HOW TO USE SALESFORCE LONG TEXT AREA FIELDS IN FORMULAS?

SALESFORCE LONG TEXT AREA FIELDS IN FORMULAS

HOW TO USE SALESFORCE LONG TEXT AREA FIELDS IN FORMULAS?

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 Long Text Area fields, they were not available for selection. I later found out that you cannot use Long Text Area fields in formulas as of now. Hope that it becomes available soon, until then here is a workaround.

Let’s say that I have an object named “MyCustomObject__c”. I want to calculate the sum of the length of the Long Text Area fields Field1__c, Field2__c, Field3__c and put the value into SumofLenght__c

STEP 1: Create a new field on the object MyCustomObject__c named “SumofLenght__c” of datatype “Number”.

STEP 2: Create a new Workflow rule on the object “MyCustomObject__c”

Evaluation Criteria: Every time a record is created or edited

Rule Criteria: MyCustomOject Name: NOT equal to NULL

My Custom Oject Name

STEP 3:

Create a Workflow Field Update as below.

Create a Workflow Field Update

Note: I tried this only with the LEN function and I hope it works with other formula functions as well.

Courtesy:  http://www.forcetree.com/2012/02/how-to-use-salesforce-long-text-area.html

http://www.vasplus.info/tutorials_attachments/expand_and_adjust_textarea_box.gif

“Explore – Techila Global Services, A Salesforce development company”

Author: techila

No Comments

Post A Comment