Issue on a quiz page to compute the score

Ask for Help
1

Hi,
I am very new with Glide and use the free plan.
I am building a quiz app using Form container based on my table Responses. I use a Choice component to display the questions and options (3 possible responses in a chips form where only one is correct). 2 points I want help :

  1. How to capture the user choice with each question, test it if correct or not and display respectively green and red icons ?
  2. How to calculate the score only from the UI because I notice that nothing happens in the table database until the button Submit is clicked.
    Thank you
    Best
    CE
3

Can you show your structure of the database so far?

4

Thx for your quick reply.
My table Responses_quiz : Rep1 to Rep10 (for the user response), S1 to S10 (for the scores 1 if correct unless 0), S_total (sum of S1 to S10).
I have another table Quiz : ID Question (from 1 to 10), Question, Response 1 to Response 3 (3 choices possibles to respond) and Correct_responses. There are 10 rows in this Quiz table.
I’ve created a link between the 2 tables to lookup the options from Quiz because my form is based on Responses_quiz.
Thx

5

Couldn’t really understand too well, could you share some screenshots of your database?

6

My Responses_quiz table :

image

My quizz table :

image
image1617×414 48.2 KB

Thx

7

Any clue ?

8

So you don’t want to wait until the “form” is submitted to show the user answers and whether they are correct or not?

What if a user see those and never submit anyway?