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 on the field you would like to set a property for and 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 Matches labes used in Windows AD, if this is set on a coworker card, the info will be overwritten by the AD sync.
Category The available options. Can be used to add pre-defined selections to a text field
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 This should not be used, it will decrease performance! This can be used to format input data, ie. when user addes a date of 2019-01-01 the expression can add the current time to that date input as well.
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 CRM Desktop Client) Specifies that a field is read-only in Lime CRM (only on a form)
Required for editing (in Lime CRM Desktop 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 CRM Desktop 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 CRM Desktop CLient) 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. Runs whenever the object is refreshed/shown. Does not work in webclient and does not save any value to the database and is thereby not possible to use in Lime BI. Read more about SQL and Automatic fields: SQL properties
SQL for new properties for automatic fields. Runs when card is being created. Can not catch any data and can only do calculations with hardcoded numbers. Does not work in webclient. Read more about SQL and Automatic fields: SQL properties
SQL for update properties for automatic fields. Runs when the card is being saved/created. Works in webclient. Read more about SQL and Automatic fields: SQL properties

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.