Text Data Types
Small Text
Saves up to 255 characters of a single line of text. You may use this data type to save titles, names, short descriptions, web links, emails or phone numbers.
Long Text
Saves up to 256 KB characters of multi line text, You may use this type to save long descriptions or notes where the text may longer than the limit of a small text area
or must be displayed in multiple lines. You are recommended to prefere "small text" data type unless you plan to enter text longer than 255 chars.
Avoid creating a text field for saving only numerical values else they will not be sorted correctly in tabular views.
You may select "integer" or "decimal" data type to save numerics.
General Properties
Some features given below are only available for small text fields.
Default Value: Sets the default value inserted automatically whenever you start creating a new record.
Text Alignment: Sets the horizontal alignment of the text content.
Duplicate Data: Select whether two distinct records of this catalog may have the same data in this field.
If you disallow duplicates, SpeedBase will show a warning message and refuse to save the current record if duplicates are found.
If you select "Allow w. Warning" instead, a duplicate warning icon will be displayed but the user will still be allowed to save the record.
Force Case: If a case rule is selected, SpeedBase will automatically change the case of letters when the user
saves the record.
Required: If checked, the user will be required to enter data to this field before the record can be saved.
Text Format
Numeric/Phone: This option allows you to define a fixed display format to show phone numbers.
Fill in the "Mask String" box to determine the places of each number.
Example: If you enter the mask string as "(###) ### ## ##", the phone numbers will be displayed like "(123) 456 78 90"
First Name/Last Name/Full Name: This option helps you to automatically update a hidden "Full Name" field when data is saved
to "First Name" and "Last Name" fields and vice versa. To make it work, create all three types of fields and mark each of them with
one of these options. Beware that you must put on to the record form either only "First Name" and "Last Name" fields, or just the "Full Name"
field. The remaining field(s) will be hidden but you will be able to show them on views, use them for sorting or searching.
Emails & Web links: Select "E-mail" or "Web Link" from "Text Filter" selection box. Data saved on this field will then
be displayed as a clickable hyperlink.
Advanced Properties
Encrypt Data: If checked, data entered into this field will be encrypted.
You must have enabled the encryption feature from preferences window before you can activate it on field properties window.
Encryption setting can only be determined during creation of a new field. Once the field was created, this setting cannot be changed.
If you want to turn on encryption for an existing field, the recommended way to do it is:
- Enable encryption from preferences window if you didn't do it already.
- Export all data on that field for all records to file.
- Create another copy of that field and make sure to activate the encryption option.
- Import the previously exported data to the new field.
- Delete the older version of the field.
For multiuser licenses, if you want to make sure to remove all traces of un-encrypted version of data:
- Execute "optimize/repair" database from the "maintenance" tab of the connection window.
- Move all backup copies of your database to a more secure location as they still contain the unencrypted version of the data.
If you want to turn off encryption for an existing field, create an unencrypted version of the field and then follow the same
export/import steps given above.
Create Index: Creating an index may improve performance for accessing/searching records but also may slow down creating/importing/deleting records.
Not available for long text fields. You are recommended to leave this box as it is unless you are a database specialist.