Hello everyone, I am building a form with two multiple-choice fields: ‘Desc’ and ‘Checker.’ I want the ‘Checker’ field to be dependent on the ‘Desc’ field. I have attached the file and included the mapping in the ‘Mapping’ sheet.
aUPXaYcTqYV2GHCowSkg4u (1).xlsx (13.5 KB)
for your source question Desc, which is the Multiple question type, you need to write selected(${desc}, filter). If there are multiple filters, you should use the OR operator.
The code to write in the choice_filter column of the checker row should be as follows:
selected(${desc}, filter) or selected(${desc}, filter_1) or selected(${desc}, filter_2) or selected(${desc}, filter_3) or selected(${desc}, filter_4) or selected(${desc}, filter_5) or selected(${desc}, filter_6) or selected(${desc}, filter_7) or selected(${desc}, filter_8) or selected(${desc}, filter_9) or selected(${desc}, filter_10) or selected(${desc}, filter_11) or selected(${desc}, filter_12) or selected(${desc}, filter_13)
3 Likes
Many thanks. Truly grateful.
1 Like
