Let me see if I understood this correctly.

If the membership gets renewed:

Plan Renewed
Global
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditions
1: [var3] Equal To PLAN_ID_HERE
2: [var2] Equal To A
3: [var7] Equal To R
4: [var9_regular_recurrings_used] Equals to 1
Action
Mode: Add Usergroups
Groups: “CB Month 2”

This means that when the “Classroom” Membership Plan
1: [var3] Equal To 1

is active
2: [var2] Equal To A

and the plan gets renewed
3: [var7] Equal To R

and the renewal is the first time that recurs
4: [var9_regular_recurrings_used] Equals to 1

Member ACL Group “CB Month 2” gets added.
Mode: Add Usergroups
Groups: “CB Month 2”

————————————————

Then I supposed I have to create as many "Auto Actions" as I need to recur, with different variables [var9] from Course 1 to lets say 20?

Thanks

When the member subscribes to "Community" he gets Assigned to ACL group "Registered"

When the member subscribes to the 1 Month "Classroom" plan
he gets assigned to the ACL Group "Classroom"
and also he gets assigned the 1 month course "CB Month 1" through the following action

Plan Activation
Global
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditions
1: [var3] Equal To 1
2: [var2] Equal To A
Action
Mode: Add user groups
Groups: “CB Month 1”

On expiration the ACL Group"Classroom" gets removed
and the ACL Group "CB Month 1" remains active
Just like I wanted. I did not need to use the "Plan Expire Action."

Now for the Renewal

Plan Renewed
Global
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditions
1: [var3] Equal To 1
2: [var2] Equal To A
3: [var7] Equal To R
4: [var9_regular_recurrings_used] Equals to 0
Action
Mode: Add Usergroups
Groups: “CB Month 2”

And then the system reactivates the ACL "Classroom" and adds the ACL Group "CB Month 2"

When it gets expired...

Takes out the ACL "Classroom" and keeps the ACL Groups "CB Month1, CB Month 2"

But here is the thing (The system does not register on the database the numbers of the regular recurrings occurred
so the field [regular_recurrings_used] is always 0 in the database.
That is why the action before worked because I did 4: [var9_regular_recurrings_used] Equals to 0

But now I want to add the ACL Group"CB Month 3" on the next renewal, but the [var9_regular_recurrings_used] stays 0 on the database,
so it does not work.

What should I do?

Thank you

Well, I need this to work in both manual subscriptions and recurring (auto renewals)

This is what I'm doing:

I first make a subscription on the front end using the dummy gateway payment.
Then I check if the ACL groups were correctly assigned.

Then I proceed to the PHPMyAdmin database
and on the database table cbsubs_subscriptions.
I edit the fields "subscription_date", "last_renewed_date" and "exiry_date"
I move them all back 1 month and 1 day. That triggers the expiration.

Then I go back to the site user and make sure the ACL permissions were reassigned correctly.

Then I go back to the front end and proceed to renew the subscription, and then repeat the whole process again.

On this way I can check the manual renewal.
But how can I trigger an auto renewal to make sure that works as well?

Also for the manual renewal I thought exactly about the CB Query Field.
So I created I new field on Community Builder ----> Field Management, but I'm not sure how to set it up.

Which of the 2 suggestions will work best for me, and how can I check them to make sure both manual and auto renewals are working correctly?

Thanks