I have two related tables that pertain to a survey I’ve created.
Table 1 is all of the survey questions. So Row 1 is Question 1, Row 2 is Question 2, etc. Columns have characteristics of each question - topic, category, stage to be asked within the interview, notes.
Table 2 is to record each person’s survey data. So Row 1 is Participant 1, Row 2 is Participant 2, etc. Columns are the Questions 1 through XX.
So, Table 1 has all of the Questions as rows; Table 2 has all of the Questions as columns.
For reasonably obvious reasons, I’d like to be able to connect these tables together, akin to lookups (so that I can see the underlying characteristics of each question, without having to flip between the two tables). I know how to do this column to column with lookups. But I’m not sure how to do it when I’m trying to relate columns to rows.
I’m not that good with Coda yet, so haven’t really played around with charts. If akin to pivot tables in Excel, perhaps that will work. I can check it out.
I did try to use the “top” function, but that seemed to provide more of a nested organization - it has benefits, but still doesn’t really adhere to good stats-related organization.
I guess the bottom line is that columns and rows can’t connect in Coda. And I presume that there isn’t a transfer columns-to-rows function like in Excel? I’ll just have to remember moving forward so that I organize things properly.
Still, I’m not quite sure how I would design questions that have underlying properties. The questions really need to be:
Q1 Q2 Q3
Type: Text. Type: Number. Type: Canvas. etc.
And the question properties almost certainly need to be:
Characteristic1 Characteristic2 Characteristic3
Type: Text. Type: Number Type: Slider etc.
They don’t have to relate…I just thought that was the big thing about Coda, was that they could.
Tables can indeed be related to each other. There are several ways that one can use. However, I am still not clear on what your exact requirement is.
Where do you store the answers? I assume Q2 in the first table is not in the form of a number, but the answer is. But if Q1’s response is text, how do you statistically analyse that? Or Q3, that is in the freeform format of a canvas?