Release 1.7 - Coral Lion

1 March 2022 2022-03-01 | by Qandai | 2 min read

We have swiftly moved on to integrating Handsontable, an elegant data grid interface akin to Google Sheets. Having this interface in place allowed us to support irregularly-shaped datasets; in other words, we are no longer asking for the ‘question column’ and ‘answer column’. Instead, the user has the freedom to select columns and individual cells to their heart’s content, allowing them to work with complex questionnaires.

The old way - questions/answers are expected to be in single columns

img

The new way - users indicate the cells which contain the questions (blue) and answers (green)

This body of work will allow us to offer the ability to change how Qandai is populating questionnaires, even after they are uploaded to the system. We have also provided the foundation to introduce the ability to manage excel files with multiple sheets.