[SOLVED] CB Auto Actions Renewals on CBSubs

Great!
How do I setup the CB Query Field?

I could't find the right example on the CB Query video tutorial on youtube

You'll need to review the _cbsubs_subscriptions and possible _cbsubs_baskets database tables and make a query that checks for baskets and subscriptions. Single payments (non-recurring) generate a new basket with each payment. Recurring do not and will just increment the regular_recurrings_used for their subscription row on renewal. It's significantly more complicated to go this approach vs just chaining a few auto actions together.

I'm sorry but you lost me. I do not know how to do this.

Action 1
Access: CB Month 3
Groups: CB Month 4

Action 2
Access: CB Month 2
Groups: CB Month 3

Do I add these actions to the ones I already have?
Do I delete the actions I already have and make new ones?
The Access Parameter?
What type? What condition? What action?

I wish I was more well versed on this language you are speaking, but I'm not.
Can you please be more specific?

Lets for example say you want this to go on for 3 months. You'd need the below actions to do this.

Action 1
Global
Triggers: onCPayUserStateChange
User: Automatic
Access: CB Month 2
Conditions
1: [var3] Equal To PLAN_ID_HERE
2: [var2] Equal To A
3: [var7] Equal To R
Action
Mode: Add Usergroups
Groups: CB Month 3

Action 2
Global
Triggers: onCPayUserStateChange
User: Automatic
Access: CB Month 1
Conditions
1: [var3] Equal To PLAN_ID_HERE
2: [var2] Equal To A
3: [var7] Equal To R
Action
Mode: Add Usergroups
Groups: CB Month 2

Action 3
Global
Triggers: onCPayUserStateChange
User: Automatic
Access: Registered
Conditions
1: [var3] Equal To PLAN_ID_HERE
2: [var2] Equal To A
3: [var7] Equal To R
Action
Mode: Add Usergroups
Groups: CB Month 1

The order of these actions is very important as they execute in order. So what will happen is when the user renews for the first time Action 3 will execute. This will give them the CB Month 1 usergroup. On their second renewal Action 3 and Action 2 will execute. Action 3 will be skipped since they already have that usergroup. Action 2 sees that they are a member of CB Month 1 usergroup thanks to the Access parameter and it then gives them CB Month 2. You can chain this for as long as you want.

This works great!!

Now, are you sure this will work in auto renew as well?
Without having to add any other action?

Thanks,

Yes, it doesn't matter if it's a single payment or recurring payment.