Boolean Field

This field is designed to store a value of 1 or 0. Textual terms are displayed to users on the add and update record forms.  Whichever term is selected determines which numerical value is entered (i.e. 1 or 0).  The default terms used are "Yes" and "No" however these can be modified.

When configuring boolean fields, it is important to consider both the common and field specific properties that are available for use. The field specific properties are defined below.

Note: All field types  have common field properties which are described separately.

Field Specific Properties

This set of properties is used specifically for configuring boolean fields.

Default Value

Select how this field will be initialized when the add record form is presented to a user. Select from Neither option is pre-selected, "Yes" option initially selected or "No" option initially selected.

Language

The language drop-down menu only appears if multilingual support has been enabled for the site. It is used in conjunction with the "Yes" Label and "No" Label. Select a language from the drop-down menu and complete the fields. The text entered for the fields will appear in the database tool when the respective community display language has been selected. Select another language and complete the fields if multilingual support is desired.

Note:  If the fields are completed in only one language, the text entered will be displayed for each language the community supports.

"Yes" Label

Enter a label to be shown for the positive Yes option. For example: "Paid" or "Approved".

"Yes" Value

Enter the value to be exported when the field is set to Yes value. For example: "1" or "Y".

"No" Label

Enter a label to be shown for the negative No option. For example: "Not yet paid" or "Not yet approved".

"No" Value

Enter the value to be exported when the field is set to No value. For example: "0" or "N".