Filtering out an option set in repeating group

Hi Bubblers,

I am looking for some help:

  • I have a list of questions that everyone who signs up to my app needs to answer, I have created these an option set containing the question number, category, and question. In the database this is OSQuesitons
  • These questions are displayed on a questions page in a repeating group with some inputs so that the user can answer the question. Once they answer them a new data type is created called Answers which are tied to their profile, this contains all of the Option Set fields (question, number etc) and then an Answer field

What I want to be able to do but can’t work out how is to have the repeating group on the questions hide the question once it has been answered, a user might answer a few questions and then go away only to come back and answer the rest so I would like the list to basically show all of the unanswered questions. I was hoping I would be able to match the answers data type with the OSQuestions (through one of the fields that would be the same for both data types) to be able to remove it from the list for that user but can’t seem to work out how.

Does anyone have any ideas or know if it is even possible in this way?


Hi there, @andy19… if I understand your post correctly, it seems to me like a simple way to go on this one could be to have a field on the User data type that is a list of the questions a user has answered (the field would be linked to the option set, of course). As a user answers questions, you would add each question to the user’s list, and you would use the :minus list operator in the repeating group’s data source to remove those questions from the group.

Hope this helps, even if it’s just food for thought.


Hi @mikeloc that has worked! I didn’t really know about the :minus operator so thank you very much!

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.