Newbie has question

Hi, I am looking to build a website, I would like to have the following questions answered before I purchase:

1. Can I break questionnaries (a form) into multiple pages?
2. Can I store twenty fields from one form to different tables?
for example: Ten fields go to Demographics, Two go to Behaviors, Two uploads goes to the file table.

Thanks for reply!

Hi nmay,

1) Yes, how you do it might depend on whether you use tabs, multiple form sor one form with a switch statement.

2) Yes, but why would you want to?

Both answers require some custom PHP /MySQL

Bob

Hi Admin, I figured out:

By putting code in the AutoGenerate Code, it saves data to different tables. I can use jfactory to get userid and then store that userid with files users uploaded to different tables. Of course, I must create tables first!

Another question I have is:

Users update their profile very often. In my case, we need to track each time when something changes. It is the same form that users fill over and over again. Your autoGenerate Code is very flexible because I can keep doing inserts. But how can I fetch the last filled data back to the form for displaying when users go back to update their profile?

Is it feasible?

Hi nmay,

I'd probably do this with two tables, one to track the transactions and keep the history (which is basically what CF does by default) and a second to keep an up-to-date master record that you can access for the latest info. This would have one record per user - like the Joomla user table and you'd write any new info to it to update the exisiting record.

Bob