[SOLVED] CB Auto Action to update a field in another table of the DB

Hi,

Could you tell me a CB Auto Acton to update a field which not in the CB or CBSubs tables but is in another table of the same DB.

Let's say I have a CB text field called cb_my_cb_field and its value is getting changed on CBSubs plan change. Then if I have another field which stored in a table which is not in the CB or CBSubs tables how to update its value to be always the same as the cb_my_cb_field?

Thank you,
Best regards,
ricco

Use a Query action then do an update or insert query as needed to push data from 1 table to another. CB Auto Actions can even do this to external databases. Using substitutions you can substitute in your field value for your query. Typically you'll want to do this on the following triggers.

onAfterUpdateUser, onAfterUserUpdate, onAfterNewUser, onAfterUserRegistration

Those triggers will cover profile update and registration for both frontend and backend.

Hi,

CB Auto Action is the greatest.

I've done it (hopefully), here is how:

I have a CB field called e.g. "cb_vip", the value of which is changed to 1 on VIP plan subscription.

Then I've made a CB Auto Action for it like so:

Type: Field
Trigger: Before Draw Subscription
User: Automatic
Access: Everybody
Conditional: [cb_vip] Empty
Action:
Field [cb_vip]
Operator Set (Field=Value)
Value 0

Then I've made another CB Auto Action:

Type: Query
Trigger: Before Draw Subscription
User: Automatic
Access: Everybody
Action: Query:

Thank you CB Auto Action and god bless you,
Regards,
ricco

Not sure is

Trigger: Before Draw Subscription

is the proper trigger to use.

Hi Nick,

Why do you think so?

I've tried User State Change but its not working.

Do you think I should used them both or any other than Before Draw Subscription trigger?

Thank you,
Regards,
ricco

That's not the correct trigger to be using. That trigger is fired when the subscription is displayed. Doing an update query every time a subscription isn't good for performance. You should be using the following usages to act on subscription state change.

Plan Active
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditional 1: [var3] Equal To PLAN_ID_HERE
Conditional 2: [var2] Equal To A

Plan Expired
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditional 1: [var3] Equal To PLAN_ID_HERE
Conditional 2: [var2] Equal To X

If it's a free lifetime plan you're acting on then ensure it's configured to create subscriptions within CBSubs > Settings > Global.

However, if you're doing this on subscription state change it maybe better to just use CBSubs SQL Actions as all you'll need to supply is the query.

If the field value is changed manually then the triggers in my previous reply would be more ideal.