Brilliant Database Software - Home
Database software - Online Help System

Online Help System

Back to Brilliant Database Web-Site | Write to Support | Help Index

Basic Fields

table border="0" width="100%" cellspacing="0" cellpadding="4" bgcolor="#00000077">
Single-line text field

Single-Line Text Field

This element is used to store single line text.

Individual Properties

  • Mask - this property allows you to specify the format of entered text. For example, if you specify the "###-XX" mask, the user will have to enter three digits, then a dash and two letters: 123-GH, 645-AB and so on. Special characters for specifying the mask:
    • # - defines any digit (1234567890)
    • X - defines any letter (ABCDEF...)
    • ? - defines any character

Password Field

This field is used to store single line text, all characters are shown as "*" characters.

Note: At viewing field values in the table, the values will be displayed as is. Therefore, it is recommended to mark these fields as "system" (on the Edit and Visibility tab) so that the user cannot select it for viewing in the table.

Numerical Field

This Field is used to store numerals. The range of numbers for storing is from -1E+100 to +1E+100

Individual Properties

Mathematical Field

This field is intended for accomplishing calculations for database fields. For example, if the form has the "Price" and "Quantity" fields, you can create a mathematical field "Total" and specify the following formula for it:[Total]=[Price]*[Quantity]. [Total]=[Price]*[Quantity]. The formula is set with the help of Formula editor.

Individual Properties

  • Format - format for displaying calculations. For example, number 1200.5 can be displayed as "1'200,5" or "$1 200.50". Learn more about the numbers formatting...,
  • Type - defines how to store a formula:
    • Static - specified formula is stores in the form properties and is used for all records. That is, all records created with this form will use the same formula, and if the formula is changed, the changes will be reflected in already created records. This type of storing formulas does not extend the database size and is optimal for the speed of values calculation.
    • Dynamic - formula can be specified separately for every record. The formula is stored in the record itself and can be changed at work with the database. The formula that is specified in the Form editor, will be used only for newly created records. This type of storing formulas extends the database size when a new record is added, even if all formulas are the same.
  • Formula - formula for calculating itself. The formula is specified with the help of the Formula editor.

Date/Time Fields

These fields are used for storing date and time.

Individual Properties

  • Format - format for displaying field values. Learn more about formatting dates and time...
  • Initialize the field with the current system date/time - if this check box is selected, at creation of a new record, the current date and time will be recorded into this field.

Drop-down list (combobox)

A drop-down list allows you to select one value from the list:

There are 3 types of drop-down lists.

Simple drop-down list

Allows to select a value from a simple pre-entered list of values.

List based on other list

Allows to select a value from a list based on the selected value of other list. For example if a form has a "Country" list, you can create a "City" list based on the "Country" list and enter a list of cities for each country.

You can enter separate lists for each value or one big list. In this case you should enter it in the following format:

   New York

Colons are used to specify values from the parent list.

List based on records

In this case a list of values is generated on records from a specified folder or a query. You can also use a simple-relational field to solve this task. However, there is a little difference in these methods. E.g. there are an "Item" and a "Location" forms. We want to be able to select a location for an Item from the list of locations in our database. We can use both a drop-down list or a simple relational field to solve this task. Lets image the name of one location is changed. What will we see on Item records that are using this location?

  • Drop-down list: The field will still show us the old value, because it stores a value, not a link to a record.
  • Relational field: The field will show us the new (actual) value, because it stores a link to a record, not a value.

Multiline Text

This field is used for simple multiline text.

Individual Properties

  • Max text length - limitation for the text length in characters
  • Spell Check - this menu allows you to enable spell checking for the entered text. To learn more, see the "Working with multiline text field" section.

Flag Field

The flag can take two values: 1 and empty.

Individual Properties

  • Flag at right - when selected, the label to the check box will be displayed on the right of the check box.

Multiselect Field

The multiselect field allows you to select several values from the list:

Individual Properties

  • List - list of possible values.

ID Field

At creation of a record, a number from the counter is entered into this field, and after that, the counter is incremented by 1. That is, we get records with values 1, 2, 3 and so on.

Individual Properties

  • Current ID - current value of the counter.

E-mail Field

This field is used to store e-mail addresses. The only difference from a simple text field is that when this field is clicked, the e-mail client will be opened, offering you to create an e-mail with the specified e-mail address.

Brilliant Database can create and send e-mails on its own. To learn more, see the Send/Export Templates section.

URL Field

This field is used to store URLs. The only difference from a simple text field is that when this field is clicked, the web page by the specified URL will be opened (for example, "" or "").

All topics in the "Basic Fields" section: