Grid design help

Classic Servoy
1

Hi,

I am needing tips on how best to design a grade book entry screen. I am trying to figure out how to display the Students on the left and the list of assignments across the top. Then be able to enter the scores in at that point.

There is not a set number of students, nor assignments so I am trying to figure out how to do this dynamically. Getting the list of students on the left is working but it’s trying to get the assignments across the top.

Ex - (it keeps trimming the spaces but chapter 1 would be above the 80%, chapter 2 above 50% etc)

|Chapter 1 | Chapter 2 | Chapter 3|
John Smith : | 80% | | |
Jane Smith: | 0 | 50% | 20% |

Thanks

2

A good solution would be to generate a form on the fly using the new solution model (Servoy 4.1+), that form should show one column for the student name and one column per every possible assignment (maybe student_name + a full join on your tables) so that you simply have a null value for students that are not linked to a specific assignment. Have a look at the new feature on Servoy 4.1 that allows you to base a form on a dataset.

3

Thanks for the tip!

I have been looking at the solutionModel information trying to see if I could use it. I haven’t used the new form on a dataset feature so I will go check that out also.

Thanks again!

4

You’re welcome, the new solution model is really amazing.

Extra hint: design a form based on a dummy table, place all the fields you need on the form applying all the needed settings (alignment, field type, etc.) choosing the same bogus column as dataprovider for all the fields (ex.: dummy_id), name all the fields like ‘f1’,‘f2’,‘f…’,‘fn’ and adjust all the visual aspects of your form.
At runtime get this form, change the underlying table and using your dataset instead of the dummy table then assign the correct dataprovider (dataset column) to every field and show your form. Boom! In 10 mins you have your nice “bi-dimensional array” like form.

5

Wow!

I think I caught some of that ;-)

I will try to see if I can get it to work but I may bug you again for some advice !!

Thanks!