Making an Evaluation form

Applications Forms
#1

Hello, i’ new to using scriptcase and i need some help. i’m making an online version of an old delphi evaluation application. and i need some help with it. The form has some fields and a grid
field1: Evaluator group (administrator, teacher, parent)
field2: Name of the person being evaluated (search using select from an SQL table)
Field3: timestamp of the evaluation
Field4: dimension being evaluated

then comes a grid of 2 columns. on the first column displays the item being evaluated and on the second column the user gives it a value from 0-10 to that value something like this

ITEM VALUE
Teacher uses shows good knowledge of the subject he/she teachs 9
Teacher mantains a good relationship with his students 7
Teacher makes use of audiovisual aids 5

the items shown have been created on SQL table and have an unique identifier that correspond to what the items are evaluating.

So what i need to know is how can i do to generate the grid using an SQL query. or an onload statement.

so for example if on field 4 i select to evaluate a dimension of climate on classroom, then the grid will show all of the items that correspond to that dimension.

#2

Re: Making an Evaluation form

Hello,

There’s a lot of detail, I’ll try to help you as I can here.
with field1 and field2 you can change the type to select, text auto-complete, there is a lookup edition where you’ll put the SQL statment to show the content.

There’s some examples to guide you in the website: check the Samples section.

#3

Re: Making an Evaluation form

Thanks for your reply!

I have no issues creating the first fields and making them search the teacher’s name using select or text auto complete.

What is giving me trouble is the grid part where it has to show the items in accord to the type of evaluation selected. the items are stored in a database and everyone of them have a INT value according to their type.

so if on the database i have 15 items type 1, 13 items type 2 and 14 items type 3, whenever i select any of those types, i need the grid to show me all of the items of that type and then store the value that the evaluator assigned to each item on another database, storing the value of each item on a different row.

any ideas?

#4

Re: Making an Evaluation form

any ideas? or other ways to do what i need? I’m stuck :frowning: