The following page describes the spreadsheet format used by ActivityInfo’s form designer.
Rows
In general, each field appears in a single row:
FieldCode | FieldName | FieldType |
---|---|---|
NAME | What is your name? | text |
BIRTH_DATE | What is your birth date? | date |
How many children do you have? | quantity |
However, for single and multiple select, a single field will use multiple rows, one for each choice. The Field Name must be repeated for each choice.
FieldCode | FieldName | FieldType | Choice |
---|---|---|---|
NAME | What is your name? | text | |
COLOR | Favorite Color? | single select | Green |
COLOR | Favorite Color? | single select | Blue |
COLOR | Favorite Color? | single select | Red |
Column headers
Header | Required? | Description | Example |
---|---|---|---|
FormId | Ignored on import | The id of the ActivityInfo form | c1qbkehljee5tc94 |
FieldId | Ignored on import | The id of the field. | c1pfkxkljee61u45 |
FieldCode | Optional | The field’s code | BIRTH_DATE |
FieldType | Required | The type of field. See table below. | date |
FieldName | Required | The field’s label | What is your date of birth? |
FieldDescription | Optional | The field’s description | Enter the respondent’s date of birth. |
Required |
Optional | true if the field is required | true |
Key | Optional | true if the field is a Key Field | true |
Unique | Optional | true if the field must be Unique | true |
Hide from entry | Optional | true if the field should be hidden during data entry | true |
Hide in table | Optional | true if the field should be hidden from the table view | true |
Read-only | Optional | true if the field should be hidden during data entry | true |
Units |
Optional Only relevant for Quantity fields |
The units of the quanitty | hectacres |
Formula | Required for calculated fields | The formula of the caculated field | YEARFRAC(BIRTH_DATE, TODAY()) |
Prefix Formula |
Optional Only relevant for Serial number fields |
The formula for the serial number prefix | CONCAT(PROVINCE.CODE, "-", TERRITORY.CODE) |
Referenced Form | Required for reference fields | The id of the referenced form | c1qbkehljee5tc94 |
Relevance Condition | Optional | Formula describing when the field is relevant | AGE > 18 |
Validation Condition | Optional | Formula describing when the field is valid | AGE > 18 && AGE < 100 |
Choice | Required for single selection and multiple select fields | The label of the choice | Very satisfied |
Reverse reference form id | Required for reverse reference fields | The id of a form that references this form | c1qbkehljee5tc94 |
Reverse reference field id | Required for reverse reference fields | The id of the field that references this form | c1pfkxkljee61u45 |
Section header indentation level |
Optional Relevant for section headers |
The indentation level of the header | 1 |
Field types
Field type in user interface | Field type in spreadsheet |
---|---|
Attachment | attachment |
Calculated | calculated |
Reference | reference |
Multi-line text | narrative |
Quantity | quantity |
Geographic Point | geopoint |
Multiple Select | multiple select |
Single Select | single select |
Barcode | barcode |
Date | date |
Month | month |
Fortnight | fortnight |
Week | week |
Subform | subform |
Text | text |
Serial Number | serial |
Section Header | section header |
Reverse Reference | reverse reference |