Hi Michael,
In the web world that is an easy part. I think if I were using a similar idea
to the .str I sent you, I would use a Question Type panel record to the
Question. The QuestType could be of the format say Yes/No, SA/A/N/D/SD or with
a bit more work and creativity multiple choice (The choices might have to
reside) on the Question panel, and then use calculated fields on the RespInst
to display the available choice. You could create a formula that ensure the
user only enters valid choices for that question type for each question asked.
You might need a multi-line text field on each Response Instance.
There are a few tricky DP interface issues here. Although I have never used it
as far as I recollect DPMouse allows you to have conditional landing of the
cursor into some fields, and you could I guess make check boxes out of the
options... But I am talking thru my ass here, because I do not know DP Mouse...
I have been writing survey software for years, but I have always written in it
VB, and had lots of control over the front end. Similarly when I wrote some
surveying stuff with DP, I have web enabled it, so again I have lots of control
over the front end.
Regards
Brian
----- Original Message -----
From: Michael Iannantuoni
To: DataPerfect Users Discussion Group
Sent: Tuesday, November 28, 2006 9:56 PM
Subject: Re: [Dataperf] Questionaire/Survey with DataPerfect
Hi again Brian,
One more question: having the questions in a separate panel is a great idea
but is there any way formatting data in that panel could be used to format the
field types etc in the questionnaire panel? I suspect not but someone out there
may know of a way.
Regards,
Michael
Brian Hancock wrote:
Hi Michael,
Mine is a web application, so the user does not interface directly with the
panel, so I am free to spread and gather the data more freely.
However, I would still not try to fit in on the one panel. Instead I would
use a structure such as
Survey Master, - survey ID, instructions etc, and two child panels. One for
the questions, and another for the response
In the Question Panel, Survey ID, QuestionNumber (consecutively numbered no
alpha) and Question Wording.
In the Response, you have an incrementing, or conditionally incrementing
number number to represent the users overall set of responses, plus userid (if
necessary) and a Panel Link to the Response Instances.
In the Response Instance Panel, the fields include the Survey ID and/or the
ResponseID, a conditional incrementing number (ie automatic numbering but
starting at 1 for each survey, (Ralph Alvy's automatic numbering through a
recursive link will do the trick here, but there are some other simpler
techniques). Also you will need a calculated Field for the question wording.
There should be a Data Link from this atomatic number through to the Question
panel, so that for a given survey id, and question number, you pull through the
correct wording.
Now to complete the survey the user, press F9 for each new question. The
incrementing number on the response panel, will then show the next question
number, which will link to the appropriate question wording.
You only need a couple of field in each panel, and the analysis is a snap.
Oh heck its probably easier to write it rather than describe it. I will
post an STR for you, in a few minutes.
Regards
Brian
----- Original Message -----
From: Michael Iannantuoni
To: DataPerfect Users Discussion Group
Sent: Tuesday, November 28, 2006 4:11 AM
Subject: Re: [Dataperf] Questionaire/Survey with DataPerfect
Hi Brian,
Thanks for you help.
I had thought of having a separate questionwording panel but wasn't sure
how to link it to the questionnaire panel. How do you display the questions
from the questionwording panel in your questionaire panel?
Michael.
Brian Hancock wrote:
Hi Michael,
As part of my DP web application I have a surveying module. It
handles various types of questions:
* Yes No,
* Strong Agree, Agree, Neutral, Disagree, Strongly Disagree and Not
Applicable
* Free form comments
The structure is that there is a questionnaire panel as the master for
a survey, which include a surveyid, author, title, preamble (ie notes about
what th survey is for), whether the responses are anonymous, the start and end
dates, and in my case the class of recipients.
As a child of that panel there is a questionwording panel, One record
per question! I use the fields:
* question number
* Question part, eg you can have Q2a, Q2b, and they are grouped on the
survey form,
* and then the scaling being used for that question. eg Y/N, Lickert
scale, Free Form,
*or as a header, eg no question, for example:
Q2. The following questions relate to your experience with blah blah,
please answer each part (Header)
Q2a etc (question parts)
Q2b etc
You can add any number of questions you like, but my experience is you
should keep survey's small and tight otherwise you tend to piss people off.
In my particular case, the user is sent an email, with a link to the
questionnaire,
eg http:www.myserver.com/mysurvey.cgi?surveyid=AD54FG72&userid=bjh, (or
no userid if anonymous) and the survey is generated from the database
Mine is only a single page survey, the user completes the survey and
submits the data back to the database. On the response side their are two
panels. The Response panel (one record for each survey submitted) This panel
has fields for
*the surveyid,
*a responseid,
*the date and time received,
*the userid, and the
*IP address.
This has a child panel which are the Response Instances for each
question ie one record for each question on the survey. In this panel the
fields are
* ResponseID (which ties it to the parent response panel)
* The Question Number and
* Question Part,
* The users response as the code for the response, or in a memo field
for free form text
The author of the survey can request reports from that surveyid.
Lickert scale and yes/No sum the totals for each response, and freeform list
the responses.
Do not be tempted to place the questions nor the responses onto one
panel. It might be easier coding to start with, but you will suffer in the long
run.
I hope this helps
Bye
Brian
----- Original Message -----
From: Michael Iannantuoni
To: Dataperfect Mailing List
Sent: Monday, November 27, 2006 8:35 PM
Subject: [Dataperf] Questionaire/Survey with DataPerfect
Background:
Our village has recently taken part in a questionnaire/survey
whereby everyone filled in a paper form which is now being transferred to
computer file. The software provided by our local authority (Council) is not
particularly good: you have to go on line for it to build a "Project List" of
surveys done for other villages before selecting & downloading the one for us -
it does this every time you want to transfer data from paper to file. The
"Questionnaire" part then loads but is not very user friendly, not allowing you
to go back to previous questions without loosing data back to that point . . .
. I could go on. Once data has been transferred to files for the session, it
must be uploaded but the process of building a Project List etc.. occurs again
first - all extremely slow & frustrating.
In a moment of frustration/weakness, I did say to the chap running
the project for the village (he did have a good head of hair before it all
started!) that it would be fairly straight forward to design a database that
would do all that is required so much easier. Luckily for me, I'm too late this
time as the project is well under way but may be repeated in a couple of years
time.
So my question is has anyone designed a DataPerfect database for
questionnaires/surveys? It seems to me that that it should be fairly straight
forward but maybe laborious. There questions fall into four categories:
Simple Yes/No responses,
Multiple choice options whereby only one of a number of options
must be chosen,
Multiple choice options whereby none, one, some or all of a
number of options must be chosen.
A box allowing comments to be written.
The first and last are easy, I'm not sure of the best way to achieve
the other two.
The other problem is the size of the questionnaire. There are just
under 200 questions which would be too many for a single panel, although they
are divided into sections such as Transport, Environment etc... I had a thought
of using a panel for each section with a master Table of Contents Panel with
links to all other panels a bit like an table of contents linking to the
relevant pages of a book and maybe links from each panel to previous & next
panels.
This is all thankfully a way off yet but any thoughts or ideas would
be welcomed.
Michael
----------------------------------------------------------------------
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
------------------------------------------------------------------------
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
--------------------------------------------------------------------------
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
----------------------------------------------------------------------------
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
------------------------------------------------------------------------------
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
