Link records with logic hooks

[kinshibuya]

Hi,

is there a way to create a relationship between two modules with a logic hook?
I have my custom module and every time i have an one field changed to 'Client' the logic hook will create a record and link it to the account. The modules have a many-to-many relationship.
Is there a way to do this not using SQL?

[jeremy.roberts]

Yes! You should first create the account, then from either the account or your custom module, do

$focus->load_relationship(REL_NAME);
$focus->REL_NAME->add(ID_OF_OTHER_BEAN);

Example:

$focus is an Opportunity

$focus->load_relationship('accounts');
$focus->accounts->add($account->id);

You don't even need to save either been after this. The add() function writes to the relationship table in the database.


That's it! They're now linked!

[kinshibuya]

tyty! thats execly what i was loking for

[Phil77]

Hi everybody,

I am struggling a little with a similar problem:
I want to connect a Lead - created through the WebToLead form - to be automatically added as an attendee of a known meeting ("known" as in: we will compare a date given form a custom field and assign it to an existing event, hence we know the ID of the event - but that's beside the point); what I have figured out is, that I have to create a relationship between the lead and the event.
I tried to implement the above, but I seem to be missing something.

Thanks for your help!
Philip

[andopes]

Hi Philip

Just to make sure your needs: You want to invite the new Lead to an existing meeting, right?
So you just need to add a relationship between them:
As you told before you are able to identify the meeting whose date start matches some date field from form, so:

 $lead->load_relationship('meetings');
$lead->meetings->add($meeting_id); 
  

Cheers

[Phil77]

Thanks André, it worked!
...stupid mistake on my part, but your post helped to identify it!

Thanks, Philip