How to Display Quizzes with Available Spots in a Repeating Group

[galliaeran]

Hi everyone,

I have a repeating group with a data type of ‘quizzes’ and the data source is ‘Search for quizzes.’ In the repeating group, I have a group with a ‘Type of content’ set to ‘quiz,’ and the data source is ‘Current cell’s quiz.’

In the ‘quiz’ data type, I have a field called ‘participants,’ which is a list of users, and ‘max participants,’ which is a number.

I want to show only the quizzes in the repeating group where the number of ‘participants’ is less than the ‘max participants’.

How can I do that?

[boston85719]

In search use a constraint that #participants is less than max number

[galliaeran]

I already tried but i dont have this option. It only show me participants empty/not empty/contain/not contain.

[adamhholmes]

You can’t do this type of search in Bubble.

So you’ll either have to use an advanced filter (not recommended), or do what I suggested in my reply to your previous question.