# \#odk-xlsform-offline

**URL:** https://forum.getodk.org/tag/odk-xlsform-offline/40.md

[Latest](https://forum.getodk.org/latest.md) · [Categories](https://forum.getodk.org/categories.md) · [Tags](https://forum.getodk.org/tags.md)

---

## [Arranging search/ select results in alphabetic, ascending, descending and in order of date](https://forum.getodk.org/t/arranging-search-select-results-in-alphabetic-ascending-descending-and-in-order-of-date/20418)

<div class="topic-metadata">

**Author:** [@safi](https://forum.getodk.org/u/safi)\
**Replies:** 6\
**Last updated:** [December 30, 2024, 5:27pm UTC](https://forum.getodk.org/t/arranging-search-select-results-in-alphabetic-ascending-descending-and-in-order-of-date/20418 "2024-12-30T17:27:24Z")

</div>

1. What is the general goal of the feature? to be able to show results of a search or select in alphabetic or ascending or descending or in order of date 2. What are some example use cases for this feature? some one d…

---

## [Questions not showing when they should](https://forum.getodk.org/t/questions-not-showing-when-they-should/15675)

<div class="topic-metadata">

**Author:** [@Sivan\_van\_Leerzem1](https://forum.getodk.org/u/Sivan_van_Leerzem1)\
**Replies:** 6\
**Last updated:** [November 16, 2021, 3:18pm UTC](https://forum.getodk.org/t/questions-not-showing-when-they-should/15675 "2021-11-16T15:18:35Z")

</div>

Hi all, After programming and testing forms succesfully, the field team reported that sometimes questions don't show up when they should. However, I checked many times but everything under 'relevant' is correct, moreove…

---

## [Need 3 constraint support](https://forum.getodk.org/t/need-3-constraint-support/32751)

<div class="topic-metadata">

**Author:** [@Glen.Poresh](https://forum.getodk.org/u/Glen.Poresh)\
**Replies:** 1\
**Last updated:** [March 11, 2021, 4:07pm UTC](https://forum.getodk.org/t/need-3-constraint-support/32751 "2021-03-11T16:07:41Z")

</div>

Hi Odk community need a support from you guys. So we need 3 conditions here to be met: not selected that there was no door and selected that the frame was used for the door; not selected that there was no roof and sel…

---

## [Multiple choice will appear on label in the repeat](https://forum.getodk.org/t/multiple-choice-will-appear-on-label-in-the-repeat/32525)

<div class="topic-metadata">

**Author:** [@Glen.Poresh](https://forum.getodk.org/u/Glen.Poresh)\
**Replies:** 2\
**Last updated:** [February 22, 2021, 1:15pm UTC](https://forum.getodk.org/t/multiple-choice-will-appear-on-label-in-the-repeat/32525 "2021-02-22T13:15:21Z")

</div>

Hi ODK Community, I hope you are well. again get back with a very complicated issue. choice will appear on label in the loop. below is the example Q.1: Make selections ... A) X \[SELECTED\] B) Y \[SELECTED\] C) Z \[SE…

---

## [Can't select "Validate converted XForm..." even after installing Java](https://forum.getodk.org/t/cant-select-validate-converted-xform-even-after-installing-java/31208)

<div class="topic-metadata">

**Author:** [@Austin\_h](https://forum.getodk.org/u/Austin_h)\
**Replies:** 1\
**Last updated:** [November 17, 2020, 4:57pm UTC](https://forum.getodk.org/t/cant-select-validate-converted-xform-even-after-installing-java/31208 "2020-11-17T16:57:30Z")

</div>

I just downloaded ODK and the most recent Java on my mac. ODK won't let me select the Validate converted XForm with ODK Validate (Requires Java) option. Macbook pro running macOS Mojave version 10.14.6 Reinstalled ODK,…

---

## [XLSForm Offline 1.4.0 ODK Validation errors](https://forum.getodk.org/t/xlsform-offline-1-4-0-odk-validation-errors/12544)

<div class="topic-metadata">

**Author:** [@janderpants](https://forum.getodk.org/u/janderpants)\
**Replies:** 6\
**Last updated:** [October 11, 2020, 12:32pm UTC](https://forum.getodk.org/t/xlsform-offline-1-4-0-odk-validation-errors/12544 "2020-10-11T12:32:33Z")

</div>

What is the problem? Please be detailed. When I try to convert forms from XLXS to XLM format I get this error: ODK Validate errors: Exception in thread "main" java.lang.NoClassDefFoundError: org${XFormParseException}C…

---

## [Javarosa failed to construct a FormDef. Is this an XForm definition?](https://forum.getodk.org/t/javarosa-failed-to-construct-a-formdef-is-this-an-xform-definition/27559)

<div class="topic-metadata">

**Author:** [@Nikunj\_Sakhiya](https://forum.getodk.org/u/Nikunj_Sakhiya)\
**Replies:** 1\
**Last updated:** [June 22, 2020, 8:59pm UTC](https://forum.getodk.org/t/javarosa-failed-to-construct-a-formdef-is-this-an-xform-definition/27559 "2020-06-22T20:59:42Z")

</div>

1. What is the problem? Be very detailed. When I try to update form, it shows following error : HTTP Status 400 - Problem with JavaRosa Parsing Form: org.opendatakit.aggregate.exception.ODKIncompleteSubmissionData: Jav…

---

## [Working with Equations](https://forum.getodk.org/t/working-with-equations/25461)

<div class="topic-metadata">

**Author:** [@cliffordpg](https://forum.getodk.org/u/cliffordpg)\
**Replies:** 1\
**Last updated:** [March 12, 2020, 10:43am UTC](https://forum.getodk.org/t/working-with-equations/25461 "2020-03-12T10:43:54Z")

</div>

1. What is the problem? Be very detailed. I've designed a form that requires a calculation at the end. The equation for this calculation has been supplied by a different team and I'm unsure which functions to use to rep…

---

## [XPath evaluation: type mismatch Error in the form conversion](https://forum.getodk.org/t/xpath-evaluation-type-mismatch-error-in-the-form-conversion/25264)

<div class="topic-metadata">

**Author:** [@cliffordpg](https://forum.getodk.org/u/cliffordpg)\
**Replies:** 2\
**Last updated:** [March 5, 2020, 8:06am UTC](https://forum.getodk.org/t/xpath-evaluation-type-mismatch-error-in-the-form-conversion/25264 "2020-03-05T08:06:50Z")

</div>

1. What is the problem? Be very detailed. I have a simple form with a few questions that need to be repeated, but am getting the following error from XLSForm Offline converter. It started when I add a second member for…

---

## [Error: 'Allow\_choice\_duplicates'](https://forum.getodk.org/t/error-allow-choice-duplicates/21440)

<div class="topic-metadata">

**Author:** [@Sivan](https://forum.getodk.org/u/Sivan)\
**Replies:** 26\
**Last updated:** [February 6, 2020, 11:50pm UTC](https://forum.getodk.org/t/error-allow-choice-duplicates/21440 "2020-02-06T23:50:34Z")

</div>

Hello all, When converting an excel build form using xlsform online, the following error occurs: "There does not seem to be a allow\_choice\_duplicates column header defined in your settings sheet. You must have set allo…

---

## [NPE when Publishing to Google Spreadsheets](https://forum.getodk.org/t/npe-when-publishing-to-google-spreadsheets/23695)

<div class="topic-metadata">

**Author:** [@esurface](https://forum.getodk.org/u/esurface)\
**Replies:** 0\
**Last updated:** [December 4, 2019, 10:48pm UTC](https://forum.getodk.org/t/npe-when-publishing-to-google-spreadsheets/23695 "2019-12-04T22:48:34Z")

</div>

1. What is the problem? Be very detailed. With the deprecation of Google Fusion Tables yesterday, we started publishing to Google Spreadsheets in our production set up. Of our 40+ forms, one will not publish to Spreadsh…

---

## [Xpath Dependency cycle error explanation needed](https://forum.getodk.org/t/xpath-dependency-cycle-error-explanation-needed/12962)

<div class="topic-metadata">

**Author:** [@SGSC](https://forum.getodk.org/u/SGSC)\
**Replies:** 4\
**Last updated:** [October 24, 2019, 11:56am UTC](https://forum.getodk.org/t/xpath-dependency-cycle-error-explanation-needed/12962 "2019-10-24T11:56:54Z")

</div>

Hello ODKers, Can anyone please explain me about "Error: b'ODK Validate Errors:\\nXForm Parse Error: XPath Dependency Cycle" . Can I anywhere read about errors in detail Thanks and Regards, SGSC

---

## [Windows defender detects trojan in XLSForms download](https://forum.getodk.org/t/windows-defender-detects-trojan-in-xlsforms-download/22809)

<div class="topic-metadata">

**Author:** [@Paul\_Storry](https://forum.getodk.org/u/Paul_Storry)\
**Replies:** 1\
**Last updated:** [October 17, 2019, 4:50pm UTC](https://forum.getodk.org/t/windows-defender-detects-trojan-in-xlsforms-download/22809 "2019-10-17T16:50:12Z")

</div>

1. What is the problem? Be very detailed. I have dowloaded XLSForms offline, in particular the file called ODK-XLSForm-Offline-Windows-v1.11.1.zip from https://github.com/opendatakit/xlsform-offline/releases/tag/v1.11.1 …

---

## [Converting XLform offline](https://forum.getodk.org/t/converting-xlform-offline/20447)

<div class="topic-metadata">

**Author:** [@Kakwasha](https://forum.getodk.org/u/Kakwasha)\
**Replies:** 3\
**Last updated:** [June 30, 2019, 4:56pm UTC](https://forum.getodk.org/t/converting-xlform-offline/20447 "2019-06-30T16:56:59Z")

</div>

Evening Forum, I am trying to convert my XLform offline, and I have received the following error message "ODK XLSForm Offline Warnings: The following language declarations do not contain valid machine-readable codes: Eng…

---

## [Minimal appearance for select\_multiple](https://forum.getodk.org/t/minimal-appearance-for-select-multiple/20350)

<div class="topic-metadata">

**Author:** [@hfry](https://forum.getodk.org/u/hfry)\
**Replies:** 7\
**Last updated:** [June 14, 2019, 3:42pm UTC](https://forum.getodk.org/t/minimal-appearance-for-select-multiple/20350 "2019-06-14T15:42:35Z")

</div>

Hi, The question I'm asking will probably be easier to understand if I explain the information I want to gather. We want to know which supplements a person has taken, how often, and at what dosage, using pictures to id…

---

## [Repeat within a repeat not working anymore?](https://forum.getodk.org/t/repeat-within-a-repeat-not-working-anymore/17593)

<div class="topic-metadata">

**Author:** [@wrkadri](https://forum.getodk.org/u/wrkadri)\
**Replies:** 2\
**Last updated:** [February 1, 2019, 7:07am UTC](https://forum.getodk.org/t/repeat-within-a-repeat-not-working-anymore/17593 "2019-02-01T07:07:58Z")

</div>

Hey guys, I have been using ODK since 2015 and it was working fine. Today I tried to create a new xlsform that includes a repeat within a repeat but it is not working. Knowing that I have tried this before and it was wo…

---

## [Urgent: Facing Problem in uploading form with double repeat in aggregate](https://forum.getodk.org/t/urgent-facing-problem-in-uploading-form-with-double-repeat-in-aggregate/17131)

<div class="topic-metadata">

**Author:** [@Likhon](https://forum.getodk.org/u/Likhon)\
**Replies:** 7\
**Last updated:** [January 22, 2019, 12:01pm UTC](https://forum.getodk.org/t/urgent-facing-problem-in-uploading-form-with-double-repeat-in-aggregate/17131 "2019-01-22T12:01:52Z")

</div>

Dear, I'm facing unknown trouble in converting xls to xml through xlsform. When I'm trying to convert an xls file that has double repeat group (repeat within repeat) to xml through xlsform in online, the xlsform server …

---

## [Show value of or\_other in selection](https://forum.getodk.org/t/show-value-of-or-other-in-selection/16044)

<div class="topic-metadata">

**Author:** [@coderscoven](https://forum.getodk.org/u/coderscoven)\
**Replies:** 2\
**Last updated:** [November 2, 2018, 3:50pm UTC](https://forum.getodk.org/t/show-value-of-or-other-in-selection/16044 "2018-11-02T15:50:39Z")

</div>

I have a select\_multiple having a list of options. I added a or\_other in the type column such that the user can type a specify option. The maximum number of items required to be selected is set to 3. These selected opti…

---

## [Error in choice filter during begin repeat](https://forum.getodk.org/t/error-in-choice-filter-during-begin-repeat/13049)

<div class="topic-metadata">

**Author:** [@SGSC](https://forum.getodk.org/u/SGSC)\
**Replies:** 10\
**Last updated:** [September 21, 2018, 12:58am UTC](https://forum.getodk.org/t/error-in-choice-filter-during-begin-repeat/13049 "2018-09-21T00:58:16Z")

</div>

Hello ODKers, I am facing an error "XPath evaluation: type mismatch This field is repeated". I have not faced this problem previously . I have a begin group inside a begin repeat . Begin repeat has no repeat\_count . Dat…

---

## [Change of links for ODK documentation](https://forum.getodk.org/t/change-of-links-for-odk-documentation/14040)

<div class="topic-metadata">

**Author:** [@SGSC](https://forum.getodk.org/u/SGSC)\
**Replies:** 6\
**Last updated:** [August 1, 2018, 7:18pm UTC](https://forum.getodk.org/t/change-of-links-for-odk-documentation/14040 "2018-08-01T19:18:51Z")

</div>

Hello ODKers, I have noticed that the links for the ODK documentation has been changed. Can anyone please help me to find the search() function documentation link and the new link to the below mentioned link https://op…

---

## [Repeat count Problem](https://forum.getodk.org/t/repeat-count-problem/13304)

<div class="topic-metadata">

**Author:** [@SGSC](https://forum.getodk.org/u/SGSC)\
**Replies:** 5\
**Last updated:** [May 29, 2018, 6:00pm UTC](https://forum.getodk.org/t/repeat-count-problem/13304 "2018-05-29T18:00:26Z")

</div>

Hello ODKers, I am facing a problem in case of repeat count. The repeat count is dynamic depending on an entry. If I enter a value for example say 2, the group will repeat for 2 times. But, if I go back and change the n…

---

## [Format date time not working in Enketo](https://forum.getodk.org/t/format-date-time-not-working-in-enketo/13236)

<div class="topic-metadata">

**Author:** [@SGSC](https://forum.getodk.org/u/SGSC)\
**Replies:** 6\
**Last updated:** [May 28, 2018, 6:18am UTC](https://forum.getodk.org/t/format-date-time-not-working-in-enketo/13236 "2018-05-28T06:18:22Z")

</div>

Hello ODKers, I am trying to convert a time question using format-date-time() . In enketo it is giving an output as "Invalid Date" where as in collect it is giving me the result what i need. Why is it not working in Enk…

---

## [Select\_multiple related choice](https://forum.getodk.org/t/select-multiple-related-choice/12815)

<div class="topic-metadata">

**Author:** [@Raneem\_Al\_Sawas](https://forum.getodk.org/u/Raneem_Al_Sawas)\
**Replies:** 4\
**Last updated:** [April 24, 2018, 7:41am UTC](https://forum.getodk.org/t/select-multiple-related-choice/12815 "2018-04-24T07:41:06Z")

</div>

Hello Can you help me please. I have select\_multiple question, and I want to link one of its choice (for example 'A' choice) to another question. when I try to do that, it is shows the related question only if I sele…

---

## [Relate select\_multiple with many questions](https://forum.getodk.org/t/relate-select-multiple-with-many-questions/12748)

<div class="topic-metadata">

**Author:** [@Raneem\_Al\_Sawas](https://forum.getodk.org/u/Raneem_Al_Sawas)\
**Replies:** 3\
**Last updated:** [April 23, 2018, 12:16pm UTC](https://forum.getodk.org/t/relate-select-multiple-with-many-questions/12748 "2018-04-23T12:16:58Z")

</div>

Hello can you please help me with this questionnaire. I have a select\_multiple question with 20 choices ( it is about item distributed) and i want to link each item that has been selected in past question with many qu…

---

## [Begin repeat count Error](https://forum.getodk.org/t/begin-repeat-count-error/12597)

<div class="topic-metadata">

**Author:** [@SGSC](https://forum.getodk.org/u/SGSC)\
**Replies:** 2\
**Last updated:** [April 9, 2018, 1:52pm UTC](https://forum.getodk.org/t/begin-repeat-count-error/12597 "2018-04-09T13:52:33Z")

</div>

Hello ODKers, There is a problem i am facing with count function. If add a repeat group and remove it , then also the count function is counting that repeat group which has been removed. Thanks and Regards, SGSC.

---

## [Restriction on repeat\_count](https://forum.getodk.org/t/restriction-on-repeat-count/12541)

<div class="topic-metadata">

**Author:** [@SGSC](https://forum.getodk.org/u/SGSC)\
**Replies:** 1\
**Last updated:** [April 2, 2018, 6:31pm UTC](https://forum.getodk.org/t/restriction-on-repeat-count/12541 "2018-04-02T18:31:12Z")

</div>

Hello ODKers, Can we put any upper restriction for repeat\_count . If i want to repeat the questions \<=n number of times . It can be less than n but not more than n. Thanks and Regards, SGSC.

---

## [Constraint condition for some common words](https://forum.getodk.org/t/constraint-condition-for-some-common-words/12380)

<div class="topic-metadata">

**Author:** [@SGSC](https://forum.getodk.org/u/SGSC)\
**Replies:** 3\
**Last updated:** [March 22, 2018, 11:22am UTC](https://forum.getodk.org/t/constraint-condition-for-some-common-words/12380 "2018-03-22T11:22:24Z")

</div>

Hello ODKers, Can i make text box not accept some values . For example text box should not accept "Hospital" or "hospital" or "hOspital" etc . i.e irrespective of the case of alphabets it should not accept the word . Si…

---

## [Form Version](https://forum.getodk.org/t/form-version/12330)

<div class="topic-metadata">

**Author:** [@SGSC](https://forum.getodk.org/u/SGSC)\
**Replies:** 7\
**Last updated:** [March 20, 2018, 1:46pm UTC](https://forum.getodk.org/t/form-version/12330 "2018-03-20T13:46:56Z")

</div>

Hello ODKers, There is an option of version in the settings page . What is the use of it . Can we create XForm with different versions and upload on to the Aggregate though it's Form ID is same?. Thanks and Regards, S…
