But now, my surveyors tell me that the option ‘No infrastructure is pwd/child friendly’ does not turn up without selecting ‘no women’s toilet infrastructure available’.
This does not make sense, because certain toilets may have infrastructure but they may not be child/pwd friendly. How do i rectify this or force the ‘No infrastructure is pwd/child friendly’ in both follow up questions?
tl;dr: I want options for follow-up questions (f_PwD and f_child) to be displayed based on a multiselect option under (f_PT). But I always want the ‘no’ name to be displayed, irrespective of the f_PT selection. is there a simple way to do this. All the answers I’ve seen are multiple lines of code. I need to redo this 6 times within the survey, and the risk of error is great.
I’m adding a sample of the worksheet here since I am unable to share the entire survey file; I was looking for a simple code that could help force me to add the name ‘no’ options in the follow up questions 6(a) and 6(b).
I’d gone through a couple of other solutions, but there are several calculations involved, and I didn’t want to keep repeating it in multiple areas in case I make a mistake.
Do we not have a simpler solution for this? This is 4 lines of additional code - which I need to repeat for 5 other questions. This survey form is already 800 lines long and the choices sheet has 2000+ records. I was wondering if something simpler was available?