Forum Academy Marketplace Showcase Pricing Features

Need help with a 'Do a search' trick

So here’s where i’m at: i have a repeating group displaying the scores from five DB entries that have a particular field in common called ‘TotalScore’. As you can see in the picture below, i sorted them by creation date and set it to ‘items until #5’. Although i have have been able to do this, the problem i am having is that I don’t just want to get the last 5 ‘totalscores’ i want to make sure it is only one score from each of the 5 total score types (“quiz”). In its current state its possible that instead of getting the last score for questionnaire 1, 2, 3, 4, & 5 (which is what i want), it may just pull up (e.g.) questionnaire 3, 4, 5, 5, 5 instead (because if questionnaire five was done three times then quiz 3,4,5,5,5 would show up when searching for ‘items until #5’).
Please help me figure out how to make the repeating group take the LAST SCORES from each QUIZ. In other words how do i not just search the database for entries with with ‘totalscore = yes’ but also for last of each of the five quizzes. Hope i’ve repeated myself enough for that to make sense. Thanks in advance. Any help or ideas would be great.

So far i have been able to make a repeating group display 5


Anybody?

I’m still needing help with this. I’m trying to figure out how to constrain it to only the last one from each of the 5 quizzes.

Anybody have any ideas?

Still looking for help, cheers.

I think that maybe your DB setting is not correct for what you want to do.
Can you confirm that you have Quiz and each of them can have more than 1 answers for 1 user?

Yeah there’s multiple for each quiz.