Hi all!
1. What is the problem? Be very detailed.
I'm building a form with xlsx/Excel and for a set of questions I need to use the choice filter. Q1 is a select_multiple type with 27 possible answer choices that we want users to select 5 of. Q2 is rank type that asks them to rank the selected 5 in order of importance. I'm trying to use a choice_filter to refer to the selected answers in the previous answer and have Q2 be a rank question that only has them rank those 5 selected answers.
I've been able to convert to xlm both on XLSForm offline and on xlsform.opendatakit.org. When I go to upload the form to aggregate I get the error "HTTP Status 400 - Problem with JavaRosa Parsing Form: org.opendatakit.aggregate.exception.ODKIncompleteSubmissionData: Javarosa failed to construct a FormDef. Is this an XForm definition?"
Not sure if I haven't gotten the syntax right, if I'm missing a column somewhere, or if choice_filter is a function that isn't supported with the server we're using for ODK Aggregate?
2. What app or server are you using and on what device and operating system? Include version numbers.
Building the form in excel on a mac, converting to XForm using ODK XLSFrom Offline v1.11.1.
ODK Aggregate v1.4.15 Production
3. What you have you tried to fix the problem?
I have tried every solution I could find in the forum, from using a filter column in the choices sheet, to all the different versions of "selected(${VAR})" "selected(${VAR}, filter)" "selected(${VAR}, VAR)" "selected(${VAR}, name)" "selected(${VAR},name) = 'true' " and so forth...
4. What steps can we take to reproduce the problem?
5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.
I've included a test form with the questions that would be using cascading select and a screenshot of the error on Aggregate
ODKforum_testQuestionnaire.xlsx (15.5 KB)
Refusing to admit defeat, so any help is appreciated. Thanks!