Form to Create a Table and Form

Need help Database
1

I want to create an application for creating a test or survey. For example, the person wants to create a test: The person would need to be able to create the test stating the questions and identifying the type of answer each requires. So, they could be asking the following types of questions:

  • Multiple choice question with single selection, or
  • Multiple choice question with multiple selection, or
  • A yes/no question, or
  • A yes/no with explanation to be input.

So, I am currently trying to figure out:

  1. How would I create the form to present to them so that they can add the different questions, identify the type of answer required, e.g., what options there are for multiple selection questions, if it is a yes/no question, and if there is supposed to be a written answer. I want them to be able to add as many questions as is necessary. I figure I would need to have a button to add another question. Each question entry would need to be composed of the following:
  • Text for question
  • Answer Type
  • Options if multiple choice

  1. How do I use the completed form from step #1 to create a table with the required data fields? The table would likely use generic names for the field names, e.g., question_1, question_2, etc. Multiple choice question field names could be identify as question_2a, question_2b, etc.

  2. How do I create the actual test form? I would need to take the questions, options, and question types from the completed form in step #1. So, the question would actually just need to be copied as text to the test form, then the correct element would need to be inserted, e.g., a yes/no element, or a radio button element with the options from the form in step #1, or for multiple choice questions requiring multiple selections a number of yes/no elements with the text from the form in step #1.

  3. And finally, I want to create a report that would list all the results for all the participants in a tabular format, e.g., questions down the left column and the participant names across the top row, and of course the participants answers in the corresponding cell.

Is this even possible with Bubble? And if it is possible any assistance would be appreciated! Does anyone know of an existing application that does this that I could use to learn from?