Before I buy CB Subscriptions extension

Hello ,
I want to buy CBSub extension if it will able to do that :
1- my registration form has a dropdown fileld called:usertype with three values (provider , company , freelancer )
I want if the user choose (company or freelancer) value during registration , it will register free , and if user choose (provider) value , it will pay money before become a member.
2-
I have another dropdown query field populated from another table based on usertype value selected during registration
SELECT `id` ,`user_type` ,`function_name` FROM `functions` WHERE `user_type` = '[cb_typenew]'

can I populate it based on plan selected during registration like WHERE `planid` = '[planid]'

is that possible with CBSub .
thank you .

1- my registration form has a dropdown fileld called:usertype with three values (provider , company , freelancer )
I want if the user choose (company or freelancer) value during registration , it will register free , and if user choose (provider) value , it will pay money before become a member.

You can show/hide plan selections based off field value. You could have 2 plans for example. 1 free and 1 paid. Then show them based off their usertype.

can I populate it based on plan selected during registration like WHERE `planid` = '[planid]'

I assume you're using CB Query Field in which case no. It can however update its values based off the usertype they selected from the dropdown and since their subscription would be based off that maybe you could use that as a means of conditioning the dropdown options. The options can dynamically update based off the usertype selected using the "Update On" functionality in CB Core Fields Ajax.

you mean I can use CB Core Fields Ajax to update dropdown based on subscription plan selected during registration , is this true ?
currently I use Query Drop Down (Single Select) with this query : I want to do the same thing but based on subscription plan selected like WHERE planid= [plan selected]
Is that possible using Cbsub and CB core ajax ? because the idea of my site is based on that
thank you

you mean I can use CB Core Fields Ajax to update dropdown based on subscription plan selected during registration , is this true ?
currently I use Query Drop Down (Single Select) with this query :

No, you can update the dropdown based off the usertype field you're using changing values. It can dynamically do this as the field changes using "Update On" in CB Core Fields Ajax. You can try all this out on our demo site below.

demo.cbdemosites.com/

I want to do the same thing but based on subscription plan selected like WHERE planid= [plan selected]

There is no functionality for that. The only way that'd work is if you used a Query field to query for their currently subscribed plan then substituted the query field into your Query Select field, but this won't work on registration.

Please I want update dropdown based on subscription plan selected during registration , I need a solution for that .
I can pay money to develope this , or buy any thing like CB Auto Actions if it can do this .
Please I need this feature

We do not have functionality for that. The only way to do that is to make it based off a field. Have a field where they can select their usertype, next display the CBSubs plan relevant to that usertype, next update the values available in the dropdown based off the usertype field. Your only other solution is to make 2 select fields and condition them to show/hide based off what plan is selected under the Workflows tab of your plan.