Forums

Hi,
I tried to search in the forum, but I think I can't seem to find it. if there's an existing thread, I wouldn't mind being pointed to it and figure out my way, but if you would directly answer my questions, I'd greatly appreciate it.

This is what I am trying to do:
1. Extend Community Builder Registration that
[list]a. allows values of a drop-down menu (e.g.ddwnMenu1)to be EXTRACTED FROM a MySQL table (e.g. table1).
b. Then, another drop-down (ddwnMenu2) will also load values from another table (table2, 3 or 4). Which table to load will depend on the selected value on ddwnMenu1.
c. Another drop-down (ddwnMenu3) will also load values from yet another table (table5, 6, 7 or 8). Which table to load will depend on the selected value on the second menu (ddwnMenu2).[/list]

** I saw this topic http://www.chronoengine.com/forums/index.php?option=com_chronoforums&cont=posts&f=5&t=11245 on how to link to CB1.2RC2. So for objective #1, what I need to have is the part where I connect to database, load from table values and put it into array for the dropdown values. (I know there's lot of javascript codes out there to do this but how to integrated them into this awesome extension may be a diff thing.)

2. After the user completes his registration using the Form I created in step 1, If they decide to modify their OWN profile in Community Builder, they should get the same form (or at least similar looking) ESPECIALLY the drop-down functionality. The only difference is that the form should AUTO-POPULATE the data from community builder table.

In short, while the Form in step 1 is used to ADD NEW RECORD to community builder database, the Form in Step 2 will be used to READ, CHANGE and UPDATE an existing RECORD in the community builder database.

P.S. I have a little knowledge in javascript, enough to understand how the logic flows (and I can always google around). I also know how to navigate my way inside cpanel/phpmyadmin, so you can spare yourself from explaining at a beginner level.

When I get my form working (by your help), I will send you a step-by-step instructions aimed at newbies that you may opt to post in your site FAQ so we can help others.

Thank you so much for this component. Very helpful

Hey, I think this post will help me with the auto-populate and updating part.

http://www.chronoengine.com/forums/index.php?option=com_chronoforums&cont=posts&f=2&t=10718&st=0&sk=t&sd=a&hilit=update&start=15

Thanks much

Hi webservant,

so what are the parts that you still can't achieve at the moment ?

Max

I'm having a problem making it work. Ithought it would be that easy, but when I started my hands on it found its not easy as I thought.
Shame on me. haha.

My understanding is I will be using the the CB plugin for new registrations thru CF. However, if they will be editing their profile, another form (which looks the same but is a totally different form) will be called but this time it will be linked to the database through the profile plugin. Did I hit it home run?

Im not good at SQL. I dont know how to update the values of the only fields that the user changed. And to think that the selections will be from the dynamic dropdowns which are from another table/s, that's were I am stuck.

It seems I will be working with two (or more) tables.

Hi webservant,

I understand your problem, with a complicated form this is not too easy, will need many PHP code written, I'm working on a new CF version to make this easier, if you can wait for sometime, its currently under progress.

Regards,

Max

Wow, it sounds pretty reassuring. Thanks man.
I can't wait til I get a hold of the new version.

Maybe I'l wait for it then.


But I have a diff issue though. Its another project (or process). Should I create a new thread or just put it here?

I plan to make this form that
1) a user will use to save info about a bank deposit (a payment for a registration of some sort).
2) another form that will capture details about a person (or group of person) being registered

Notes:
* The 2 forms (and the underlying tables) should be linked in a one to many relationship, one single bank deposit record on the first table will be associated with 1 or more members/registration
** The second form will have a drop-down( or any sort of selection) to select the correct bank deposit record that will be used for each registration. Hence they can not add a registration without saving the bank deposit details first.

Hi, well your new question is some task which can be done but needs planning and some coding, nothing which can be available out of the box🙂 you need tie the 2 tables with some field and you will need some server side validation for checking the deposit record..etc, you need to plan, design and code this!

cheers

Max