Large Datasets

Large Data forms have the following restrictions/limitations:

There must be no nested/indented questions. Therefore, Heading and Repeatable section lines are unavailable.

Only the following answer types are available:

• Text – single line
• Text – multiple line
• Drop-down list
• Number
• Date
• List

All Large Data forms have a hidden Large Data Grouping question, with the Text - single line answer type. This appears as a column in the form table in the staging database and is used to group multiple instances of the form together into a single dataset.

An optional Large Data Attachment question (with the Attachment answer type) can be added by toggling the Has graphable attachment option in the Properties tab of the Form Designer. This question will then be added to the staging database as a varbinary field on the form table and is used to attach JSON which can be represented in a graph to each form instance.

To allow repurposing existing Subforms as Large Data forms, a Clone as Large Data button has been added to the Properties tab of the Form Designer for Subforms which are compatible with the Large Data form type (i.e. the Subform is not using features that would be unavailable in a Large Data form, e.g. headings). Clicking the button will create a clone of the Subform in a new browser tab. The clone will be of the Large Data form type.