Single-Line Text Field
This element is used to store single line text.
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.
This Field is used to store numerals. The range of numbers for storing is from -1E+100 to +1E+100
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.
These fields are used for storing date and time.
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:
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?
This field is used for simple multiline text.
The flag can take two values: 1 and empty.
The multiselect field allows you to select several values from the list:
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.
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.
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, "http://www.google.com" or "http://www.some-company-site.com").
Copyright (C) 2001-2010 Binary Brilliant Inc. All Rights Reserved.