Forums

I probably read dozens of topics but cannot find this. AND I DONT ASK FOR MUCH lol

I need a simple text form with a submit button for my company.

The information submited will NOT be emailed but saved in a database.

so later I can go to a page and see aaaall of the submited forms listed. That's it !!

PLEASE HELP 🤨

I am using joomla 1.5 if that's necessary to know.

Hi, create your form first with V3.0 stable, then save it and at the forms management area, check the checkbox beside teh form and click "Create table" at the top, choose all fields and click "save table" now go to your form page again, open the DB connections tab, enable the connection and choose the table you have just created, save the form and you are done.

yea that was easy... thanks!!!

my last question is how can I see the form I just submited? Where is all the information going to?

I submited the form but now how can I see the information people are submiting...

Hi,

you can already view the data from the chronoforms management tool in the backend. Just click on "Show Saved Data".

If you want to view it from the main website, you'll need to use chronoconnectivity to create an HTML template to view the data.

Jim

jimwin,

Could you explain in slightly more detail how you would view what has been submitted. I'm new to ChronoForm and Joomla and I can't find "Show Saved Data".

Hi bittajon,

In the Forms Manager window there is a column to the right headed 'Tables Connected'. If your form is connected to a table there will be in link here that you can click to get to the data viewer.

Bob

I have a 'Create Table' option but not a 'Tables Connected' option.

Basically I have created the form using the wizard. Published the form - so that when I click on it i can see the form. I then selected the form in Form Manager and the selected Create Table. I then selected all the check boxes and hit Save Table. I then Selected my form, went to the DB Connection Tab and selected the table and selected Yes for Enable Data Storage then hit Save.

Am I missing a step?

Okay, I found the 'Tables Connected' bit and I can see the data I have submitted. Now I need to get this data to update a seperate table that I have created in another page in my Joomla site.

Any suggestions? Will I have to edit the HTML code representing my table (the table in the different page) and enter some sort of DB and field ID?

Hi Bittajon,

Do you want the data in both tables or just one?

I think that you can do a DB Connection between your form and any database table to add new records. You'll need to adjust the SQL by hand if you want to update records or update more thant one table but both are possible.

Bob

Hi Bittajon,

if DB table X has fields with names X1,X2,X3 and your form fields are X1, Y1, Y2 and the form is connected to this table then upon form submission a new record will be created in this table and only the X1 field will get the data because its the only field which has the same name as the form field name, your table MUST have a primary key!

Cheers
Max

Thanks Max,
On a slightly different note - I would like my table to display the latest values. So....

...is it possible to create/modify a form that will overwrite the previous values in the database rather than entering a new record. (I want a table that only has one record)
...or is it easier to modify the connection to the database so that only the last entered record gets displayed.

A second question:
Is it possible to have a drop down menu on a form that dictates which database all the other data on the form goes to?

to update an existing table record and skip creating a complete new record you need to place a hidden field in your form code with a name = the table primary key field name, and the hidden field value should = the record primary key value!

do you mean to switch to a complete other DB and leave the Joomla database ?

Maybe it would be easier to explain the drop down menu question with an example.

Say I had weather forcasts for Scotland, England, Wales, and Ireland. Its the same data being entered/held for each country so I would like to enter the data in the same form, selecting the country from a drop down menu. When I view the data I want to see the data in four different tables (ie. 1 country at a time).

Is this something you can do with the forms or connectivity? Would I have to make 4 connections? Can you make a connection dependant on the data in a form?

Any ideas?

Hi bittajon,

If your data looks - for example - like this
[attachment=0]wether_1.png[/attachment]
Then you would collect this all in one database table.
And when you come to display, sort the results by country and output each country group to a seperate display table.

Bob

Thanks Bob.

Hey wait a minute, how come Scotland gets all the rain and snow.

Ah, who am I kidding!!!