Appearance
Configure Field Properties
Field properties are how you configure the various behaviour and appearance of a specific field for an Entity Type.
Edit Field Definition dialog box
"Display Name" field - Used to modify the Display Name which is the text label used for this field whenever the field appears on the Create, View, and Edit pages for this Entity Type.
"Default Value" field - Used to specify the Default Value for this field when a new instance of this Entity Type is being created. When the field is configured to appear on the Entity Type's Create Page, the user has the opportunity of changing this value before creation occurs.
"Editor Widget" dropdown selector - Used to specify which user interface editor widget is used for this field on the Create, Edit, and/or View pages of this Data Type. NOTE: The list of available editor widgets is based on the "DB Column Type" or "DataSpeeder Field Type" values which are based on the database schema.
"Options for Drop Down Selector" - When the "Editor Widget" option is set to "Drop Down Selector", this value is used to specify which list of options (aka an "Options List") will appear in that list. To create and configure new "Options Lists", see Create & Edit Option Lists.
"Field is a Primary Key (PK) in DB" checkbox - Used to indicate whether this field is a Primary Key or in the DB and can be used to uniquely indentify an individual record of this Entity Type in the database table.
"Value is auto-incremented by DB" checkbox - Used to indicate whether the database is configured such that this value will be auto-incremented by the DB.
"Consider field to be a Unique ID" checkbox - Used to specify whether or not DataSpeeder will treat this field as a Unique Identifier that can be used to uniquely indentify an individual record of this Entity Type in the database table.
"Unique ID value generation method ..." dropdown selector - When DataSpeeder needs to generate a unique identifier value for this field during entity creation, the selection determines how the unique value is generated. Options include:
- "App used next highest ID value" - DataSpeeder will rely on the database itself to auto-generate/auto-increment a unique value.
- "Value is specified by User in UI" - DataSpeeder will rely on the user to enter a unique value for this field on the Create page.
"Is Visible On Create Page" checkbox - Used to specify whether or not this field is visible on the Create page for this Data Type.
"Is Editable On Create Page" checkbox - Used to specify whether or not this field is editable (or disabled and read-only) on the Create page for this Data Type.
"Is Visible On Edit Page" checkbox - Used to specify whether or not this field is visible on the Edit page for this Data Type.
"Is Editable On Edit Page" checkbox - Used to specify whether or not this field is editable (or disabled and read-only) on the Edit page for this Data Type.
"Is Visible On View Page" checkbox - Used to specify whether or not this field is visible on the View page for this Data Type.
"Is A Searchable Field" checkbox - Used to specify if the field is Searchable and will be included when performing a search of that Data Type. When a search is Searchable, matching results from a search will appear in the search results table for that Data Type.
"Column is visible in main table" checkbox - Used to specify whether or not this field appears as a column in the search results table for that Data Type.
"Column is sortable in main table" checkbox - Used to specify whether or not this field can be used to alpha-numerically sort data in the search results table. NOTE: The "Column is visible in the main table" value must be checked for this value to apply.
"DB Field Name" field - Indicates the name of the associated table field in the database for this Field Definition.
"DB Data Type" field - Indicates the type of data of the associated table field in the database schema.
"Data Category" field - The DataSpeeder data category that was determined as the best match for the DB Data Type from the database schema.
"Close" button - Clicking the button cancels the saving of changes, and closes the dialog box.
"Save Changes" button - Clicking the button saves the values in the dialog box.
How To Video
This video includes a quick intro to setting field properties.