function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
alexander yurpolskyalexander yurpolsky 

Help with a Formele field

So I want to create a Formele field. The Formele  will join 4 text fields one after the other, provided there is a value in the field if there is no value in the Formele  will not add the field.

for example:
Field 1 - Value 1
Field 2 - Value 2
Field 3 - Value 3
Field 4 - Value 4

Result in the  Formula field: Value 1 Value 2 Value 3 Value 4

Field 1 - Value 1
Field 2 - Value 2
Field 3 - blank
Field 4 - Value 4

Result in the Formula field: Value 1 Value 2 Value 4
kamala swarnalathakamala swarnalatha
Hi Alexander,

Try this  code to populate four fields answer in fifth field,

IF(NOT( ISBLANK( Field1__c ) ),Field1__c,""  )   &   IF( NOT( ISBLANK( Field2__c ) ),Field2__c,"" ) & IF(  NOT( ISBLANK( Field3__c ) ),Field3__c,"")  & IF(NOT( ISBLANK( Field4__c ) ),Field4__c,"")

I have created four fields
Field 1 
Field 2
Field 3 
Field 4

Result in the  Formula field Field5: Value 1 Value 2 Value 3 Value 4

User-added image

Thanks,
Kamala
Sweet Potato Tec