...
Note that fields that have this option unchecked is cleared and do not appear on generated form templates.
...
If the Indexed attribute is checkedselected, this field may be indexed through SQL Server for record searching. This allows better searching performance if this field is used as one of the major search criteria. A non-clustered index is created for each field for which this attribute is selected.
...
| Note |
|---|
This field does not apply to members of the Administrators group. Administrators can search on all fields using all operators, regardless of how this field is configured. |
Allow Sorting
When checkedselected, a user can sort view and find results by this field. When uncheckedcleared, a user cannot sort records using this field. Note that this field does not apply to members of the Administrators group; administrators can sort records based on this field even if this option is unchecked cleared (assuming that SQL Server supports sorting by that field's data type).
...
Note that when Is Validated is uncheckednot selected, no other option appears on this tab.
...
A Virtual Field tab appears on the Fields form when the In Table option is uncheckedcleared. This tab allows the administrator to define how the virtual field is derived from the database.
...