User list sorting question

Hi,

I have 2 plans Free and Paid (VIP). I'd like to sort a user list so that the VIP users to be before the Free ones.

I've made a text field - VIP Subscribed. If a user pays and becomes a VIP member, I've set the CB Fields Integrations settings of the VIP plan as this:



Now I'm successfully sorting the list, but the problem is that if a user's subscription expires or is cancelled the VIP Subscribed field does not change to 0 and the user is still showing among the VIP users on the list.

I think I need an Autoaction but I don't know how to set it.

Could you help me please?

Thank you,
Regards,
ricco

Ensure you're using CBSubs 4.0 RC2. There was a bug with the field not reversing correctly, but we've since fixed that. The only reason for it to bug out now is if there's something happening after the field does a store to cause another user store and result in the value overriding. Are you acting on subscription state with CB Auto Actions? If so try disabling the action and see if it CBSubs toggles the field value properly.

Also note CB 2.x allows you to supply an Advanced Sort By for your userlists now. This means you can add directly to the ORDER BY of the Userlist query your own custom ordering behavior.