Hi I have reviewed my form, and replaced xml values with the actual choice responses for some multiple choice questions as I need these to show because I am linking my form to power bi (on another post stephen suggested that I do this).
I am now however getting the following error when I try to preview my form
“There does not seem to be a
allow_choice_duplicates column header defined in your settings sheet. You must have set
allow_choice_duplicates setting in your settings sheet to have duplicate choice list names in your choices sheet”
I do not understand this, as i do not have duplicate choices within the same question.
July28workbook2duplcatechoices.xlsx (82.7 KB)
I did subsequently remove as suggested police officer and retired.
However, in the question where I am asking the primary applicant, then in an idexed repeat group the individual’s there employment status, the choice responses are the same.
I do need these responses to be summed in a calculation. Do I still need to use some distinction ? This was not necessary when the xml value was numeric.
July28workbook2duplcatechoices.xlsx (82.6 KB)
Choice responses may be the same but available for other questions. Please assist in resolving.