Form import/export spreadsheet format

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
Next item
Relevance rules