CiviCRM Community Forums (archive)

I need to develop a way to add relationships via profiles (i.e. when creating a new user in Drupal) and am wondering if I can use a couple hooks & the API

The client for this implementation is a non-profit that serves schools.  When teachers from a school signs up for an account they are going to be asked what school and district they teach in.  I need for both the school and the building to show up as a relationship, the district as the current employer and the school as a custom relationship called something like "school building".  The districts & schools are going to be organizations in civi.  I was thinking that I could create custom field called district & building and use hook_civicrm_customFieldOptions to populate those fields using SQL to pull from civicrm_contact table (which seems to fit with the documentation for that hook and this forum http://forum.civicrm.org/index.php?topic=6918.0).  From there things get tricky I was thinking I could use  hook_civicrm_custom to intercept the data before it gets inserted into the custom table and create relationship using the api, specifically civicrm_relationship_create(&$params ).   Though I wasn't sure if maybe it would be best to use the post or pre hooks

Does this sound doable?

btw, I have developed modules calling the api, but I'm definitely not terribly familiar with the this area of civi

this would be in CiviCRM 2.2, Drupal 6.10+

Lobo,

on point #1, is there another way.  I was assuming I would have to use both, is there a way to have a field only show up in a profile and not in the contact record?


On #3, that's a good point could I use hook_civicrm_post, though the documentation (http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+hook+specification#CiviCRMhookspecification-hookcivicrmpost) says Drupal does not support pre/post hooks.  Is that in reference to Drupal's FAPI?