This is an old revision of the document!
Field types and field properties
LIME supports the following field types. There are two types of different fields to choose between in the right panel: templated fields and Untemplated raw fields.
- Templated fields = fields that have predefined settings e.g. Date-fields
- Untemplated raw fields = fields without any predefined settings. You create your own fields based on what type of field you would like to add. E.g. Option field, add your own options.
A field can also have subtypes, for example an Integer field has standard, graded and unformatted types.
NOTE! If there are fields that you find in LISA but not in the manual - keep calm, dont worry and dont mind, these are not frequently used.
Templated fields
| Field type | Type |
|---|---|
Percent | Field with a bar for you to set percent between 1-100 % |
Grade | Row 1 Col 3 |
Smiley | Row 1 Col 3 |
Integer Nullable | Row 1 Col 3 |
Homepage | Row 1 Col 3 |
Company Classification | Row 1 Col 3 |
Industry | Row 1 Col 3 |
Company matrix classification | Row 1 Col 3 |
Nordic Countries | Row 1 Col 3 |
Mailings | Row 1 Col 3 |
Customer number | Row 1 Col 3 |
Date | Row 1 Col 3 |
Date and time | Row 1 Col 3 |
Month | Row 1 Col 3 |
Quarter | Row 1 Col 3 |
Time | Row 1 Col 3 |
Timestamp | Row 1 Col 3 |
Week | Row 1 Col 3 |
Year | Row 1 Col 3 |
Map Field | Row 1 Col 3 |
Untemplated raw fields
| Field type | Description |
|---|---|
Decimal | Fields formatted for either a percentage or a decimal currency |
Procent | The value is shown as a “termometer” 0-100 %. If list items are added on the field, you can get levels with a color association with it. The options are displayed as a list of selectable options when clicking on the field |
File | A field that stores files in the database. Used as a rule in the document table to save the document itself. Other fields in the document table saves the metadata about the document (such as who created it, corporate relations, etc). To view an image in the field, set the type attribute to the image. If an image is not selected then a default icon will be shown. Through the field in LIME it is possible to add, delete, copy and save an image. |
Formatted text | A string formatted for either fax, phone, history, cell phone or ZIP code |
HTML | A HTML field creates a small browser inside of a card. The easiest way to determine which URL to be opened, is to set the URL-attribute. If this is set to “http://www.lundalogik.se”, then Lundalogiks website will be shown in the field. Is is also possible to download information from the existing card and paste this into the URL, eg “http://www.visaforetagsinfo/index.asp?vatno=[company].[orgno]”. If it takes more advanced conditions than that to get the URL the SQL-attribute can be used like on any other field, ie to write a SQL statement that returns the URL that the existing record will show. HTML field do not store any information in the database. To hide the border around HTML field, put the CSS-attribute border for body to value 0. This field can be set to two different types: 1. Field and 2. Tab |
Integer | Only integers and they are formatted in thousands, “100 000” |
Link | Field for E-mail or homepage as clickable links. The type “LIME” of this kind of field is a link to another post in the LIME database |
Option | Field wíth a list of alternatives, one choice possible. Possibility to add a color to each option |
Relation | Create relations between two tables eg. Company and Person. The relation can be set as a field or as a tab on the card. If a tab is used for a relation, several records can be saved, for example a company could have several contactpersons which means that the relation type would be a tab on the company card. If a contactperson only can be linked to one company, the relation type would be a field on the person card |
Set | A field with a list of options, one or more choices possible. It is also possible to set a color associated with each option |
SQL | This field is replaced by a normal textfield with a SQL-expression and should not be used. But is is a field where you can connect a SQL statement that is executed when you open a post. The result shown in the field is always based on data in other fields, and the result is never stored in database. For example, a field that displays the sum of two other fields |
Text | A normal textfield. It is a possible to add options on a textfield |
Time | Pick a date, showed in “2014-12-12” |
XML | A field that is stored as XML in databases, but lack interface on the client. However, it is available for example via VBA and integrations. Value and text both return XML expressions of the node, while valueXML returns a XML node. The characteristics of this type is that it has one and only one top node. <items> <item>Stockholm</item> <item>Göteborg</item> <item>Malmö</item></items> |
Yes/No | A tickbox, if the box is checked it is interpreted as a “yes” |
Separator | A separator separates fields so they can be divided into different sections on a form |
Virtual Relation | Row 1 Col 3 |
Field properties
There are many field properties that can be set for a field and what properties a specific field have depends on it´s field type. To set properties on a field, click the field choose “Properties” on the panel to the right.
Common
| Name | Description |
|---|---|
Field label | is used to describe what the field is used for especially in a integration manner. To know if a field contains a address or a phone number for example |
Invisible | indicates wether a field should be invisible in Lime. There are some options to choose between |
Length | indicates how long a string can be to be saved in a text field. This feature has nothing to do with how big the field is on the form |
Required | indicates whether a field should be mandatory or not |
Tooltip | when holding the cursor across the field, you will se a brief explanation of the field |
Other
| Name | Description |
|---|---|
Active directory Label | Samma label egentligen men synkar med info som finns i ad:et. TGÄller endast på medarbetarkort |
Category | i ett textfält (redigerbar alternativlista) måste man lägga in det därifårn |
Comment | a comment for the field |
Default Value | default value when new entries are created, this value is directly added into the database |
Default Value (interpreted by Lime Pro) | default value when new entries are created in LIME. This property makes it possible to set a default value on a relation field such as a logged in user. The value of the property is a VB-expression for exmaple Activeuser. Record.ID |
Format SQL-expression | kan gå segt med denna funktion. För att optimera prestanda bör man stänga av denna funktion. Rättar till format på exempelvis datumfält om det står fel i databasen, så vill man ha tid exempelvis också så kan LIME fixa detta |
Name | The database name of the field. This name is used when you develop customizations in VBA for example |
NULL is permitted | indicated whether the value NULL is allowed for the field |
Option Query | have a possibility to control what to be showed in a textfield or relationfield (options). For example as a default value show all persons that works on a company and works as sales reps |
Private Comment | is used for documentation when developing a customization. For example to note that a field should not be deleted or changed because it is used in an integration |
Read only (Only in LIME Pro Client) | Specifies that a field is read-only in LIME Pro (only on a form) |
Required for editing (in LIME Pro Client) | a comment for the field |
| Sequrity Policy | specifies the security policy the field will be linked to. Read more about Security Policy |
Timestamp | Timestamp of when the field was last changed |
Validation rule (Only in LIME PRO Client) | Specifies a VB-expression that is used to validate a fields value when post is saved. If the result is True the post can be saved, otherwise not. Example: Used for VAT number fields, to validate if it is been typed in correct (xxxxxx-xxxx) |
Validation text (Only in LIME Pro) | If a field has a validation rule and not accepts the value when the record is saved, the lime client will show a messagebox with the text from this feature |
SQL
| Name | Description |
|---|---|
SQL Expression | properties for SQL-fields. Read more about SQL and Automatic fields |
SQL for new | properties for automatic fields. Read more about SQL and Automatic fields |
SQL for update | properties for automatic fields. Read more about SQL and Automatic fields |
Visuals
The properties for the fields under this section (display name, field order, height, width, width properties) are adjusted automatically when designing the fields on the form. Therefore you don't have to mind about them.