You need to sign in to do that
Don't have an account?
dmcguffin
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.
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