Cannot view collected multimedia data in web form view

Related to the problem below, the form does not display the collected multimedia for a particular question, only the multimedia from the first question.

Workaround:

  1. To avoid violating confidentiality or other problems, upload a blank / fummy form before as first data item
  2. As multimedia is also not exported via csv the only way to access multimedia data is through the database.

Latest version with this issue: 1.16.3

First captured multimedia item display in blank web form

If a form has multimedia questions and the very first time you enter data into that form, you submit multimedia data, then each time following that you open a blank form to capture data through web capture, the data from the first form will be displayed to the data capturer.

Workaround: To avoid violating confidentiality or other problems, upload a blank / fummy form before as first data item

Latest version with this issue: 1.16.3

Calculation doesn’t work on web forms

You can enter calculations in the form designer that can work on the mobile client, however they do not work on the web form.

Workaround: Use the javascript tab to add calculation functionality to your webform

Latest version with this issue: 1.16.3

Cannot export text longer than 255 characters

If you set a question of type Text and enter text longer than 255 characters – which the web form and mobile allow you too – then the data is saved, but cannot be processed for viewing in the Dashboard.

This is because, by default, openXdata sets up a table with the row type VARCHAR(255) for a field of type Text.

Workaround: manually change the Type of the field in the database table that holds the exported data for your form as appropriate

Single Select Dynamic does not work in repeat questions

You cannot use single select dynamic questions inside a repeat group

Case sensitivity of usernames determined by MySQL table settings

Whether username are case sensitive or not is determined by the case sensitivity settings of the MySQL table ‘users’. By defauls this is _ci for case insensitive. This means that Admin = admin when entered as a username. If you wish usernames to be case sensitive so Admin and admin are different usernames then you need to set the table to not be case insensitive