I’m building an assessment flow in Bubble with the following setup:
-
Admin user creates an assessment, which is assigned to multiple teacher users.
-
One assessment has multiple sections, and each section has multiple questions.
-
Each question is answered using an Option Set (e.g., Not Implemented → Fully Implemented).
Database structure:
-
Assessment → has Assessment Log where assigned users are stored.
-
Assessment → has multiple Sections → each section has multiple Questions.
-
Section Log → stores all Response Logs for a section when a user completes it.
-
Response Log → stores the user’s answer for a specific question.
Problem:
When a user completes a section, I can create the Section Log, but I’m unable to store the Response Log for each question with the selected Option Set answer.
I want the workflow to:
-
Create Section Log for the current user and section.
-
Create Response Log for each question in the section, storing the user’s selected Option Set answer.
Question:
How can I capture each question’s selected Option Set answer in a repeating group and create the corresponding Response Logs in Bubble? What is the best approach for this multi-user setup?
