FormInformation
The FormInformation parameters are returned by certain APIs.
Note: Each row contained in the form information list is an instance
of a form template, that can be a Template, Group, Table Group, Question or
Static Text. Some columns will only contain information for specific form
template types e.g. The answer column will only contain information if the
form template type is a question, and has been answered.
| Parameter | Type | Max Length | Allow NULL | Description |
|---|---|---|---|---|
| FormTemplateID | integer | The unique ID of the form template. | ||
| FormTemplateLinkID | integer | Y | The form template link ID. The form template link id will go across versions of the form template. e.g. The same question in different form versions will contain the same FormTemplateLinkID, but different FormTemplateID's. | |
| FormAnswerID | string | 20 | The unique ID of the answer. | |
| SortOrder | integer | The sort order. When questions have multi-answers, duplicate sort orders appear. In this case sort again by AnsweredDateTime. | ||
| Type | string | 100 | The type of form template instant (Template, Group, Table Group, Question or Static Text). | |
| QuestionType | string | 100 | The question type. See List of Question Types. | |
| DataType | string | 20 | The type of data that the answer contains. See List of Question Types for examples. | |
| Question | string | 200 | The question. | |
| Alias | string | 100 | The alias to the form template. The alias is unique within the form only, and also spans the versions. The same question can appear in more than 1 group, but the alias to the question will be unique. | |
| Level | The level in the tree in which the form template appears. Can be used to indent questions, so they appear part to the group they were configured for. | |||
| Answer | string | 8000 | The answer to the question. | |
| AnsweredBy | string | 20 | The name of the person that answered the question. | |
| AnsweredDateTime | DateTime | Y | The date and time when the answer was recorded. | |
| HasActions | boolean | Does the answer, to the question, have any associated actions attached? | ||
| HasImages | boolean | Does the answer, to the question, have any associated images attached? | ||
| HasComments | boolean | Does the answer, to the question, have any associated comments attached? | ||
| HasDocuments | boolean | Does the answer, to the question, have any associated documents attached? |
