Skip to content

DataSplice Support Website

Sections
Personal tools
You are here: Home » Product Manuals DataSplice 2.3 » DataSplice 2.3 Admin Client Manual » Views - Fields Tab
 

Views - Fields Tab

The Fields tab contains parameters which determine the appearance and function of the DataSplice fields.

Fields Tab

Field Name The dropdown list contains all of the fields named in the SQL statement of the Data tab. These fields are also displayed in table format in the Data tab.
Field Information This display-only box indicates the selected field's data type, precision, and option flag settings.
Display Name Indicates the value to use as the column header display in the clients. This value can also be set on the Data tab in the Display Name column.
Default Value The default value will be automatically input into all new records created by DataSplice. This value can then be overridden by the user. If no default value is desired, this field should be left blank.
Format The optional Format field applies a format to the data in the field for display purposes, such as displaying a date with a uniform appearance. For more information, please refer to the Format Strings page in the reference section.
Invisible The Invisible checkbox designates the field as a non-display field. The field remains part of the view, but is not visible to users.
Readonly The Readonly checkbox renders the field uneditable.
Searchable The Searchable checkbox indicates whether or not a user can filter (search) the view on this field. While creating views for use with DataSplice, keep in mind that the first searchable field in the SQL statement of a view is the field used as the filter field in DataSplice.
Sortable The Sortable checkbox indicates whether or not a user can sort the view on this field.
Field Validation Setting up field validation supplies dropdown value lists for use during data entry, which helps to maintain data integrity.
  • None - The default setting of None removes dropdown list behavior.
  • List Type - The List Type field validation supplies the field with a static (fixed) dropdown value list.
  • View Type - The View Type field validation supplies the field with dynamic value selection. The actual value look-up is done using another DataSplice view.

Creating Field Validation

Field validation helps to minimize the frequency of data entry errors by limiting the possible entries for a field to a specific, pre-defined set of values. The user then only has to choose one of these values, rather than type it by hand. This increases efficiency and data integrity.

Validation Using a List

The following describes the process of using a list to validate a field.

Edit List Validation To create field validation from a list:

  1. Select the List entry in the Field Validation dropdown box.
  2. Click the Edit button.
  3. The Edit List Validation dialog box will open.
  4. In the Edit List Validation dialog box, add entries to the list by typing the values into the Text Entry box in the upper left corner and clicking the Add button.
  5. Click the OK button when finished adding entries to the list.
  6. The list entries will appear to the user in the same order in which they are added.
  7. Select the Restrict Entry to List checkbox to prevent the user from typing data into the field and forcing them to select a value from the list provided.

The static list can display additional information to the right of the list of values. To create a two column list, separate the value from the additional information with the pipe character:

Example: 1 | 1st Value

Both sides of the pipe will be displayed in the dropdown, but only the left side of the pipe will be inserted into the field.

Validation Using a View

The following describes the process of using another view to validate a field.

Edit View Validation To create field validation from a view:

  1. Select the View entry in the Field Validation dropdown box.
  2. Click the Edit button.
  3. The Edit View Validation dialog box will open.
  4. In the Edit View Validation dialog box, do the following:
    • Specify which view to use for looking up data values by selecting the view from the Target View dropdown box.
    • Specify which field, from the target view, should be used as the value for data entry by selecting the field name from the Value Field dropdown box.
    • Select which Display Type option to use for this field validation:
      1. Dropdown - Use a standard dropdown list for value selection.
      2. Grid - Use a pop-up dialog for value selection. The pop-up window allows users to alter the default view filtering, in addition to paging through the possible values.
    • Use the Available Offline checkbox to specify whether or not the clients should cache this value list data offline.
    • On the Filters tab, specify the filter criteria to use for retrieving the initial set of values.
    • Select the Restrict to List checkbox if you want to prevent the user from typing data into the field and force them to select a value from the dropdown list or pop-up list provided.
  5. Click the OK button when finished.

Contents
 

Created by root
Last modified 2005-03-08 09:45 AM
 
Powered by Plone

This site conforms to the following standards: