Error loading survey: cascading choices can only reference one choice list

User Support Form Building
, ,
7

@Kal_Lam, @yajxyooj,

I tried the format provided above and the help link you’ve provided, but it did not fully work for me. It would show the state and county correctly, but would not display the city when the county had been chosen. I attach a sample file of the format that finally worked. You would need to modify the above example so that:

  1. ‘state’ column and ‘county’ column are combined into a single ‘cf’ column in the ‘choices’ sheet
  2. On the ‘survey’ sheet, ‘choice_filter’ column: question_2 - replace state with cf i.e cf = ${question_1}
  3. For question_3 - use a single choice as follows, replacing ‘county’ with cf i.e cf = ${question_2}

format_of_new_cascading_select.xls (13.4 KB)

1 Like