XLS Forms Functions

There are additional functions in the XLS Form that can determine aspects such as; how the information in the form is presented, form logic, calculations, constraints etc.

Hints

If you want to add an instruction or hint in a form to guide the user in answering the question you can use the “hint” column. In the example below, the hint provides more information about what is required by the user.

Skip logic

It is possible to skip a group of questions based on the result of the selection made by the user from a select one question, by using a function (in the case the “relevant” function). In the example below, the result of the selection is tested and the group of questions only processed if the result is true.

If the user selects “culvert” on the question “What type of structure”, the “bridge” group is skipped.

Required

The “required‟ column is used to restrict the user from moving to next question if he/she tries to skip any question. If required is set to “yes”, the user will be unable to move on to the next question or submit the form without entering an answer for that question.

Appearance

The “appearance” column allows you to change the appearance of questions in the form. The following table lists the possible appearance attributes and how the question appears in the form.

Appearance attribute	Question type	Description
Minimal	select_one, select_multiple	Answer choices appear in a pull-down menu.
field-list	Groups	Entire group of questions appear on one screen (for mobile clients only).