Differences

This shows you the differences between two versions of the page.

--- configuration:lisanew:fieldproperties [2016-03-08 12:45]
Martin Berg Page moved from relnotes:releases:configuration:lisanew:fieldproperties to configuration:lisanew:fieldproperties
+++ — (current)
@@ Line 1: / Line 1: @@
-====== 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''    | 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.