Field concatenation / substitution in profile for CB

I am just wondering how I can concatenate two fields into a single string field and display it in the profile. I assume that I can use the substitution bot and achieve this but is there another way.

Currently I have the following displaying on the profile:

Label 1: Data1 from Field1
Label 2: Data2 from Field2


What I want to achieve is:

(Data1 + Data2) = Data3 <Field3>

Label1: Data3 from Field3

Is this possible within CB.

Regards,

Chris.

You're wanting to actually add the 2 dates together? The only way to do that is either CB Query Field or CB Code Field. You'll have to query for and combine the values in your SQL in a Query field or use PHP to add the two values together in a Code. If you need it actually stored in the database you'll have to use CB Auto Actions and its format functions to try and add the two together. If you just want to display both values in a single field you'd just substitute them into a Custom HTML field.

Thank you for your reply... It was Data1 and Data2 not Date1 / 2.

These are two text fields that I wish to display on the same line rather than one below the other. i.e. in a grid rather than a column.

So yes: " If you just want to display both values in a single field you'd just substitute them into a Custom HTML field." Can you please explain how I would substitute them into a Custom HTML Field please. I have 9 sets of data that I wish to do this for.

Regards,

Chris.

Thank you, I have now sorted this out. I have created a Custom HTML field, [concatenated_field], into which I have placed the 2 fields i.e. [field_1] [field_2] and then hidden this on the profile edit screen. On the profile screen I have hidden [field_1] and [field_2]. The two fields then get substituted into the concatenated field and display as I want.

Great help.

OK, continuing on with this discussion. I now have 3 fields inside a custom html field: [cb_field1] [cb_field2] [cb_field3]

This is fine and displays well, but I wanted to put the 3rd field inside brackets: [cb_field1] [cb_field2] ([cb_field3]) so that I would get something like: "Chris White (UK)" displayed on the profile. Again this works fine so long as the 3rd field is populated. If it is not then you get "Chris White ()" displayed on the profile which does not look very good. I have tried playing around with [cb:if /] statements but can't seem to get anything to work correctly

The last attempt I had was [cb_field1] [cb_field2] [cb:if [cb_field3]!=""]([cb_field3])[/cb:if]

But this did not work either... What am I doing wrong?

Regards,

Chris.

The last attempt I had was [cb_field1] [cb_field2] [cb:if [cb_field3]!=""]([cb_field3])[/cb:if]

Remove the brackets in your IF substitution usage where you've supplied the field and that'll work fine. So it should be as follows.

[cb_field1] [cb_field2][cb:if cb_field3!=""] ([cb_field3])[/cb:if]

Note you're using [FIELD_NAME] substitutions, which are raw database values. If you want them formatted (e.g. in the case of date fields this can be important) then be sure to use [cb:userfield field="FIELD_NAME" /]. Example as follows.

[cb:userfield field="cb_field1" /] [cb:userfield field="cb_field2" /][cb:if cb_field3!=""] ([cb:userfield field="cb_field3" /])[/cb:if]