Click "Database" from main menu, click "Catalogs".
Select the catalog you wish to create fields for, click "Fields" button.
(Double clicking a catalog name also opens fields window)
Creating New Fields
Click "Create New" button to open Create Field Wizard.
Field Name: Type the name of the field into the box. For example, if you are creating fields for "People" catalog,
you may wish to create fields like "Name Surname", "E-Mail", "Phone" etc. Field names can be changed later if needed.
Data Type: SpeedBase supports different types of fields depending on what type information is to be stored.
This should be selected with care as you cannot change the data type of an existing field later.
Available data types are as follows:
Stores up to 255 characters of text.
Stores up to 8000 characters of text, used to store descriptions or notes where the text
may longer than the limit of a small text area. Do not prefere long text unless you need space more than 255 chars.
Stores positive or negative integer numbers that do not exceed approx. 2 billion.
Stores decimal numbers having up to 16 digits on left and up to 8 digits on right side of the decimal point.
Automatically calculates the associated math expression and displays the result in real time. It can apply
various aritmetical operations using the current values saved on other fields.
Example: Assume that you have a decimal field for saving price information. A computed field can
display the tax value calculated from the tax rate and entered price.
See Computed Fields for detailed info about
the syntax of the expressions and examples.
Stores date information in one of the three available formats. If you also activate reminder feature,
SpeedBase automatically creates a reminder in the background whenever a date is entered into this field of a record.
Stores time information in hh:mm format.
Stores date and time information in one of the three available formats. If you also activate reminder feature,
SpeedBase automatically creates a reminder in the background whenever a date-time info is entered into this field of a record.
Stores status information with two options only (like yes/no, exists/empty etc.) Fields with this data
type are represented as check boxes.
Stores property information to select from multiple choices (like colors, sizes etc.). Fields with
this data type are represented as a drop down list box. You are allowed to rename, remove or insert new options in a later time.
Tips: Only one choice can be selected in this field when creating a record. If you need to check multiple options
at the same time, consider creating either multiple checkboxes or a Multi to N Relationship
with a catalog which contains the options as its records.
System User: Stores owner of the current record. Available in a multiuser environment (Teamwork Edition) only.
Fields with this data type are represented as a drop down list box containing SpeedBase user names as its items.
Storing ownership information with records allows you to grant extended rights to record owners.
See Applying Owner Rights for more info.
See Creating Relationships for detailed info about relationships.
Fields with this data type are represented either as a drop down list box or a
record list window
File / Image: Stores file or image data. By default, this field displays the file name as a linked text on the record form.
You may check "display as image" if you plan to store image files. This will show the image on the record form instead of file name.
(jpg, png, gif, bmp are supported)
See File & Image Fields for more info.
Default Value: Sets the default value inserted automatically whenever you open the record form to create a new record.
Allow Duplicate: Select whether two distinct records of this catalog may store the same data in this field. If you disallow
duplicates, SpeedBase will show a warning and refuse to save create/update a record if duplicates are found.
Text Filter: Select the appropriate value here. This helps SpeedBase to display and handle the information optimally.
Displaying New Fields In Record Forms
A newly created field will not automatically appear on record details window!
You should add the new field into the record form by using "Form Designer".
See Designing Data Forms to read how to do it.
Panel View (Advanced Usage)
This button is available and effective only if you have placed a field of type 1-N relationship (related record list) into the form
by using form designer.
It allows you to create and customize the view of this record list.