reset rating field?

is there any way to reset a users rating field back to 0 with auto actions after plan expiration? thanks

You can use the below with a Field action to alter the value of a field based off subscription status.

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

Plan Expired
Global
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditions
1: [var3] Equal To PLAN_ID_HERE
2: [var2] Not Equal To A

Can also use CBSubs Fields integration.

Thanks..
im a bit confused about 2 things here..so. if my plan id is 23 then step 1 should look like this
1: [var3] Equal To 23

but step 2 (should i leave it as A or am i supposed to supplement this with something?
2. [var2] Equal To A (is this left as A)

(a am now looking at the action tab within the auto action to set a field action as you noted above the plan settings...i cannot locate any options here to refer to my tab)

3..What are the commands that i need to input to select rating field a,b,c and make the value 0 after expiration? thanks

.....................
you also stated i can so so in cbsubs fields integration..To further understand the configs for field integration in case i wanted to explore

so under fields integration i can see this
CB Fields

---

1. Field = my rating field (cb_hats_rating0
2. Operator = Add: Field = Field + Value
3. value = 0 (if i wanted to add 2 stars would i just make value 2?)
4. remove value on plan deactivation = yes
5. value on plan deactivation = 0

Is this correct?

m a bit confused about 2 things here..so. if my plan id is 23 then step 1 should look like this
1: [var3] Equal To 23

but step 2 (should i leave it as A or am i supposed to supplement this with something?
2. [var2] Equal To A (is this left as A)

All you need to change in the supplied example is the action you're going to use and PLAN_ID_HERE to your actual plan id.

3..What are the commands that i need to input to select rating field a,b,c and make the value 0 after expiration? thanks

Select the field you want to change. Select the operator for how you want to change it (in your case "Set"). Then input the value to change it to (in your case 0).

Is this correct?

No, if you're wanting to set it to 0 then use the "Set" operator, not the "Add" operator.

It's possible just setting the field to 0 won't do the trick and may require you to clear the database table _comprofiler_ratings for that field. So it could require 2 auto actions; 1 to change the field value and 1 to alter the database.