Field Types

In the following form “field type” you can see all possible data types of Limbas.

Standard field types

field type	Example	Explanation
Number	2323	number without decimal places, can be positive or negative.
Number with decimal places	12.12	number with decimal places. There is no rounding. The number of digits before and after the dot are defined per field by the admin.
Floating point numbers	3434.34345034	Point with database-dependent precision and size.
Percent	12,55 %	Same as decimal. A percent sign is also shown on the display.
Text	LIMBAS is GPL	One-line text with a maximum of 250 characters. The representation takes place as a text line. The input of further characters is blocked. Length is specified.
Text block	LIMBAS is a web based, royalty free open source software. The main focus of LIMBAS are individual buisness solutions and specialized procedures.	Text block with up to 2000 characters. The presentation takes place as a text block. The line break consists of 2 characters. Warning more than 2000 entered characters will be cut without warning.
Long	The benefits of LIMBAS areS * Open Source * royalty free * central and independent database	Text block with any number of characters Text can be formatted by selecting the WYSIWYG option in the table settings. The tagging option affects the list view when searching for text contained in the table field: Unlimited otherwise like text block.
Long Indexed	You want to contribute to the project? There are many ways to participate: * Documentation * Translate the documentation	With formatting support, that means characters such as ‘bold’, ‘italic’, “underlined ” oder “left justified”…. are available
Date	15.12.2011	Date field displayed in the form dd.mm.yyyy Double click on an empty field – the current date will be applied.
date_time	15.12.2011 14:50	Date field and time dd.mm.yyyy hh.mm Double click on the current field – current date and time will be applied.
Time	14:22:35	Time specification Double click on the current field – current time will be applied.
YesNo		Accept or decline offered value / content.

Special field types

field type	Example	Explanation
created by	Adminus	Record was created by “username” (filled by the system, can not be edited manually)
created on	30.11.2011 16:13:58	Record was created on “current date / time” (filled by the system, can not be edited manually)
changed by	Adminus	Record was last changes by “username” (filled by the system, can not be edited manually)
changed on	30.11.2011 19:13:58	Record was last changed on “current date / time” (filled by the system, can not be edited manually)
Mimetype	application/zip	In der Liste vorhandene Dateitypen (WIKI MIMETYPE LINK). Der Internet Media Type besteht aus zwei Teilen: der Angabe eines Medientyps und der Angabe eines Subtyps. Beide Angaben werden durch einen Schrägstrich voneinander getrennt. Example: image/jpg.
File size	0.00 B	Unit field, input as byte (integer). The system displays the value depending on size to Byte, KB, MB…. Beispiel: Input value: 4800 Presentation: 4.69 KB Input value: 5700000 Presentation: 5.44 MB
Phone number	+49 89 123456	If a VOIP is installed, this phone number can be selected.
Homepage	URL: www.limas.org absolute URL: http://www.LIMBAS.com	Through a single mouse click on the arrow in the edit and detail view the URL opens, as long as it’s valid. If no absoulte URL is entered, LIMBAS tries to open the URL relativ to the currently displayed one in the browser.
Email	service@limbas.org	By simply clicking on the arrow next to it, the user’s e-mail client opens to write an e-mail to the entered address.
Currency	50 €	Default currency is automatically added. Example: Eingabewert 50 Darstellung 50 EUR
Selection (select)		A value can be selected. Selection is made via the opened selection list or via the selection window.
Selection (radio)		Selection by clicking a ‘Radiobutton’. Only one value can be selected.
Selection (checkbox)		Selection by clicking a square ‘checkbox’. Multible values can be selected.
Selection (multiple)		In the edit view, the entries are displayed in a select list, the selected entries are highlighted with a different background color. In the detail view, the selected entries are listed as text one below the other and in the list view the number of selected entries is shown with the possibility to expand a list of these entries. Several values can be selected.
Selection (ajax) Countries		In the field by entering a search string and ENTER. Select the desired values. Warning this selection will only be applied when the record is saved. Meaning of the colors of the selected range of values Selection green = not saved yet Selectiond deleted red = not saved / deleted yet selected values are displayed below the input field and can be deleted by double-clicking (displayed in red before saving)
Attribute		Consideration of the field types Number, Text, Date. Here you can search for specific field values. Specification of individual values: Date field Born on: 12.2.1955 Text field Place of residence: Munich
Slogan		Specification of tree structures in the selection window. Example: LIMAS DOC User Documentation Admin Documentation Interface Documentation SOAP WEBDAV Selection can be done at any level.
SQL Argument	4646	…
PHP Argument	1 & Limbas is GPL	Content can be overwritten if necessary. Set to default by deleting and accepting.

INPUT Options

Selection details, right arrow next to the input field
– Hover over the arrow for info text (like ‘Open Quick Calendar’)
– Click on the arrow and depending on the field type

Quick Calendar

Choose date:
– choose year – Select from drop-down list
– choose month – Select from drop down list or scroll ‹ or ›
– choose day – click on day number

Choose time:
Use the slider to adjust hour, minute and second.
For current date and time click on the TODAY button.

The Quick Calendar can be moved within the workspace. Click, the text ‘Move’ appears in the footer of the calendar. Keep mouse button pressed and move to desired location.

Text field

A new window with a text editor opens. Text can be edited, formatted and saved.

Selection Window

The selection window displays all the possible values for this specific input field. In LIMBAS, these values are defined in Pools. For each Pool one or more default values can be defined and they will be used, when a new data record is created. Values can be added, or deleted, new Pools can be created.
The Pool that is relevant for a data filed is specified in the table settings. ([admin]->[Table] in Field ‘option’).

Values can be added, or deleted, new Pools can be created.
Add a new value
input the new value and if required additional information
Change a value, overwrite the existing value
Delete a value, click on the trash icon
Select, click on one or more values
Thus the change of selection will be displayed
in the detail view, you must click the details in order to adopt it
Change the order of the values
A value can be moved one place up or down.
Click on the relevant arrow (up or down) next to the value

As an example you can see the form for the address.

Voice Recognition

Before the voice recognition:

During the voice recognition:

If speech recognition is enabled by an administrator and the browser supports it, a microphone button appears in the text box. Pressing on this will start speech recognition and insert spoken text into the text box.