CiviCRM Community Forums (archive)

A problem I'm having came up a few months ago:

You can also enter the Organization name in the Current Employer field when creating the Individual. This will create the employer-employee relationship automatically. HOWEVER, this feature requires that the employer name be entered exactly - and doesn't handle multiple employee organizations with the same name nicely (there's no mechanism for specifying the correct one).

I'm letting users create an individual record for themselves as they sign up for a mailing list through a profile form (I'm not using the built in subscription form because there's other info. I want to collect at the same time). Since some users will belong to an organization that's already registered, it's important that they be given the option of associating their individual record with their organization's record via an 'employee of' relationship. What would be involved in providing a drop down menu of organization records to choose from or autocomplete for the field? Where would I start? I think I would end up with a lot of duplicate organizations if I allowed free text entry because some wouldn't enter the org. name just right.

Great. I added this to CRM/Core/BAO/UFGroup.php, function buildProfile and it seems to work as advertised:

        } else if ($fieldName == 'organization_name' && isset($form->_gid) && $form->_gid == '1') {
            $orglist=array("" => "-- Select --");
            $query = "SELECT `organization_name` FROM `civicrm_contact` WHERE `organization_name` IS NOT NULL";
            $dao = CRM_Core_DAO::executeQuery( $query, CRM_Core_DAO::$_nullArray );
            while ( $dao->fetch( ) ) {
               $orglist[$dao->organization_name] = $dao->organization_name;
            }
            $form->add('select', $name, $title, $orglist );
I also had to make _gid a public variable in CRM/Profile/Form.php.

Thanks again for the help lobo... support here is impressive.

RTPUK,

Hard to tell what's going on, but:

-I am using Drupal 5.7 and CiviCRM 2.0b3

-You have to make _gid public in CRM/Profile/Form.php:

    /**
     * The group id that we are editing
     *
     * @var int
     */
    public $_gid;
otherwise buildProfile can't make use of _gid.

If you do find an easier solution, let me know:)

Actually got the code in the right spot now, I think as I am no longer getting the error message; however there is no drop-down list to select from.  I have checked the query in phpMySQL and have got the right results.

Can you think of anything that I might have to do yet that I haven't?

Thanks

Sorry been a bit slow in working on this. I am not sure what you mean by the gid=1 in my profile? I've just got back on this task and it still seems that i can't get a drop-down list of organisations showing.

everything else seems to be correct. I've set the gid to be public, got the query in the right spot but still can't get it displayed.

help much appreciated