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

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 :)


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


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.