[SOLVED] Auto Action for Managing Connections: database trigger

First and foremost,

Thanks for all the great support! I plan to comment / donate etc as soon as I dig out from a mountain of work.

Case setup:

1. User Type: Event Creator. Registers and logs in thru CB. They then create a event using a extension called Ohanah. Event Creator now has a) CB profile and b) Ohanah event

2. User Type: Athlete. Registers and logs in thru CB. They register and pay for the above event (using Ohanah).

I would like to create a trigger using Auto Actions to automatically make the CB profile connection between Event Creator AND Athlete

This would save the confusion of making the athlete (after registering) to go to the event creator profile and connect manually.

site: www.wodrocket.com/pivot

you can login as:
- demo Event Creator login: demo/demo123
- demo Athlete login: demo1/demo123

CB Auto Actions has a Connections action to do this, but you need some sort of way that CB can see (CB Query Field, field value, etc..) a connection between the two users already as it needs the user id of the user you want to connect to. You could then fire it on login trigger for example.

I knew you would have a idea. That is a great idea. Let me play with it and I will post back with (hopefully) solution and (perhaps) follow up questions.

Ok I am still trying to get my small brain around this one and I'm hoping you can give me some coaching.

Example:

Event Creator A creates a event in Ohanah. The event is located in table _ohanah_events table
Event Creator A also has a profile in _comprofiler

Athlete B registers for a event in Ohanah. The registration is located in table _ohanah_registrations (along with the Event Creator User Id in the same row)
Athlete B has a a profile in _comprofiler

If I understand your last post correctly, I need a field set up to catch (thru triggers) all events Athlete B has registered for. In this example Athlete B would have Event Creator's ID in that field.

I just can't figure out how to create that field.

Thanks again.

You need to create a relationship between ohanah and the user. Ohanah isn't creating one so you need to. To do this you'll need something like CB Query Field to query ohanah database and output some sort of result so you know the user belongs to an event or an athlete, whatever is needed. You'd then use that to condition your auto action.

LOL CB noob. I have been killing myself to find the query field. YEP it is a plugin. Now Houston, we are a go!