How to set up base for my research projectr

[Art_Eleanore]

Hello,

I am using Airtable to organize my research project.

I have 20 participants, with 19 questionnaires. I will have staff completing these questionnaires at 7 different time points. (Pre op, surgery, 6 month f/u, 12 month, 15, 18, and 24. For each questionnaire, I am keeping track of if the data was collected and if the data was then uploaded in the data base, and if we verified the data after uploading. How would you recommend I do this? Thank you.

[kuovonne]

Welcome to the Airtable community!

There are various possible ways to set this up. Are the questionnaires going to be completed in paper or using an Airtable form? If each questionnaire will be an Airtable form, you will need to have one table per questionnaire. Otherwise, you might be able to have a single [Questionnaires] table.

In general I you want to have a new table for each type of person/place/thing that exists in real life. In this case I would expect to have the following tables (in addition to your table(s) for questionnaires.

• [Participants]
• [Staff]
• [Time Points]

You will also need linked record fields to show the relationships among the different entities. For example, you might have a junction table with linked records for the {Participant}, {Staff}, {Time Point}, and {Questionnaire} that go together.

I recommend looking at Airtable’s Guide to many-to-many relationships for more info.