I write knitting patterns, they had to be tested - if everything is correct or not.
So I have tests - for every pattern. I collect data as volunteers, yarn used, if finished, etc.
I have testers - because some people joins to more tests. I want to keep their email address here, know in which tests they knitted and how. So I would like to rate them - did the finish in time, sent the survey back, etc.
I don’t see, how I should connect all this data together.
How it works now: I have a Google doc, one table for all tests, with the data mentioned before.
And I have an other table: rows are testers and columns are the tests, I give a “note” for them.
I hope this can be understand