Forums

I'm new to Joomla and ChronoForms so please be gentle.

I'm trying to setup a form, that when submitted will update a table which is displayed on a different page in my Joomla site. The table is going to display textual fields so I'm happy for these to come from a text box in the form.

I guess I need to somehow create a link between the submitted items(text box) and the cells in the table.

Any help will be appreciated.

Hi bittajon,

You can use the DB Connection tab in the Forms Manager to connect your form to any database table.

Bob

Thanks for the quick reply.

I've used the DB Connection tab to link the Form with a DB. My form was called 'airfield_form' so I selected the 'jos_chronoforms_airfield_form' DB.

My problem is that I created a table on a seperate page using the JCE editor. My HTML is also very basic so I used the editors GUI to create the table. Will this table have a unique name or Id associated with it? And should I then be able to select this table's name from the DB Connection Tab in the Form Manager?

Thanks Jon

Hi bittajon,

I think there are two very different kinds of 'table' here. Your data is stored in database tables which you can access using MySQL database commands. An HTML table is just a way of laying content out on a web-page - it has no connection with the database table . . . unless you create one.

The ChronoConnectivity component (from the downloads area here) will let you make the connection - but the documentation is thin and it may be tricky to use if you aren't used to this kind of work.

Bob

Okay, I'm managed to extract my data out of my database using ChronoConnectivity. I've publish this data and it is accessible at the front-end.

Is there anyway to get this data/table to be displayed on a different page? Can you do this in a similar manner as you do for forms (ie. FAQ 42)? Perhaps replacing {chronocontact}my_form_name{/chronocontact} with {chronocontact}my_connection_name{/chronocontact}?

I know this question probably belongs in the Connectivity forum but I felt that it was a follow on to my previous questions so left it in the forum.

Hi bittajon,

To do this you need a Connectivity mambot which is not available yet, we will have this option in 2 or 3 days with a new updated connectivity version, so check back soon and it will be ready.

Cheers
Max

Thanks Max,

I really appreciate the quick replies from both you and GreyHead. It would be great if you could let me know when this update is available.

Thanks again

Jon

Hi Jon,

the component still needs 1 final key feature and the hardest one, will try to finish it soon, no idea when it will be ready, it will be a real key feature.

after that a mambot will be made but this is very easy to do for the connectivity!

Cheers
Max

Hey, guys, can anyone give us an update on this process???

Thanks,

DG

Hi dgaletar,

Please see the Database tutorial from the Tutortials link above.

Bob

Thanks, Bob, for the qick reply! But I'm having issues of my own. Which Tutorial am I looking at?

Actually, let me tell you what I am trying to do first. I am trying to capture some repetitive information from individuals for a Fantasy Football site. While our goal is to develop our own game, we thought that we would have visitors post their team details in the mean time.

The table submitted for an example of the draft looks like this:



So, having each team go into their email, fill in their forms with their draft selections, and submit them to us. Then we would like to post the results onto our website.

It is still a work-in-progress, but it's a start.

Any help would be GREATLY appreciated!!!

DG