Hi all,
I have a gallery of survey questions (galSurveyQuestions) with a nested gallery of checkboxes (galMultipleChoice) for multiple choice questions.
galMultipleChoice.Items is populated from a column (cr4a5_multiplechoices) containing comma delimited values - (RenameColumns(Split(ThisItem.cr4a5_multiplechoices,","),"Result","Value")
A collection ("answeredquestions") exists containing any questions that have already been answered. The chosen answers to the question is comma delimited in cr4a5_answer.
Where i'm stuck, is trying to control the "Default" of the checkbox within the nested gallery. If any items in "multiplechoices" is in "answer", I want the checkbox to default to true so its checked by default. So I need to split both and compare the two tables to see if any of the values in one (multiplechoices) is in the other (answer), and if so, check that box.
Thanks in advance for any assistance on this!

Report
All responses (
Answers (