Forums

Well i have installed cronoforms and made a new registration form with Joomla Registration Plugin
i used a tutorial from another topic given by admin to make the form and it worked perfectly fine
BUT--
I added a new field called "Mobile Number"
and i dont know how to connect it to the database table i.e how to store its value into the db table
tablename: jos_users
fieldname: mobilenumber
textbox name: text_8
could any one help me by tellin me what shud i do to store the value in the db??
I m quite familiar with joomla made some sites but a noob with php.. but can understand well..can't write code
Pls Help
Thnks in advance

Hi nambad,

You can add the new field to the database table using PHPMyAdmin and then edit the field lists on the AutoGenerated Code tab; or, if you have no important data saved, you can drop the current table and let ChronoFroms create a new one for you.

Bob

well thnx for reply but i have made a new field in phpmyadmin
i also have made a text box in the form but the value for this textbox is not stored in the db

Hi nambad,

Have you edited the field and type lists on the Autogenerated Code tab to include the new field?

Bob

now i dont understand actually what shud i edit there??

Hi nambad,

you can NOT and should NOT edit jos_users table to make it more clear, we are talking about the chronoforms table you have created for the form, have you created a table in the forms management area ?

if you did or still didn't then go now to the forms management area and create a new table and choose all your fields (there is a checkbox beside each field in the create a table screen) then connect to this table in the DB connection tab and enable it!

Regards
Max

well max i have done that but how can i use tht table as my user's table?
i mean will it automatically take it as my base user table?

No, you will have the username/name/password and email in your users table, and the extra data in the chronoforms table, you can't make the chronoforms table as the users table, why do you need to make it like this ?

Regards
Max

ok so i can store the values in both the tables according to u rite?

hi greyhead..
admin helped me out and did 99% of the work and went offline ..
could u solve my last query???
i have an sms gateway and i wud send sms to ppl as soon as they click on register... so could you tell me where shud i paste tht code and how can i use the "mobile number field" in the form to take the value?

Hi nambad,

Please don't cross-post three times over. It was night time and we sleep a little!

What code does your sms module need?

Bob

I am very much interested in knowing if this will work for me as well. I want to integrate the form generated by chronoForms with the Joomla users table so that when users come to the site to update their profile, it will be available for them. Is this possible based on this thread? If so, can someone please share the how to? Like nambad, I want to minimize as much as possible having multiple users' table in my Joomla site.

Also, how does one change the auto-generated field name from something like {text_1} to something like {firstname}? I can't seem to see how.

Hi omojesu,

To change the field names you'll need to edit the Form HTML (change the name="text_1" attribute, and make corresponding changes to the Email template and the any entries on the AutoGenerated Code tab (best to do it before creating a table).

When you say you want user info 'available' what do you mean - I've just answered a thread telling you have it show it in a form? Do you want it to be editable as well?

You can link a ChronoForms form to the jos_users table using the DB Conectivity tab BUT you need to take extreme care if you let users edit any core Joomla table. Make sure that you do not make any key fields like user_id be editable or you may blow up your site.

Bob