I need to ask 40 people 200 questions. How would you do this?

James Keuning

Like the title says. I am considering two approaches:

Create 200 columns, where each column is a question, and create one row per named responder. Use a form to collect the first round of responses, and use the row link so that each person can review and responses after the fact.

Create one column per person, and 200 records for each question. Create one report for each person.

Any better approaches?

Maaik Meijerink

Hello James,

As you use a form for this, the best what you can do is to add a column for each question. With this structure, you can easily construct the form (with logic) that after answering question 1, you can show question 2, or even skip questions depending an the answer they give.

Afterwards, you only have to make 1 report (and not 40) and depending on who is logged in, restrict the report to 'current user'.

Regards, Maaik