I would like to populate a Repeat Group element based on a number of check box status; to make thing simple lets assume we have only three booleans (Yes/No) fields for each entry in a database {Name, bool_1, bool_2, bool_3}
I would like to return a list of all the elements that have at least the boolean field checked
The workflow triggered by the button is the following:
empty the list currently in the repeated group of things
Display List in Repeating Group by ‘searching’ without constraint…basically getting all the table
Display List in Repeating Group by: (searching for option1 = yes) intersect with (the result of the previous step) and put in the ‘only when field’ when checkbox1 is checked
repeat step 3 but with option 2
same as before until you do all the options…
I think and hope that there is a better way of doing this because regardless of the time necessary to implement all this when you have many options, it is really hard to mantain and really prone to error.
If anyone has a better way of doing it, please share!