Elegant solution for workflow for scoring a quiz?

I have a set of quizzes that I dynamically load onto a page based on a button a user clicks on a a different page.

On the quiz page, each question has radio choice options which are dynamically loaded based on the quiz that was selected. Each option has a score value, which I use to calculate quiz score and determine the result. So for example, if it’s a personality quiz, the score would be used to determine the personality type.
The questions for each quiz are loaded via a repeating group, and the radio buttons are loaded dynamically within the same.

My question is if there is an elegant solution to this? If I were to program this, I’d simply store the score for each selected item in a variable. Haven’t had much luck doing Bubble’s version of that (as a state). I also tried storing the radio results as a list of numbers to get the sum once the quiz was completed, but apparently lists cannot have the same value twice (the radio options are the same for each question, so repeats got ignored).

I’m currently using 1danielbaker’s solution, which technically works.

When I’ve done this in the past I’ve used a data type called sum that keeps adding every time a new budget(in your case) is added. You can also “do a search for…” the budget data type:sum (make sure the data is being stored as a number so you’re able to call up math functions)

Basically I’m creating a new thing to store each radio response, then storing the sum of those values on the thing that provides the survey “type.” The longest quiz is 13 questions - most are 5-10 questions. I tried running my workflow, and it was extremely slow. Hoping that I’ve just missed a more elegant and efficient way of doing this.

Hello, were you able to solve it? I have the same problem

The way you’re doing it is ideally how i would do it myself. Bare in mind the way you’re doing the searches to score, Params provided, number of records in database, states vs database for parts of the process and more variables will determine how fast this will actually happen.

Per se you have 100,000 responses and you’re trying to score by providing a single field with no privacy rules setup, it will take longer than if you have privacy rules setup where the server only has access to that specific ongoing quiz & you’re providing multiple search params and instead of the server searching through 100,000 records it now only needs to search 13 records.

Without actually seeing your setup giving you definitive answers on how to speed it up isn’t easy however what I explained above tends to be a common theme of why apps run slow in bubble.