CiviCRM Community Forums (archive)

How can I make an advanced multiselect field so that the options are taken from the database? The options would be all the mailing list type groups.

I cant find where the options are added to the multiselect element.
I was thinking that if I find that, then I can add a little hack so the options are taken from the civicrm_groups table instead of the civicrm_option_value table...

EDIT:
I found out that in CRM/Core/BAO/CustomField.php there is a variable $selectOptions which seems to be the one I'm looking for. Not sure though...

Great, that's just the thing I needed. I knew there was an easier way to do this.

Thank you Lobo, you're the best


EDIT: This is the code I came up with. It works for me so I'm happy.
It populates the custom field (adv select) with "mailing list" type groups which I use for my event notification emails.
function joomla_civicrm_customFieldOptions( $fieldID, &$options ){
    if ($fieldID == '31'){
        $params=array(group_type=>2);
        $returnValues=array(id,title);
        $options = array();
        $groups = CRM_Contact_BAO_Group::getGroups($params, $returnValues);
        foreach ($groups as $group){
            foreach ($group as $key => $value){
                if ($key == 'id') $option_key = $value;
                if ($key == 'title') {
                    $option_value = $value;
                    // We dont need the values after the title
                    break;
                }
            }
            $options[$option_key]=$option_value;
        }
    }
}