function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
dmcguffindmcguffin 

Putting a string together

I have 4 fields that I need to put together in a long string...

 

A picklist field and 3 text fields... what I would love to do is have the output in either a URL field/Formula field, or just a text field... I initially thought that it would be field + field, then I saw the error of my ways as the + is addition :)

 

The output would in theory be (picklist)(text field 1)(text field 2)(textfield 3) with no spaces, the picklist field is a list of multiple URL's that the user can select...

 

any help would be appreciated :)

mstev45mstev45

You will need to use a case formula as you are using a picklist.

 

https://emea.salesforce.com/help/doc/user_ed.jsp?section=help&target=customize_functions.htm&loc=help&hash=CASE

 

The formula field will look something like this,

 

CASE( Yourpicklistfield ,
"WebUrl 1", "WebUrl 1",
"WebUrl 2", "WebUrl 2",
"WebUrl 3", "WebUrl 3",
"Text If False") &Field 1 &Field 2 &Field 3

 

Hopefully this should be of some help.

 

Matt