How to limit your data entry per timepoint

[PhDstudent]

Dear all,

I would like to create a cohort database in which I will look at neurodevelopment of children. Several tests will be performed and these tests will be repeated at different timepoints. I.e. test 1 will be performed at Post Natal Day 1 (PND1), PND2, PND4 and PND7. Test 2 will be performed at PND2, PND 7 (..) and so on.
Ideally I would like to link the tests to the PND that the tests need to be performed. So that the form adjusts depending on the PND that I enter.
I.e.
Study ID = 1AAB
PND = (number between 1 and 200)
--> depending on PND, different tests will show up (or the other way: data entry of several tests is aloud, while that of others is blocked)

Is this possible? You would really help me out!

Best,

Lisa

 

[gemma-the-husky]

its not a question of limiting data entry per timepoint, as you put it I think. Its more a question of structuring the data correctly.

so you have a table of tests,
a table of patients.
and a third table of patient tests.

this is a "sparse matrix". you ought not include all 200 tests per patient. you just include the ones you want.

so patient AB123 may have texts 1,4,17,24,38

now either there is a standard set of tests that might be used, (or multiple standard sets) in which case you can select the standard set, and load all of the test into the patient record - or you will need to pick the ones you want manually.

is that what you mean?

 

[pbaldy]

Both posts were moderated, just approved.

 

[apr pillai]

Create a Table in the following structure as base:
TEST PND
1,1
1,2
1,3
1,4
1,7
2,4
2,7

Calculate the Post Natal Day from the Patient Table and filter the data to determine the tests.