This is an old revision of the document!


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.

  • Last modified: 7 years ago
  • (external edit)