Need help with cbsubs and a dynamic field

Hello this is my website:

exchangemailstat.com

On the registration form, there are four plans, Free trial, Basic, Pro, and Enterprise.

And then there's a dynamic field "No. of Employees"

If the no. of employees entered by the user is 50 or less, the basic membership should be selected.
250 or less = pro
more than 250 = enterprise.

My problem is, I need a validation script wherein if registrant selected Basic subscription, and he entered 200 employees, Pro subscription must be automatically selected.

Another problem, the cost depends on the number of employees entered, for example Pro costs $3.99 per user / month. SO what happens is that --> (No. of Employees) * Cost = Total Amount / Month.

So if 200 employees is entered, that is 200 * $3.99 = total amount to be paid.

I purchased Professional SUbscription since Sir Beat mentioned about CBQuery which will help me on this problem.

I look forward to your replies.

THank you.

I guess this is a similar request to here:
www.joomlapolis.com/forum/87-presales/180309-cb-subs-different-price-to-different-users#180793

So maybe the solution i proposed could also work for you (until we make it simpler setting) ?

hello. from my previous thread, you said i can use the cbquery plugin? which i think is now the cbaction or something like that?

how can i use that to validate the field and multiply it to get the total amount?

please explain it to me like im a 10 years old


OFFTOPIC:

Do you have themes for the cbsubs? Is there any way I can edit the way the plans are shown?

here's my site: exchangemailstat.com

Thank you

CB Query field would allow you to do the calculation for the markup from the other cb_employees field using a SQL query, like:

----

CBSubs is templatable in frontend in almost every aspect, and templates are overridable in joomla template too. There is the rounded template that is delivered in CBSubs package that you can use as a base.

on your query, i think you are using constants, isn't there a variable for the amount of each plan, for example, the users < 250, set the plan first to PRO, and then multiply the users by the container of the plan's amount. so that on the database, the plan is PRO as well as the amount is multiplied. Can we do that? thanks

Adding my input below ...

efficiamail wrote: Hello this is my website:

exchangemailstat.com

On the registration form, there are four plans, Free trial, Basic, Pro, and Enterprise.

And then there's a dynamic field "No. of Employees"

If the no. of employees entered by the user is 50 or less, the basic membership should be selected.
250 or less = pro
more than 250 = enterprise.

My problem is, I need a validation script wherein if registrant selected Basic subscription, and he entered 200 employees, Pro subscription must be automatically selected.

With CBSubs 1.2.2 you can conditionally show a CBSubs plan depending on a specific condition of a CB field. So if for example you have a CB radio field that can be set to any one of three values case1;case2;case3 (case 1 can be: less than 50 employees, case2: more than 50 but less than 250, etc), then you can configure plan-A to be presented only if case1 is selected and plan-B only if case2 is selected.

Hopefully you get the idea here.

Another problem, the cost depends on the number of employees entered, for example Pro costs $3.99 per user / month. SO what happens is that --> (No. of Employees) * Cost = Total Amount / Month.

So if 200 employees is entered, that is 200 * $3.99 = total amount to be paid.

I purchased Professional SUbscription since Sir Beat mentioned about CBQuery which will help me on this problem.

I look forward to your replies.

THank you.

I am not sure how and if a CBSubs plan price can be dynamically manipulated this way. So letting Beat and Kyle respond here also.