What are "CBSUBS fields" ?

CBSubs supports multiple subscriptions, donations and merchandises per user, so it's not really a field

You could use a CB field and CB field integration plugin to reflect the state of the subscription(s) active/expired in a CB field, and simply export that with CB Juice.

Or you could use SQL integration plugin to do specific database changes to your newsletter status for the user, on plan expiry.

duce501 wrote:

OK, that worked BEAUTIFULLY, I just added some fields in CB and used the CB intergrations plugin you suggested under the CB Paid Suscriptions > Integrations > CB Fields.

This populates the field as I need it too, and I can just exprt with CB Juice.

However, when the account expires, it just removes all the text from that field (as set in the remove value on plan deactivation). How do I get it to remove "active" and replace with "expired"?

great.

Actually if you use a multi-checkbox field instead of a text field, it will not remove ALL the values, but ONLY the value corresponding to that subscription.

*adding* a value to a field on *expiry* is an interesting feature-request.

Wrote it down for a future release.
#1250

In the mean time, you could help yourself with the SQL query integration plugin and do a query to add that text on deactivation (expiry or cancellation).

Take a look at example queries in the "SQL actions" sub-forum.