Hi, I have 3 tables - one of users to interview, one of questions, one of questions and answers together. I’ll ask the same question each time but could add new users all the time. I want all responses to be displayed in one table.
What is the best way to do this? If I was doing it as a one off I could do it but making it update when there’s a new user is tricky.
So here I have a table of users and I can add new users at any point:
These are my common questions. Ideally I would get this as a blank sheet by filtering on a new user name, or filter to see an existing user’s response
And here are all my answers together (though I realise that I could perhaps make the questions a view of this table):
Is there a simple way to do this? Using lookup functions only gives me a drop down so I have to select each answer. I can copy and paste blank questions into the answer table and could have the questionnaire be a filtered view by user of the answer table. But is there a simpler way?