Counter field for Cbsubs

Hello

I need your help on a subject regarding CBsubs.

We would like to set up a live counter on our webpage with the number of CBsubs subscribers for paying plans only and for a definite country.

So say that we have paying plan ids 6,10, 11 and 12 and that we want to display the number of active subscribers with an address in France for these plans, what would you suggest ?

We would need something live updated at each new subscriber.

Thanks for the hint
Jean

I suppose you could do that with CB Query Field and its Query field then just query for the subscription count to a specific plan and join it with _comprofiler to filter on a country field. You could then display the query field anywhere substitution are supported. The below for example might work.

Thanks

Can we complicate things a little with a drop down list of countries which would display for each country the above count ?
How could we set up things ?

You'd have to use a Code field for that and completely code that usage. I suppose you'd just grab all the counts, place them in an array, then use JS to show/hide the relevant count based off the dropdown value. Sorry, but that's beyond me being able to provide you a simple example.

Ok thanks

One question : is it better to use cb_subs_inv_address_country instead of cb_country ?
Seems like lots of subscribers did not fill the cb_subs_inv_address_country but are required to fill cb_country on registration

One question : is it better to use cb_subs_inv_address_country instead of cb_country ?

cb_subs_inv_address_country is where CBSubs stores the users country, but only if they subscribed to something and completed the invoice address fields. I assume cb_country is your CB field. I suppose it doesn't particularly matter depending on how your site is setup.

Seems like lots of subscribers did not fill the cb_subs_inv_address_country but are required to fill cb_country on registration

In that case I suggest just using cb_country.