I am looking for some help on setting up the database for a survey type app I’m building. I’m converting this from an Access database and having some trouble switching from SQL to a Bubble schema.
In this application, there are several Categories, each with its own list of questions. A user would fill out a survey for only one Category at a time. In other words, when the user starts a survey, they select the category, and only the questions related to that category would be shown.
The questions all have multiple choice answers, either Y/N or a different list of options. Each question can have an optional related sub-question, for example; if question 1 is answered No, then question 1a would ask for more detail about Question 1.
Also, users create comments that should be tied to a question.
I’m not sure where to start with my data types, and if I should set questions as a list of things, or each question should be its own thing. And then how do I generate the survey and relate the questions to the answers?