Code

I can't find documentation on the Code Drop Down (Multi-Select) field.
I have the following in the code section, but get an error message no matter how I try to configure.
array( '03' => array( '03' => 'Dental' ))
Producing error:
syntax error, unexpected token "}"

My goal is to be able to create an option that uses the name in another cb field to populate. The field is the name of the page.
The option label (Dental) would be the name of the page and the value would be, in this case 3.
I would like to replace the page name (Dental) with the user's cb field value for the page, either using CB code if possible, or do a mySQL query to get the name (Dental) from the field.
I tried: array( '03' => '[cb:userdata field="cb_menulabeldental" user="#displayed" /]' ) but that gave same error.

Also tried [cb:userdata field="cb_menulabeldental" user="#displayed" /] as Label in standard multi-select dropdown and it didn't work

As always - thank for your help.

I was able to get it to somewhat work, but I'm confused as to why first values (03, 04, 05) are shown as the drop down labels when choosing, but the userdata fields show in the list of selected fields once submitted.
I tried to use the cb field instead of 03, but it wouldn't allow it.
Here is what I have so far - for 3 of many pages:

$test1 = array( '03' => '[cb:userdata field="cb_menulabelmedical" user="#displayed" /]', '04' => '[cb:userdata field="cb_menulabeldental" user="#displayed" /]', '05' => '[cb:userdata field="cb_menulabelvision" user="#displayed" /]' );
return $test1;

Thanks again.

CB Code Field and its Code Select just requires valid PHP. If you're getting a syntax error then your PHP isn't valid. It expects an array return as described in the parameters description. Example as follows.



To have grouped options you can supply a nested array as follows.

Sorry Kyle - I do not follow.
The drop down shows the values 3,4 and 5 in the list. When selected and saved, the database show 3|*|4|*|5 - which is correct.
Also when selected and saved, the field shows the labels (Medical, Dental, Vision) - which is correct.

But I want the labels to be shown in the dropdown instead of the value.
When the field is saved it should still show the labels (Medical, Dental, Vision), and the values to be stored in the database (3|*|4|*|5).
Here is what I have, trying to use your response.

return [ '3' => '[cb:userdata field="cb_menulabelmedical" user="#displayed" /]', '4' => '[cb:userdata field="cb_menulabeldental" user="#displayed" /]', '5' => '[cb:userdata field="cb_menulabelvision" user="#displayed" /]' ];

Any help getting this formatted correctly would be greatly appreciated.

Sorry, misunderstood what you were asking! You're using userdata substitutions. That's the same as [FIELD_VALUE] and will output the raw stored value. If you need formatted values be sure to use userfield substitutions. See substitution below for further explanation and examples.

www.joomlapolis.com/documentation/279-community-builder/tutorials/18353-using-substitutions-throughout-cb

So you should be able to just make the following adjustment for example.

FROM: [cb:userdata field="cb_menulabelmedical" user="#displayed" /]
TO: [cb:userfield field="cb_menulabelmedical" user="#displayed" /]

I'm not entirely sure why you're using another field as the label though? Ideally those should probably just be language strings.

Kyle:
I have attached a PDF with screenshots and maybe a better explanation of what I I am trying to accomplish, and why.
Sorry about any confusion, I should have included images to help in understanding from the start.

Again, as always - thank you for your time and your help. It has assisted me in creating a pretty kick-ass site.