Adding a Reference field

The following section describes how to add a Reference field when designing a Form. Reference fields are very powerful fields which make it possible to connect Forms to other Forms or to the built-in Geographic database of ActivityInfo. Users can link their Records  to the Records of another Form.

To link a Record of one Form to a Record of another Form you need to use as common reference:

Using a Reference field and multiple Keys in the referenced Form, you can also create a 'cascading' effect to allow users to select from a series of options.

  • When referencing a Form, users will be able to select from a list of options added to that Form using the Reference field. To limit the options that appear to them to selected options you can set validation rules to the Reference field.
  • You can add a prefix to the Serial Number to customize it and make it more readable for your users. This allow you to show - without revealing much information- what the Record is about, if you choose to use the Serial Number as the common reference.
  • The maximum length of the characters of a Key field to appear in a dropdown result of a Reference field is 128 characters.
How to add a Reference field to reference one field of another Form
  • Before adding a Reference field, make sure you have defined as Key field the field you want your Form to refer to.
  • Navigate to your Form, and in the Form Design page, click on "Reference" to select it from the Fields palette.

Make sure you have defined as Key the field you want your Form to refer to.

  • Search for the Database and the Form that contains the Form and the Records you want to link to. Click on the arrows to reveal the contents of each Database.
  • Select the Form and click on "Continue".

Fill in the Properties of the Reference field by providing:

  • Label: type the question for which the user will select an option
  • Description: optionally provide a description
  • Code: optionally provide a code

In the Settings check the boxes you want to apply for the field.

  • Click on "Done" to add the field.
  • The Reference field has been added to the Form.
  • When you finish adding fields, click on "Save" to save the Form.
  • While adding Records, users will be able to select a Record out of the list of Records of the referenced Form.

Note that in this example, the referenced field was a Single Selection field, defined as a Key field. That is why users were able to see the specific options in the dropdown list.

How to add a Reference field to reference many fields of another Form (cascading effect)
  • Before adding a Reference field, make sure you have defined as Key fields the fields you want your Form to refer to.
  • Navigate to your Form, and in the Form Design page, click on "Reference" to select it from the Fields palette.

Make sure you have defined as Keys the fields you want your Form to refer to.

  • Search for the Database and the Form that contains the Form and the Records you want to link to. Click on the arrows to reveal the contents of each Database.
  • Select the Form and click on "Continue".

Fill in the Properties of the Reference field by providing:

  • Label: type the question for which the user will select an option
  • Description: optionally provide a description
  • Code: optionally provide a code

In the Settings check the boxes you want to apply for the field.

  • Click on "Done" to add the field.
  • The Reference field has been added to the Form.
  • When you finish adding fields, click on "Save" to save the Form.
  • While adding Records, users will be able to select a Record out of the list of Records of the referenced Form.

Note that in this example, the referenced fields were:

  • a Reference field (referencing the Provinces available in the Geodatabase)
  • a Text field
  • a Single Selection field

and were ALL defined as Key fields in the referenced Form.

That is why users were able to see the specific options in the dropdown list.