Hi, I’m building an app with a “Test” section where users answer 30 multiple-choice questions. Based on their score, they receive a level and book recommendation.
I’m using the Choice component to show four answer options for each question.
My data is structured in one sheet:
- Each row = a question
- Columns:
Question, Option A, Option B, Option C, Option D, Correct Answer, Level, User Answer
I want the user to:
- Click a Start Test button
- See one question at a time, with four options
- After choosing an answer, they click “Next” to go to the next question
- At the end, they get their score, level, and book suggestions
My issue:
- I can’t figure out how to make the Choice component work with multiple options from separate columns.
- I also don’t know how to move to the next question one at a time.
Would they ever do the test again, or is it a one-time thing?
I would suggest trying the custom AI component to show the choices, since if you do it natively, you have to transpose your choices to be in rows, instead of columns.
Use a custom collection, and have an index for each question. Clicking a button would increment/decrement a value in your Users table, and you filter the collection to show the question which has the same index as the value above.
1 Like
If it is only done once, you can use the user’s row, create a column that indicates the index of the questions, then create another table where the questions are in a single Line, with their respective fields for the answers, in your form you can filter the questions and their corresponding fields depending on the index, add a block button where it indicates a next and a back, and add an action where they increase or subtract the id of the question within the user table, this would be to be done in a native way, but I would not rule out the option of the Ia component
1 Like