Forums

Data Collection and Trend

omidhz 13 May, 2010
Hi,
I want to setup a form on my joomla website (I also have Community Builder) so that the form adds data to my user's table every day.

Here is more details:
1- User logs in to the website and opens the form (form is only accessable to registered users).
2- The form will automatically retrieves user's name and email and enter it in the name and email field.
3- User completes the form (all answers are numeric) and submits.
4- All answers should be saved to a database and includes the date of submission.
5- User returns next day to the same form (same questions) and submits answers (which will be different from previous day).
6- After submission, I want all new answers to be saved in the same database, for the same user under that day's date.
7- I will be using Access database to connect to that table and retrieve the data for trending. Meaning I want to know how the answers are changing every day for each user.

My problem is steps 4 and 6 to organize the data. Is this doable with ChronoForm? If so, how?

Thanks you
GreyHead 13 May, 2010
Hi omidhz,

Yes, a form with a DB Connection to your table will do that for you.

Bob
omidhz 13 May, 2010
I know the form can save to the database. But my main question is how can I store new answers to for the same user under that day's date?
[list]1-Do I need to leave the form as is so that it creates new row for each user every day?[/list]
[list]2-Should I create a separate table for each user? If this is a better option, can chronoform do that or do I need to create a separate form and table manualy for each user?!![/list]
[list]3-How can I retrieve the data from that table to be shown on my user's account (data specific for that user only)?[/list]

I know some of these questions are related to database management and not to ChronoForm, but I appreciate if you could answer me so that I know how to setup my Chronoform for this data collection.

Thanks again.
GreyHead 13 May, 2010
Hi omidhz,

I'm not understanding the problem?

Each time the form is submitted a new record will be created in the table. If you used ChronoForms the create the table then the user id will be in the 'cf_id' column and the date & time will be in the 'recordtime' column.

Job done.

Bob
This topic is locked and no more replies can be posted.