CB Auto Actions/CB Subs SQL on registration.

Hi,

I have a component that is annoyingly always asking for a choice between employer and Job seeker.

I think it would be possible but not completely sure yet (also I have now understood that CB Subs contains CB Auto Actions and thus both should be reasonably similar in function).

Can I add upon Registration (OnAfterRegistration) an Auto action that changes in SQL that user gets registered as JOB SEEKER (I would then simply set all the existing users as Job Seekers as well by triggering it manually)

In CB Subs, I would like to add a subscription which triggers an SQL change that marks the user as EMPLOYER.

Would work in theory no?

Tim,

I do something similar with our membership. On the Integrations / SQL Actions for the specific plan, I set default values for a user when they Activate (New User). In the SQL Action 1 area and in the Activation box, I have the following SQL code:

UPDATE xxxxx_comprofiler a
SET
a.cb_role = "None",
a.cb_ccph = "No",
a.cb_agencytype = "None",
a.cb_mbranniversary = CURDATE(),
a.cb_membershiplevel = "Government Individual",
a.cb_mbrtype = "Member"
WHERE
a.user_id = [user_id];

Make sure you have the CBSubs SQL actions installed in Community Builder and they are published. Hope this helps.

Thanks,
Joe

Awesome, thanks Joe.

If you're changing a field use a Field action in CB Auto Actions to do this or in CBSubs use CBSubs Fields. I do not recommend direct database queries for changing field values.

CB Auto Actions has an Internal > Users trigger that can loop the action for every user or for the specified user ids. This can be used for your mass processing functionality.