Viewing how many people have completed the forms and more

Hello and thank you for you time on reading this.

My client needs someway of seeing how many people have completed our chronoforms in our website and someway of seeing their form info on the website, not the administration panel.

I'm guessing I'd need some kind of way to access the chronoform database and show it's info.

Can someone please help me on this? Thanks in advance.

Hi Xocoo,

it depends a bit exactly what the client wants. You can create a mini-form with a record count in a few lines. If they want to browse through the data then you can use ChronoConnectivity.

Bob

Thanks for the reply. I'll check out ChronoConnectivity. Is there a way to see the exact number of people who completed the forms? Like the "How many people have viewed my website" module? With numbers like.

Form1 completed: XXX
Form2 completed: XXXX
Total completed: XXXX

Hi Xocoo,

If you record the information then you can recall it and display it. The usually way would be to save the form information in a database table. Then you can get a count of the records added. ChronoForms adds the record time so you can break this down however you like.

Bob

Hi GreyHead, thank you very much for you helpful replies. I've been tinkering with chrono connectivity for some time. I hate to admit it, but I can't understand how it works or what I need to do to get my desired result. Can you please supply me with a short tutorial or link me to one?

Hello,

There are many Connectivity tutorials and how to's posted on the connectivity forums, please check it and let us know if you can't find any.

Regards,
Max

Thank you very much for the useful replies. It helped me more than you realize🙂.

Now there is only one little problem, is there a way to add a "total completed forms number"?
For example:
Total employers: 10 Total Job seekers: 50

I've created a form for employers and job seekers and can view their database via chrono connectivity.

Thank you in advance🙂.

P.S I love Max Payne too😀

Bump

Hi Xocoo,

You can add a simple SELECT statement into the Header or Footer box to do this

<?php
$db =& JFactory::getDBO();
$query = "
    SELECT COUNT(*)
        FROM `#__some_table`
        WHERE `xxx` = 'yyy' ;
";
$db->setQuery($query);
$count = $db->loadResult();
echo 'The count is '.$count;
?>

Bob

I seriously love you man. Will try this out now. May thanks