redstorm
Posts: 7
|
| Posted: 12/29/2005, 6:40 AM |
|
I want to create a Record with about 50 rows of individual questions. The client will answer the questions with a series of tick box answers and or provision for comments. These comments are them to be recorded in the DB for additional reporting etc.
I want to be able to add the questions and other details in my Admin section however I do not want the Clients to be able to edit the questions only answer the questions by ticking the appropriate boxes or by making comments.
Has anyone considered this before and if so conceptually could you provide some general advice or point me the right direction to read up on these concepts both in CCS and DB structures for this style of collecting data.
Any help appreciated. Thank you in advance.
|
 |
 |
Benjamin Krajmalnik
|
| Posted: 01/02/2006, 6:14 PM |
|
First of all, I wiould have an open architecture so as not to limit the
number of questions.
Create a table of surveys, with a one to many relation to questions.
Now create a table of survey answers. It should have the user id, the
survey id, the question number, and the field to hold the answer.
Now, when a user clicks on a survey, you need to dynamically create the
unfilled answer set, with the first 3 fields populated and only the answer
field blank.
This should take you to an editable grid. The editable grid should have a
join so you can display the questions. Make sure deletion is not enabled.
Now they can go through and answer your questions and submit them.
Hope I was clear enough.
If you have more questions do not hesitate to ask.
|
|
|
|
magus
Posts: 98
|
| Posted: 01/05/2006, 3:33 PM |
|
Dear Redstorm,
Did you want to dynamically specify what sort of control (Radio List, CheckBox, Select ListBox) is to display for each question? And whether or not to allow comments on a specific question?
Regards,
Don A
|
|
|
|
David at Redstorm
|
| Posted: 01/06/2006, 3:21 AM |
|
Hi Don,
We want to use a dynamic CheckBox with the client only having the abilty to tick one box to answer the specific question (3 choice boxes) and they are allowed to post there own comments (and edit them later) on each specific question.
Thanks. Look forward to your input and thoughts.
Regards
|
|
|
|
magus
Posts: 98
|
| Posted: 01/06/2006, 1:46 PM |
|
Hi David,
Wouldn't you use a radio button for this?
Otherwise it sounds to me like Benjamin's solution would work.
Regards,
Don A
|
|
|
|
Walter Kempees
|
| Posted: 01/06/2006, 1:59 PM |
|
And how about this one (to keep you busy over the weekend)
In the table holding the possible (multiple choice) answers you would add a
field per answer pointing to the next question.
Leaving it default empty would always point to the physical next question
(question_id +1). filling it with a number could point to a another
question.
This would enable you to change the line of questioning based on the given
answers.
Used in call-centre scripting.
"magus" <magus@forum.codecharge> schreef in bericht
news:243bee52a00819@news.codecharge.com...
> Hi David,
>
> Wouldn't you use a radio button for this?
>
> Otherwise it sounds to me like Benjamin's solution would work.
>
> Regards,
> Don A
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
David @ Redstorm
|
| Posted: 01/06/2006, 3:20 PM |
|
Magus, note your comments. Yes a radio button in thniking about it would be better.
Thanks.
David
|
|
|
|
|
