Website Statistics with ChronoForms 4.0

Hi people,
I have a question and I hope for an answer.
How can I create a form to display the statistics of access is to the Articles of Joomla! that the forms ChronoForms?
😲

Hi Jack19,

You can read the contents of the #__content table with a DB Multi-Record Loader action and use the results in a form.

Bob

Hi Bob,
Not just that.
I would like to actually know how many people (and which ones) have clicked on a form that I created with ChronoForms. In addition to the hits of the table # __content.
Tank.
Gioacchino

Hi Gioacchino,

I guess that if you save the Form submissions to a database table then you can check the saved results in the same way. Add a column to the table to save the source article id if you want to be able to link the two together.

Bob

Hi Bob,
thanks for the reply.
so if I wanted to know how many are the views of the form, I could put an action DB save in the Load of the form itself, correct?
Gioacchino

Hi Gioacchino,

if you want to know how many *views* then probably Google Analytics or something similar is the best answer.

My suggestion was about tracking submissions.

Bob

Hi Bob,
the site in question only provides access through authentication.
Do you think Google Analytics to work anyway?
Anyway I'll try with Google Analytics.
Thanks.
Gioacchino

Hi Gioacchino,

If Google Analytics are a problem you could check views with a DB Save in the On Load event. I think it will work OK.

Bob

Hi Bob,
In fact, GA does not do what I need, I do not need research data, sources, browsers, etc. ..
Being a site where the user is checked before they can access, I do not need all that it offers GA.
I tried to create a table to pick up my stats and action DB save in the On Load event works with the default fields of CF (cf_id, cf_uid ecc.), but I need to save some additional information that I can not save in the DB.
For example, I added some hidden fields for the additional information (Also present in the database table), but when it is saved in the DB they are not there.
Regards.
Gioacchino

Hi Gioacchino,

ChronoForms will save anything in the database table provided that the input name exactly matches a column name in the table. If you add a debugger action you should be able to see the query being created.

Bob

Hi Bob,
It does not work.
I created a field that I called "test" in the database.
I did two tests:
1) I have created a hidden field called "test" as the field in the database. In the On Load I added Show html and action DB save.
2) In the events tab in the On Load I used a custom code with html for a field "test" and an action Db save.
In both cases the DB field "test" is empty.

this is the debugger:

Array
(
    [option] => com_chronoforms
    [chronoform] => Products-Copy
    [Itemid] => 
    [chronoform_data] => Array
        (
            [cf_uid] => dddd30f4212b333cc92f23b248cdf750
            [cf_created] => 2013-09-30 11:03:46
            [cf_created_by] => 66
            [cf_ipaddress] => ::1
            [cf_user_id] => 66
            [option] => com_chronoforms
            [chronoform] => Products-Copy
            [Itemid] => 
            [cf_id] => 59
        )

    [chronoform_data_cf_id] => 59
)
Validation Errors: 
Array
(
)

Regards.
Gioacchino

Hi Gioacchino,

Yes it does work. As you see there is no data coming from your 'test' input in the form HTML. Please check how you have added that: it needs to be in a Custom Element element, not a Custom Code action.

Bob

Hi Bob,
I did one in a Custom Element element:

<?php echo "<input name=\"test\" type=\"hidden\" id=\"test\" value=\"Product1\" />";

?>

and in Events I put an action Show html and a DB save. It does not work. :?
Regards.
Gioacchino

Hi Gioacchino,

May be a copy and paste error but the <?php tag is incorrect.

Bob

Hi Bob,
Yes, copy and paste error.
Regards.
Gioacchino

Hi Gioacchino,

Please post a link to the form so I can take a quick look.

Bob

Hi Bob,
At the moment the site is not online.
But I was able to verify that seems possible only by putting a submit button and an action DB save On Submit events.
😟
Gioacchino