[#5963] CBSubs info in a CB Field

We have an unusual issue.

We need to be able to populate fields with 2 obscure CBSubs database fields.

1. We need the month of subscription expiration for active members (not the year, just the month).
2. We need the $ amount of their subscription in a single field.

The reason why we need these items separated is that we are using an Excel download tool and the admins need to isolate active members by their expiration month, and they need to see the $ amount of the subscription in a separate field.

Any ideas? Could we use the Query field tool for this?

J - 3.6.5
CB - 2.1.0
Subs - 4.1.0

CB Query Field can certainly grab those values from the _cbsubs_subscriptions database (note how much they paid is in _cbsubs_baskets tied to the basket which is tied to the subscription), but if whatever tool you're using to turn this into excel depends on the value being in _comprofiler it won't work as query fields don't store anything. You can substitute in CBSubs information regarding a users subscription using the below.

[cbsubs:subscriptions plan="PLAN_ID_HERE" output="price" /]

For price you'd have to just grab that information about the plan it self using the below.

[cbsubs:plans plan="PLAN_ID_HERE" output="expiry_date" /]

This only works for locations that content prepare usage is enabled though. So it'd work in Custom HTML fields, etc.. You could combine this with CB Auto Actions and a Field action to set the value of a field to the values you're needing, but be sure to enable content prepare for the action under parameters.

Thanks! We're going to try make this work.

OK, so we are battling to make this work . I feel like we're really close.

We created an AutoAction that populates a searchable field. We can get it to work fine for simple cb info like date and user ID...
But the string you gave us does not produce a result. It just displays the string back to us.

Attached is an image using with [user_id]:
And another using [cbsubs:subscriptions plan="PLAN_ID_HERE" output="price" /]

Any ideas? Maybe there is a switch we need on is CBSubs to enable this kind of integration?

You need to enable content prepare and ensure you've the latest CB and CBSubs installed. To enable content prepare ensure within your auto action under Parameters that "Content Plugins" is set to "Yes". Note you will need to trigger the action again as the value you're seeing is already stored. You also need to replace PLAN_ID_HERE with of course the plan id you're wanting to check for.

OK, progress. It's reading the string now, but not displaying anything. Is there somewhere where I can see all the CBSubs - Substitutions?