Feedback Print

Fields

In the application menu: Fields, only the fields that were selected within the option “select fields” will be available for the advanced settings.

Application fields list Application fields list

According to the selected field, different attributes can be changed depending on the data type selected, that is only for application level, not for the database.

Text

General Settings

Text field Configuration Interface. Text field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as a text, it accepts letters, numbers and special characters.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Case Settings : Convert the letter from the field when losing focus. The options are:
    • Upper case : All in Upper Case
    • Lower case : All in Lower case
    • Capitalize first word : Capitalizes the first letter of the first word
    • Capitalize all words : Capitalizes the first letter of all the the words
  • Show HTML content : Determines if the html contained in the field will be displayed or not. If enabled, the html will be displayed, otherwise the html will be interpreted by the browser.
  • Grid Mask : Defines the mask for the field display.There are two typed of masks described below:
Character Description
X Placeholder to any character. Replaced by any character. If number of characters entered are less then the mask size, the field value is completed with zeros (Filling full size field entry is required).
Z Replaced by any character retrieved from database. Suppress zeros at field left (Complete field filling is optional). When used combined with the mask character X it should be placed at the mask left.
   

Mask Examples

Mask Field Value Formatted Value
(xx) xxxx - xxxx 1234567890 (12) 3456 - 7890
(xx) xxxx - xxxx 12345678 (00) 1234 - 5678
(zz) xxxx - xxxx 1234567890 (12) 3456 - 7890
(zz) xxxx - xxxx 12345678 ( ) 1234 - 5678
(zz) xxxx - xxxx 0012345678 ( ) 1234 - 5678
  • Do Not Repeat Value : Do not repeat the value of the field in case it is the same as the previous record.

    Diaplying repeated values.

  • Run content in Javascript : If enabled, the javascript will be interpreted by the browser, otherwise the javascript will be displayed.
  • SQL Type : Informs the datatype of field in the database.

Lookup Settings

A method used to offer the user a list of values that can be selected in the form applications. For example, the gender field in the Database with the values M or W can be presented like Man or Women or in a dynamic way, having these values recovered from the database.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Lookup Methods

    You will have available two types of lookup methods: Manual (informing manually the conditions of the select) or Automatic (using a database query).

    Selecting the lookup type. Selecting the lookup type.

    • Lookup Method - Automatic

      Automatic Lookup Interface. Automatic Lookup Interface.

      • SQL Select Statement : Define the SQL command that will recover the values that will be displayed on the form field. The command needs to have the following structure SELECT display_field FROM table WHERE key_field = {grid_field}.

      The Grid field needs to be refrenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

      • Multiple Values : When enabled, allows to select more than one item from the list, separated by a delimitator.
      • Delimiter : Defines the character used to separate the values selected in the form. Only inform a value to this field if you need to separate the selected options with a different delimiter then (;).
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.
      • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.
    • Lookup Method - Manual

      This method is used so that the developer can create manually the list of values that will be saved to the generated application. This method is mostly used when the database does not have a table that contains this information.

      Manual Lookup Interface. Manual Lookup Interface.

      • Lookup Type : Define the functionality of the lookup, being: Single Value, Multiple Values (delimiter), Multiple Values (position) and Multiple Values (binary).
        • Single Value :

        It will be displayed only one value for the field. And it will replace the stored value from the table with the one defined on the item label.

        Manual Lookup Interface. Setting up Single Value Lookup

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
      • Múltiplos Valores (Delimitador) It can be displayed various values for the selected field. The values should be separated by a delimitador that will be informed. It is done a replacment on the parts of the field, separated by the delimitador, with the values contained in the list.

        Manual Lookup Interface. Setting up Multiple Values (delimiter).

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Delimiter Characters used to separate Multiple Values in the table field. If not informed, the default delimiter is a semi coma (;).
      • Multiple Values (position)

         Allows to store a diversity of information selected on the field in only one string. For this information to be added, you need to inform the label, initial position and the number of bytes that each information occupies on a string.
        
         For this example, Gender, Marital status and Hobby were used. Gender uses one byte as does the Martial Status, the Hobby will use two bytes.
        
         The example below:
        
         | Label     | Value    | Start     | Size      |
         |-----------|----------|-----------|-----------|
         | Man       | M        | 1         | 1         |
         | Women     | W        | 1         | 1         |
         | Divorced  | D        | 2         | 1         |
         | Single    | S        | 2         | 1         |
         | Study     | SD       | 3         | 2         |
         | Sports    | SP       | 3         | 2         |
         | Read      | RD       | 3         | 2         |
        
         Example: Of you choose __Man__, __Single__ and __Read__, no banco de dados seria armazenado o seguinte valor __MSRD__.
        

        Manual Lookup Interface. Setting up Multiple Values (position).

        • Label : Text that will be displayed in the Grid.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Start : Starting position of the string that is going to be stored. The first position is always 1.
        • Size : Amount of bytes that is going to occupy in the string.
      • Multiple Values (binary)

          Allows to store a diversity of information selected on the field in only one value.
        
          In this example uses the following list (although it is not informed when inserting values to the list, each item has a value applied automatically according to the order):
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          To store the data, it is done an internal sum of the decimal number. See the examples below.
        
          Example 1: If the options __Sports__ and __Culture__ were selected, the number stored in the table would be __3__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 2 (Culture) = __3__
        
          Example 2: If the options __Sports__, __Pleasure__ and __Reading__ were selected, the number stored in the table would be __13__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 4 (Pleasure) + 8 (Reading) = __13__
        

        Manual Lookup Interface. Setting up Multiple Values (Binary).

        • Label : Text that will be displayed in the Grid.
      • Insert Button : Adds to the list the values informed on the fields Label and Value.
      • Update Button : Modifies the attributes of the selected item.
      • Remove Button : Remove the selected item from the list.
      • Clear Button : Clear the Fields.
      • Save Button : Allows the user to save all the items of the list, to use on other fields, just click on Load lookup definition.
      • Load lookup definitions : Allows to refresh the list of values predefined when using the lookup. It will be listed the existing definitions in ScriptCase and the ones saved by the user.
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.

Multiple Lines Text

General Settings

Multiple Lines Text field Configuration Interface. Multiple Lines Text field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as a Multiple Lines Text, it accepts letters, numbers and special characters in multiple lines.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Case Settings : Convert the letter from the field when losing focus. The options are:
    • Upper case : All in Upper Case
    • Lower case : All in Lower case
    • Capitalize first word : Capitalizes the first letter of the first word
    • Capitalize all words : Capitalizes the first letter of all the the words
  • Show HTML content : Determines if the html contained in the field will be displayed or not. If enabled, the html will be displayed, otherwise the html will be interpreted by the browser.
  • Grid Mask : Defines the mask for the field display.There are two typed of masks described below:
Character Description
X Placeholder to any character. Replaced by any character. If number of characters entered are less then the mask size, the field value is completed with zeros (Filling full size field entry is required).
Z Replaced by any character retrieved from database. Suppress zeros at field left (Complete field filling is optional). When used combined with the mask character X it should be placed at the mask left.
   

Mask Examples

Mask Field Value Formatted Value
(xx) xxxx - xxxx 1234567890 (12) 3456 - 7890
(xx) xxxx - xxxx 12345678 (00) 1234 - 5678
(zz) xxxx - xxxx 1234567890 (12) 3456 - 7890
(zz) xxxx - xxxx 12345678 ( ) 1234 - 5678
(zz) xxxx - xxxx 0012345678 ( ) 1234 - 5678
  • Do Not Repeat Value : Do not repeat the value of the field in case it is the same as the previous record.

    Diaplying repeated values.

  • Run content in Javascript : If enabled, the javascript will be interpreted by the browser, otherwise the javascript will be displayed.
  • SQL Type : Informs the datatype of field in the database.

Lookup Settings

A method used to offer the user a list of values that can be selected in the form applications. For example, the gender field in the Database with the values M or W can be presented like Man or Women or in a dynamic way, having these values recovered from the database.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Lookup Methods

    You will have available two types of lookup methods: Manual (informing manually the conditions of the select) or Automatic (using a database query).

    Selecting the lookup type. Selecting the lookup type.

    • Lookup Method - Automatic

      Automatic Lookup Interface. Automatic Lookup Interface.

      • SQL Select Statement : Define the SQL command that will recover the values that will be displayed on the form field. The command needs to have the following structure SELECT display_field FROM table WHERE key_field = {grid_field}.

      The Grid field needs to be refrenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

      • Multiple Values : When enabled, allows to select more than one item from the list, separated by a delimitator.
      • Delimiter : Defines the character used to separate the values selected in the form. Only inform a value to this field if you need to separate the selected options with a different delimiter then (;).
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.
      • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.
    • Lookup Method - Manual

      This method is used so that the developer can create manually the list of values that will be saved to the generated application. This method is mostly used when the database does not have a table that contains this information.

      Manual Lookup Interface. Manual Lookup Interface.

      • Lookup Type : Define the functionality of the lookup, being: Single Value, Multiple Values (delimiter), Multiple Values (position) and Multiple Values (binary).
        • Single Value :

        It will be displayed only one value for the field. And it will replace the stored value from the table with the one defined on the item label.

        Manual Lookup Interface. Setting up Single Value Lookup

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
      • Múltiplos Valores (Delimitador) It can be displayed various values for the selected field. The values should be separated by a delimitador that will be informed. It is done a replacment on the parts of the field, separated by the delimitador, with the values contained in the list.

        Manual Lookup Interface. Setting up Multiple Values (delimiter).

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Delimiter Characters used to separate Multiple Values in the table field. If not informed, the default delimiter is a semi coma (;).
      • Multiple Values (position)

         Allows to store a diversity of information selected on the field in only one string. For this information to be added, you need to inform the label, initial position and the number of bytes that each information occupies on a string.
        
         For this example, Gender, Marital status and Hobby were used. Gender uses one byte as does the Martial Status, the Hobby will use two bytes.
        
         The example below:
        
         | Label     | Value    | Start     | Size      |
         |-----------|----------|-----------|-----------|
         | Man       | M        | 1         | 1         |
         | Women     | W        | 1         | 1         |
         | Divorced  | D        | 2         | 1         |
         | Single    | S        | 2         | 1         |
         | Study     | SD       | 3         | 2         |
         | Sports    | SP       | 3         | 2         |
         | Read      | RD       | 3         | 2         |
        
         Example: Of you choose __Man__, __Single__ and __Read__, no banco de dados seria armazenado o seguinte valor __MSRD__.
        

        Manual Lookup Interface. Setting up Multiple Values (position).

        • Label : Text that will be displayed in the Grid.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Start : Starting position of the string that is going to be stored. The first position is always 1.
        • Size : Amount of bytes that is going to occupy in the string.
      • Multiple Values (binary)

          Allows to store a diversity of information selected on the field in only one value.
        
          In this example uses the following list (although it is not informed when inserting values to the list, each item has a value applied automatically according to the order):
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          To store the data, it is done an internal sum of the decimal number. See the examples below.
        
          Example 1: If the options __Sports__ and __Culture__ were selected, the number stored in the table would be __3__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 2 (Culture) = __3__
        
          Example 2: If the options __Sports__, __Pleasure__ and __Reading__ were selected, the number stored in the table would be __13__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 4 (Pleasure) + 8 (Reading) = __13__
        

        Manual Lookup Interface. Setting up Multiple Values (Binary).

        • Label : Text that will be displayed in the Grid.
      • Insert Button : Adds to the list the values informed on the fields Label and Value.
      • Update Button : Modifies the attributes of the selected item.
      • Remove Button : Remove the selected item from the list.
      • Clear Button : Clear the Fields.
      • Save Button : Allows the user to save all the items of the list, to use on other fields, just click on Load lookup definition.
      • Load lookup definitions : Allows to refresh the list of values predefined when using the lookup. It will be listed the existing definitions in ScriptCase and the ones saved by the user.
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.

Integer

General Settings

Integer field Configuration Interface. Integer field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as a Integer, it is allowed to define the format of a number.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Accumulated : When enables, define that the field will be accumulated with the values of another field. This option is only available on virtual fields.
  • Accumulator field : Only available when the option “Accumulated” is enabled. This configuration defines which field will be used to accumulate the values. The chosen fields needs to be Integer, Currency or Decimal.
  • Grid Mask : Defines the mask for the field display.There are two typed of masks described below:
Character Description
X Placeholder to any character. Replaced by any character. If number of characters entered are less then the mask size, the field value is completed with zeros (Filling full size field entry is required).
Z Replaced by any character retrieved from database. Suppress zeros at field left (Complete field filling is optional). When used combined with the mask character X it should be placed at the mask left.
   

EMask Examples

Mask Field Value Formatted Value
(xx) xxxx - xxxx 1234567890 (12) 3456 - 7890
(xx) xxxx - xxxx 12345678 (00) 1234 - 5678
(zz) xxxx - xxxx 1234567890 (12) 3456 - 7890
(zz) xxxx - xxxx 12345678 ( ) 1234 - 5678
(zz) xxxx - xxxx 0012345678 ( ) 1234 - 5678
  • Do Not Repeat Value : Do not repeat the value of the field in case it is the same as the previous record.

    Diaplying repeated values.

  • SQL Type : Informs the datatype of field in the database.

Values format

Interface of Values Format Interface of Values Format

  • Regional Settings : Allows to apply the Regional Settings to format the number of the fields. When not enabled, you will view attributes grouped, Negative Symbol and negative number format.
  • Digit Grouping Separator : Defines the character that will be used to separate the thousand.
  • Negative sign : Defines the chatacter that will be used to display negative numbers.
  • Negative number format : Defines the position of the Negative sign related to the value.
  • Color of Negative : Defines a color for the field when the value is nagative.

Lookup Settings

A method used to offer the user a list of values that can be selected in the form applications. For example, the gender field in the Database with the values M or W can be presented like Man or Women or in a dynamic way, having these values recovered from the database.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Lookup Methods

    You will have available two types of lookup methods: Manual (informing manually the conditions of the select) or Automatic (using a database query).

    Selecting the lookup type. Selecting the lookup type.

    • Lookup Method - Automatic

      Automatic Lookup Interface. Automatic Lookup Interface.

      • SQL Select Statement : Define the SQL command that will recover the values that will be displayed on the form field. The command needs to have the following structure SELECT display_field FROM table WHERE key_field = {grid_field}.

      The Grid field needs to be refrenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

      • Multiple Values : When enabled, allows to select more than one item from the list, separated by a delimitator.
      • Delimiter : Defines the character used to separate the values selected in the form. Only inform a value to this field if you need to separate the selected options with a different delimiter then (;).
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.
      • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.
    • Lookup Method - Manual

      This method is used so that the developer can create manually the list of values that will be saved to the generated application. This method is mostly used when the database does not have a table that contains this information.

      Manual Lookup Interface. Manual Lookup Interface.

      • Lookup Type : Define the functionality of the lookup, being: Single Value, Multiple Values (delimiter), Multiple Values (position) and Multiple Values (binary).
        • Single Value :

        It will be displayed only one value for the field. And it will replace the stored value from the table with the one defined on the item label.

        Manual Lookup Interface. Setting up Single Value Lookup

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
      • Múltiplos Valores (Delimitador) It can be displayed various values for the selected field. The values should be separated by a delimitador that will be informed. It is done a replacment on the parts of the field, separated by the delimitador, with the values contained in the list.

        Manual Lookup Interface. Setting up Multiple Values (delimiter).

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Delimiter Characters used to separate Multiple Values in the table field. If not informed, the default delimiter is a semi coma (;).
      • Multiple Values (position)

         Allows to store a diversity of information selected on the field in only one string. For this information to be added, you need to inform the label, initial position and the number of bytes that each information occupies on a string.
        
         For this example, Gender, Marital status and Hobby were used. Gender uses one byte as does the Martial Status, the Hobby will use two bytes.
        
         The example below:
        
         | Label     | Value    | Start     | Size      |
         |-----------|----------|-----------|-----------|
         | Man       | M        | 1         | 1         |
         | Women     | W        | 1         | 1         |
         | Divorced  | D        | 2         | 1         |
         | Single    | S        | 2         | 1         |
         | Study     | SD       | 3         | 2         |
         | Sports    | SP       | 3         | 2         |
         | Read      | RD       | 3         | 2         |
        
         Example: Of you choose __Man__, __Single__ and __Read__, no banco de dados seria armazenado o seguinte valor __MSRD__.
        

        Manual Lookup Interface. Setting up Multiple Values (position).

        • Label : Text that will be displayed in the Grid.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Start : Starting position of the string that is going to be stored. The first position is always 1.
        • Size : Amount of bytes that is going to occupy in the string.
      • Multiple Values (binary)

          Allows to store a diversity of information selected on the field in only one value.
        
          In this example uses the following list (although it is not informed when inserting values to the list, each item has a value applied automatically according to the order):
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          To store the data, it is done an internal sum of the decimal number. See the examples below.
        
          Example 1: If the options __Sports__ and __Culture__ were selected, the number stored in the table would be __3__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 2 (Culture) = __3__
        
          Example 2: If the options __Sports__, __Pleasure__ and __Reading__ were selected, the number stored in the table would be __13__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 4 (Pleasure) + 8 (Reading) = __13__
        

        Manual Lookup Interface. Setting up Multiple Values (Binary).

        • Label : Text that will be displayed in the Grid.
      • Insert Button : Adds to the list the values informed on the fields Label and Value.
      • Update Button : Modifies the attributes of the selected item.
      • Remove Button : Remove the selected item from the list.
      • Clear Button : Clear the Fields.
      • Save Button : Allows the user to save all the items of the list, to use on other fields, just click on Load lookup definition.
      • Load lookup definitions : Allows to refresh the list of values predefined when using the lookup. It will be listed the existing definitions in ScriptCase and the ones saved by the user.
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.

Decimal

General Settings

Decimal field Configuration Interface. Decimal field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as a Decimal, it is allowed to define the format of a decimal number.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Accumulated : When enables, define that the field will be accumulated with the values of another field. This option is only available on virtual fields.
  • Accumulator field : Only available when the option “Accumulated” is enabled. This configuration defines which field will be used to accumulate the values. The chosen fields needs to be Integer, Currency or Decimal.
  • Grid Mask : Defines the mask for the field display.There are two typed of masks described below:
Character Description
X Placeholder to any character. Replaced by any character. If number of characters entered are less then the mask size, the field value is completed with zeros (Filling full size field entry is required).
Z Replaced by any character retrieved from database. Suppress zeros at field left (Complete field filling is optional). When used combined with the mask character X it should be placed at the mask left.
   

Mask Examples

Mask Field Value Formatted Value
(xx) xxxx - xxxx 1234567890 (12) 3456 - 7890
(xx) xxxx - xxxx 12345678 (00) 1234 - 5678
(zz) xxxx - xxxx 1234567890 (12) 3456 - 7890
(zz) xxxx - xxxx 12345678 ( ) 1234 - 5678
(zz) xxxx - xxxx 0012345678 ( ) 1234 - 5678
  • Do Not Repeat Value : Do not repeat the value of the field in case it is the same as the previous record.

    Diaplying repeated values.

  • SQL Type : Informs the datatype of field in the database.

Values format

Interface of Values Format Format of Values with Regional Settings.

  • Regional Settings : Allows to apply the Regional Settings to format the number of the fields. When not enabled, you will view attributes grouped, Negative Symbol and negative number format.
  • Digit Grouping Separator : Defines the character that will be used to separate the thousand.
  • Decimal Separator : Defines the character that will be used to separate the decimal.
  • Negative sign : Defines the chatacter that will be used to display negative numbers.
  • Negative number format : Defines the position of the Negative sign em relation to the value.
  • Color of Negative : Defines a color for the field when the value is nagative.
  • Decimal Precision : Number of decimal places. This value is part of the field size.
  • Complete with Zeros : Defines the decimal places that will or not be completed zeros to the right. Example: The value is 125,50, but the decimal precision is 3. If the option is enabled, then the value will 125,500.

Lookup Settings

A method used to offer the user a list of values that can be selected in the form applications. For example, the gender field in the Database with the values M or W can be presented like Man or Women or in a dynamic way, having these values recovered from the database.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Lookup Methods

    You will have available two types of lookup methods: Manual (informing manually the conditions of the select) or Automatic (using a database query).

    Selecting the lookup type. Selecting the lookup type.

    • Lookup Method - Automatic

      Automatic Lookup Interface. Automatic Lookup Interface.

      • SQL Select Statement : Define the SQL command that will recover the values that will be displayed on the form field. The command needs to have the following structure SELECT display_field FROM table WHERE key_field = {grid_field}.

      The Grid field needs to be refrenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

      • Multiple Values : When enabled, allows to select more than one item from the list, separated by a delimitator.
      • Delimiter : Defines the character used to separate the values selected in the form. Only inform a value to this field if you need to separate the selected options with a different delimiter then (;).
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.
      • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.
    • Lookup Method - Manual

      This method is used so that the developer can create manually the list of values that will be saved to the generated application. This method is mostly used when the database does not have a table that contains this information.

      Manual Lookup Interface. Manual Lookup Interface.

      • Lookup Type : Define the functionality of the lookup, being: Single Value, Multiple Values (delimiter), Multiple Values (position) and Multiple Values (binary).
        • Single Value :

        It will be displayed only one value for the field. And it will replace the stored value from the table with the one defined on the item label.

        Manual Lookup Interface. Setting up Single Value Lookup

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
      • Múltiplos Valores (Delimitador) It can be displayed various values for the selected field. The values should be separated by a delimitador that will be informed. It is done a replacment on the parts of the field, separated by the delimitador, with the values contained in the list.

        Manual Lookup Interface. Setting up Multiple Values (delimiter).

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Delimiter Characters used to separate Multiple Values in the table field. If not informed, the default delimiter is a semi coma (;).
      • Multiple Values (position)

         Allows to store a diversity of information selected on the field in only one string. For this information to be added, you need to inform the label, initial position and the number of bytes that each information occupies on a string.
        
         For this example, Gender, Marital status and Hobby were used. Gender uses one byte as does the Martial Status, the Hobby will use two bytes.
        
         The example below:
        
         | Label     | Value    | Start     | Size      |
         |-----------|----------|-----------|-----------|
         | Man       | M        | 1         | 1         |
         | Women     | W        | 1         | 1         |
         | Divorced  | D        | 2         | 1         |
         | Single    | S        | 2         | 1         |
         | Study     | SD       | 3         | 2         |
         | Sports    | SP       | 3         | 2         |
         | Read      | RD       | 3         | 2         |
        
         Example: Of you choose __Man__, __Single__ and __Read__, no banco de dados seria armazenado o seguinte valor __MSRD__.
        

        Manual Lookup Interface. Setting up Multiple Values (position).

        • Label : Text that will be displayed in the Grid.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Start : Starting position of the string that is going to be stored. The first position is always 1.
        • Size : Amount of bytes that is going to occupy in the string.
      • Multiple Values (binary)

          Allows to store a diversity of information selected on the field in only one value.
        
          In this example uses the following list (although it is not informed when inserting values to the list, each item has a value applied automatically according to the order):
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          To store the data, it is done an internal sum of the decimal number. See the examples below.
        
          Example 1: If the options __Sports__ and __Culture__ were selected, the number stored in the table would be __3__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 2 (Culture) = __3__
        
          Example 2: If the options __Sports__, __Pleasure__ and __Reading__ were selected, the number stored in the table would be __13__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 4 (Pleasure) + 8 (Reading) = __13__
        

        Manual Lookup Interface. Setting up Multiple Values (Binary).

        • Label : Text that will be displayed in the Grid.
      • Insert Button : Adds to the list the values informed on the fields Label and Value.
      • Update Button : Modifies the attributes of the selected item.
      • Remove Button : Remove the selected item from the list.
      • Clear Button : Clear the Fields.
      • Save Button : Allows the user to save all the items of the list, to use on other fields, just click on Load lookup definition.
      • Load lookup definitions : Allows to refresh the list of values predefined when using the lookup. It will be listed the existing definitions in ScriptCase and the ones saved by the user.
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.

Percent

General Settings

Percentage field Configuration Interface. Percentage field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as a Percentage, it is allowed to define the format of a percentage.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Accumulated : When enables, define that the field will be accumulated with the values of another field. This option is only available on virtual fields.
  • Accumulator field : Only available when the option “Accumulated” is enabled. This configuration defines which field will be used to accumulate the values. The chosen fields needs to be Integer, Currency or Decimal.
  • Grid Mask : Defines the mask for the field display.There are two typed of masks described below:
Character Description
X Placeholder to any character. Replaced by any character. If number of characters entered are less then the mask size, the field value is completed with zeros (Filling full size field entry is required).
Z Replaced by any character retrieved from database. Suppress zeros at field left (Complete field filling is optional). When used combined with the mask character X it should be placed at the mask left.
   

Mask Examples

Mask Field Value Formatted Value
(xx) xxxx - xxxx 1234567890 (12) 3456 - 7890
(xx) xxxx - xxxx 12345678 (00) 1234 - 5678
(zz) xxxx - xxxx 1234567890 (12) 3456 - 7890
(zz) xxxx - xxxx 12345678 ( ) 1234 - 5678
(zz) xxxx - xxxx 0012345678 ( ) 1234 - 5678
  • Do Not Repeat Value : Don’t repeat the value of the field in case it is the same as the previous record.

    Displaying repeated values.

  • SQL Type : Informs the datatype of field in the database.

Values format

Interface of Values Format Format of Values with Regional Settings.

  • Regional Settings : Allows to apply the Regional Settings to format the number of the fields. When not enabled, you will view attributes grouped, Negative Symbol and negative number format.
  • Digit Grouping Separator : Defines the character that will be used to separate the thousand.
  • Decimal Separator : Defines the character that will be used to separate the decimal.
  • Negative sign : Defines the chatacter that will be used to display negative numbers.
  • Negative number format : Defines the position of the Negative sign em relation to the value.
  • Color of Negative : Defines a color for the field when the value is nagative.
  • Decimal Precision : Number of decimal places. This value is part of the field size.
  • Complete with Zeros : Defines the decimal places that will or not be completed zeros to the right. Example: The value is 125,50, but the decimal precision is 3. If the option is enabled, then the value will 125,500.

Lookup Settings

A method used to offer the user a list of values that can be selected in the form applications. For example, the gender field in the Database with the values M or W can be presented like Man or Women or in a dynamic way, having these values recovered from the database.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Lookup Methods

    You will have available two types of lookup methods: Manual (informing manually the conditions of the select) or Automatic (using a database query).

    Selecting the lookup type. Selecting the lookup type.

    • Lookup Method - Automatic

      Automatic Lookup Interface. Automatic Lookup Interface.

      • SQL Select Statement : Define the SQL command that will recover the values that will be displayed on the form field. The command needs to have the following structure SELECT display_field FROM table WHERE key_field = {grid_field}.

      The Grid field needs to be refrenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

      • Multiple Values : When enabled, allows to select more than one item from the list, separated by a delimitator.
      • Delimiter : Defines the character used to separate the values selected in the form. Only inform a value to this field if you need to separate the selected options with a different delimiter then (;).
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.
      • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.
    • Lookup Method - Manual

      This method is used so that the developer can create manually the list of values that will be saved to the generated application. This method is mostly used when the database does not have a table that contains this information.

      Manual Lookup Interface. Manual Lookup Interface.

      • Lookup Type : Define the functionality of the lookup, being: Single Value, Multiple Values (delimiter), Multiple Values (position) and Multiple Values (binary).
        • Single Value :

        It will be displayed only one value for the field. And it will replace the stored value from the table with the one defined on the item label.

        Manual Lookup Interface. Setting up Single Value Lookup

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
      • Múltiplos Valores (Delimitador) It can be displayed various values for the selected field. The values should be separated by a delimitador that will be informed. It is done a replacment on the parts of the field, separated by the delimitador, with the values contained in the list.

        Manual Lookup Interface. Setting up Multiple Values (delimiter).

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Delimiter Characters used to separate Multiple Values in the table field. If not informed, the default delimiter is a semi coma (;).
      • Multiple Values (position)

         Allows to store a diversity of information selected on the field in only one string. For this information to be added, you need to inform the label, initial position and the number of bytes that each information occupies on a string.
        
         For this example, Gender, Marital status and Hobby were used. Gender uses one byte as does the Martial Status, the Hobby will use two bytes.
        
         The example below:
        
         | Label     | Value    | Start     | Size      |
         |-----------|----------|-----------|-----------|
         | Man       | M        | 1         | 1         |
         | Women     | W        | 1         | 1         |
         | Divorced  | D        | 2         | 1         |
         | Single    | S        | 2         | 1         |
         | Study     | SD       | 3         | 2         |
         | Sports    | SP       | 3         | 2         |
         | Read      | RD       | 3         | 2         |
        
         Example: Of you choose __Man__, __Single__ and __Read__, no banco de dados seria armazenado o seguinte valor __MSRD__.
        

        Manual Lookup Interface. Setting up Multiple Values (position).

        • Label : Text that will be displayed in the Grid.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Start : Starting position of the string that is going to be stored. The first position is always 1.
        • Size : Amount of bytes that is going to occupy in the string.
      • Multiple Values (binary)

          Allows to store a diversity of information selected on the field in only one value.
        
          In this example uses the following list (although it is not informed when inserting values to the list, each item has a value applied automatically according to the order):
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          To store the data, it is done an internal sum of the decimal number. See the examples below.
        
          Example 1: If the options __Sports__ and __Culture__ were selected, the number stored in the table would be __3__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 2 (Culture) = __3__
        
          Example 2: If the options __Sports__, __Pleasure__ and __Reading__ were selected, the number stored in the table would be __13__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 4 (Pleasure) + 8 (Reading) = __13__
        

        Manual Lookup Interface. Setting up Multiple Values (Binary).

        • Label : Text that will be displayed in the Grid.
      • Insert Button : Adds to the list the values informed on the fields Label and Value.
      • Update Button : Modifies the attributes of the selected item.
      • Remove Button : Remove the selected item from the list.
      • Clear Button : Clear the Fields.
      • Save Button : Allows the user to save all the items of the list, to use on other fields, just click on Load lookup definition.
      • Load lookup definitions : Allows to refresh the list of values predefined when using the lookup. It will be listed the existing definitions in ScriptCase and the ones saved by the user.
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.

Currency

General Settings

Currency field Configuration Interface. Currency field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as a Currency, it is allowed to define the format of a currency.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Accumulated : When enables, define that the field will be accumulated with the values of another field. This option is only available on virtual fields.
  • Accumulator field : Only available when the option “Accumulated” is enabled. This configuration defines which field will be used to accumulate the values. The chosen fields needs to be Integer, Currency or Decimal.
  • Grid Mask : Defines the mask for the field display.There are two typed of masks described below:
Character Description
X Placeholder to any character. Replaced by any character. If number of characters entered are less then the mask size, the field value is completed with zeros (Filling full size field entry is required).
Z Replaced by any character retrieved from database. Suppress zeros at field left (Complete field filling is optional). When used combined with the mask character X it should be placed at the mask left.
   

Mask Examples

Mask Field Value Formatted Value
(xx) xxxx - xxxx 1234567890 (12) 3456 - 7890
(xx) xxxx - xxxx 12345678 (00) 1234 - 5678
(zz) xxxx - xxxx 1234567890 (12) 3456 - 7890
(zz) xxxx - xxxx 12345678 ( ) 1234 - 5678
(zz) xxxx - xxxx 0012345678 ( ) 1234 - 5678
  • Do Not Repeat Value : Do not repeat the value of the field in case it is the same as the previous record.

    Displaying repeated values.

  • SQL Type : Informs the datatype of field in the database.

Values format

Interface of Values Format. Interface of Values Format.

  • Regional Settings : Allows to apply the Regional Settings to format the number of the fields. When not enabled, you will view attributes grouped, Negative Symbol and negative number format.
  • Currency Format : Defines the content of the field that if it will be presented with the currency format.
  • Currency Symbol : Defines the character that represents the Currency Symbol.
  • Digit Grouping Separator : Defines the character that will be used to separate the thousand.
  • Decimal Separator : Defines the character that will be used to separate the decimal.
  • Negative sign : Defines the character that will be used to display negative numbers.
  • Negative number format : Defines the position of the Negative sign em relation to the value.
  • Color of Negative : Defines a color for the field when the value is negative.
  • Decimal Precision : Number of decimal places. This value is part of the field size.
  • Complete with Zeros : Defines the decimal places that will or not be completed zeros to the right. Example: The value is 125,50, but the decimal precision is 3. If the option is enabled, then the value will 125,500.
  • Display value in full : The value will be displayed in full. Example: 2018(Two thousand eighteen).

Lookup Settings

A method used to offer the user a list of values that can be selected in the form applications. For example, the gender field in the Database with the values M or W can be presented like Man or Women or in a dynamic way, having these values recovered from the database.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Lookup Methods

    You will have available two types of lookup methods: Manual (informing manually the conditions of the select) or Automatic (using a database query).

    Selecting the lookup type. Selecting the lookup type.

    • Lookup Method - Automatic

      Automatic Lookup Interface. Automatic Lookup Interface.

      • SQL Select Statement : Define the SQL command that will recover the values that will be displayed on the form field. The command needs to have the following structure SELECT display_field FROM table WHERE key_field = {grid_field}.

      The Grid field needs to be refrenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

      • Multiple Values : When enabled, allows to select more than one item from the list, separated by a delimitator.
      • Delimiter : Defines the character used to separate the values selected in the form. Only inform a value to this field if you need to separate the selected options with a different delimiter then (;).
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.
      • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.
    • Lookup Method - Manual

      This method is used so that the developer can create manually the list of values that will be saved to the generated application. This method is mostly used when the database does not have a table that contains this information.

      Manual Lookup Interface. Manual Lookup Interface.

      • Lookup Type : Define the functionality of the lookup, being: Single Value, Multiple Values (delimiter), Multiple Values (position) and Multiple Values (binary).
        • Single Value :

        It will be displayed only one value for the field. And it will replace the stored value from the table with the one defined on the item label.

        Manual Lookup Interface. Setting up Single Value Lookup

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
      • Múltiplos Valores (Delimitador) It can be displayed various values for the selected field. The values should be separated by a delimitador that will be informed. It is done a replacment on the parts of the field, separated by the delimitador, with the values contained in the list.

        Manual Lookup Interface. Setting up Multiple Values (delimiter).

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Delimiter Characters used to separate Multiple Values in the table field. If not informed, the default delimiter is a semi coma (;).
      • Multiple Values (position)

         Allows to store a diversity of information selected on the field in only one string. For this information to be added, you need to inform the label, initial position and the number of bytes that each information occupies on a string.
        
         For this example, Gender, Marital status and Hobby were used. Gender uses one byte as does the Martial Status, the Hobby will use two bytes.
        
         The example below:
        
         | Label     | Value    | Start     | Size      |
         |-----------|----------|-----------|-----------|
         | Man       | M        | 1         | 1         |
         | Women     | W        | 1         | 1         |
         | Divorced  | D        | 2         | 1         |
         | Single    | S        | 2         | 1         |
         | Study     | SD       | 3         | 2         |
         | Sports    | SP       | 3         | 2         |
         | Read      | RD       | 3         | 2         |
        
         Example: Of you choose __Man__, __Single__ and __Read__, no banco de dados seria armazenado o seguinte valor __MSRD__.
        

        Manual Lookup Interface. Setting up Multiple Values (position).

        • Label : Text that will be displayed in the Grid.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Start : Starting position of the string that is going to be stored. The first position is always 1.
        • Size : Amount of bytes that is going to occupy in the string.
      • Multiple Values (binary)

          Allows to store a diversity of information selected on the field in only one value.
        
          In this example uses the following list (although it is not informed when inserting values to the list, each item has a value applied automatically according to the order):
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          To store the data, it is done an internal sum of the decimal number. See the examples below.
        
          Example 1: If the options __Sports__ and __Culture__ were selected, the number stored in the table would be __3__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 2 (Culture) = __3__
        
          Example 2: If the options __Sports__, __Pleasure__ and __Reading__ were selected, the number stored in the table would be __13__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 4 (Pleasure) + 8 (Reading) = __13__
        

        Manual Lookup Interface. Setting up Multiple Values (Binary).

        • Label : Text that will be displayed in the Grid.
      • Insert Button : Adds to the list the values informed on the fields Label and Value.
      • Update Button : Modifies the attributes of the selected item.
      • Remove Button : Remove the selected item from the list.
      • Clear Button : Clear the Fields.
      • Save Button : Allows the user to save all the items of the list, to use on other fields, just click on Load lookup definition.
      • Load lookup definitions : Allows to refresh the list of values predefined when using the lookup. It will be listed the existing definitions in ScriptCase and the ones saved by the user.
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.

HTML Image

General Settings

HTML Image field Configuration Interface. HTML Image field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as HTML Image, it allows to place an image to the field.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Image : Defines an image that will be displayed. The icon “Select Image”, lists all the standard images from scriptcase and also the image that you have uploaded to scriptcase. The icon “Upload an image” allows the developer to send an image to the server which is from another machine.
  • Border : Border size for the image in Pixels.
  • Width : Define the width of the image in Pixels.
  • Height : Define the height of the image in Pixels.

Credit Card

General Settings

Credit Card Number Configuration Interface. Credit Card Number Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as a Credit Card Number, it is allowed to define some rules for the display format of the Credit Card.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Do Not Repeat Value : Do not repeat the value of the field in case it is the same as the previous record.

    Diaplying repeated values.

  • SQL Type : Informs the datatype of field in the database.

Lookup Settings

A method used to offer the user a list of values that can be selected in the form applications. For example, the gender field in the Database with the values M or W can be presented like Man or Women or in a dynamic way, having these values recovered from the database.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Lookup Methods

    You will have available two types of lookup methods: Manual (informing manually the conditions of the select) or Automatic (using a database query).

    Selecting the lookup type. Selecting the lookup type.

    • Lookup Method - Automatic

      Automatic Lookup Interface. Automatic Lookup Interface.

      • SQL Select Statement : Define the SQL command that will recover the values that will be displayed on the form field. The command needs to have the following structure SELECT display_field FROM table WHERE key_field = {grid_field}.

      The Grid field needs to be refrenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

      • Multiple Values : When enabled, allows to select more than one item from the list, separated by a delimitator.
      • Delimiter : Defines the character used to separate the values selected in the form. Only inform a value to this field if you need to separate the selected options with a different delimiter then (;).
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.
      • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.
    • Lookup Method - Manual

      This method is used so that the developer can create manually the list of values that will be saved to the generated application. This method is mostly used when the database does not have a table that contains this information.

      Manual Lookup Interface. Manual Lookup Interface.

      • Lookup Type : Define the functionality of the lookup, being: Single Value, Multiple Values (delimiter), Multiple Values (position) and Multiple Values (binary).
        • Single Value :

        It will be displayed only one value for the field. And it will replace the stored value from the table with the one defined on the item label.

        Manual Lookup Interface. Setting up Single Value Lookup

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
      • Múltiplos Valores (Delimitador) It can be displayed various values for the selected field. The values should be separated by a delimitador that will be informed. It is done a replacment on the parts of the field, separated by the delimitador, with the values contained in the list.

        Manual Lookup Interface. Setting up Multiple Values (delimiter).

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Delimiter Characters used to separate Multiple Values in the table field. If not informed, the default delimiter is a semi coma (;).
      • Multiple Values (position)

         Allows to store a diversity of information selected on the field in only one string. For this information to be added, you need to inform the label, initial position and the number of bytes that each information occupies on a string.
        
         For this example, Gender, Marital status and Hobby were used. Gender uses one byte as does the Martial Status, the Hobby will use two bytes.
        
         The example below:
        
         | Label     | Value    | Start     | Size      |
         |-----------|----------|-----------|-----------|
         | Man       | M        | 1         | 1         |
         | Women     | W        | 1         | 1         |
         | Divorced  | D        | 2         | 1         |
         | Single    | S        | 2         | 1         |
         | Study     | SD       | 3         | 2         |
         | Sports    | SP       | 3         | 2         |
         | Read      | RD       | 3         | 2         |
        
         Example: Of you choose __Man__, __Single__ and __Read__, no banco de dados seria armazenado o seguinte valor __MSRD__.
        

        Manual Lookup Interface. Setting up Multiple Values (position).

        • Label : Text that will be displayed in the Grid.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Start : Starting position of the string that is going to be stored. The first position is always 1.
        • Size : Amount of bytes that is going to occupy in the string.
      • Multiple Values (binary)

          Allows to store a diversity of information selected on the field in only one value.
        
          In this example uses the following list (although it is not informed when inserting values to the list, each item has a value applied automatically according to the order):
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          To store the data, it is done an internal sum of the decimal number. See the examples below.
        
          Example 1: If the options __Sports__ and __Culture__ were selected, the number stored in the table would be __3__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 2 (Culture) = __3__
        
          Example 2: If the options __Sports__, __Pleasure__ and __Reading__ were selected, the number stored in the table would be __13__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 4 (Pleasure) + 8 (Reading) = __13__
        

        Manual Lookup Interface. Setting up Multiple Values (Binary).

        • Label : Text that will be displayed in the Grid.
      • Insert Button : Adds to the list the values informed on the fields Label and Value.
      • Update Button : Modifies the attributes of the selected item.
      • Remove Button : Remove the selected item from the list.
      • Clear Button : Clear the Fields.
      • Save Button : Allows the user to save all the items of the list, to use on other fields, just click on Load lookup definition.
      • Load lookup definitions : Allows to refresh the list of values predefined when using the lookup. It will be listed the existing definitions in ScriptCase and the ones saved by the user.
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.

E-mail

General Settings

Email field Configuration Interface. Email field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as an Email, when you click on the field you be offered a choice for your email client and send an email to that specific email.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Do Not Repeat Value : Do not repeat the value of the field in case it is the same as the previous record.

    Displaying repeated values.

  • SQL Type : Informs the data type of field in the database.

Lookup Settings

A method used to offer the user a list of values that can be selected in the form applications. For example, the gender field in the Database with the values M or W can be presented like Man or Women or in a dynamic way, having these values recovered from the database.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Lookup Methods

    You will have available two types of lookup methods: Manual (informing manually the conditions of the select) or Automatic (using a database query).

    Selecting the lookup type. Selecting the lookup type.

    • Lookup Method - Automatic

      Automatic Lookup Interface. Automatic Lookup Interface.

      • SQL Select Statement : Define the SQL command that will recover the values that will be displayed on the form field. The command needs to have the following structure SELECT display_field FROM table WHERE key_field = {grid_field}.

      The Grid field needs to be refrenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

      • Multiple Values : When enabled, allows to select more than one item from the list, separated by a delimitator.
      • Delimiter : Defines the character used to separate the values selected in the form. Only inform a value to this field if you need to separate the selected options with a different delimiter then (;).
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.
      • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.
    • Lookup Method - Manual

      This method is used so that the developer can create manually the list of values that will be saved to the generated application. This method is mostly used when the database does not have a table that contains this information.

      Manual Lookup Interface. Manual Lookup Interface.

      • Lookup Type : Define the functionality of the lookup, being: Single Value, Multiple Values (delimiter), Multiple Values (position) and Multiple Values (binary).
        • Single Value :

        It will be displayed only one value for the field. And it will replace the stored value from the table with the one defined on the item label.

        Manual Lookup Interface. Setting up Single Value Lookup

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
      • Múltiplos Valores (Delimitador) It can be displayed various values for the selected field. The values should be separated by a delimitador that will be informed. It is done a replacment on the parts of the field, separated by the delimitador, with the values contained in the list.

        Manual Lookup Interface. Setting up Multiple Values (delimiter).

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Delimiter Characters used to separate Multiple Values in the table field. If not informed, the default delimiter is a semi coma (;).
      • Multiple Values (position)

         Allows to store a diversity of information selected on the field in only one string. For this information to be added, you need to inform the label, initial position and the number of bytes that each information occupies on a string.
        
         For this example, Gender, Marital status and Hobby were used. Gender uses one byte as does the Martial Status, the Hobby will use two bytes.
        
         The example below:
        
         | Label     | Value    | Start     | Size      |
         |-----------|----------|-----------|-----------|
         | Man       | M        | 1         | 1         |
         | Women     | W        | 1         | 1         |
         | Divorced  | D        | 2         | 1         |
         | Single    | S        | 2         | 1         |
         | Study     | SD       | 3         | 2         |
         | Sports    | SP       | 3         | 2         |
         | Read      | RD       | 3         | 2         |
        
         Example: Of you choose __Man__, __Single__ and __Read__, no banco de dados seria armazenado o seguinte valor __MSRD__.
        

        Manual Lookup Interface. Setting up Multiple Values (position).

        • Label : Text that will be displayed in the Grid.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Start : Starting position of the string that is going to be stored. The first position is always 1.
        • Size : Amount of bytes that is going to occupy in the string.
      • Multiple Values (binary)

          Allows to store a diversity of information selected on the field in only one value.
        
          In this example uses the following list (although it is not informed when inserting values to the list, each item has a value applied automatically according to the order):
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          To store the data, it is done an internal sum of the decimal number. See the examples below.
        
          Example 1: If the options __Sports__ and __Culture__ were selected, the number stored in the table would be __3__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 2 (Culture) = __3__
        
          Example 2: If the options __Sports__, __Pleasure__ and __Reading__ were selected, the number stored in the table would be __13__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 4 (Pleasure) + 8 (Reading) = __13__
        

        Manual Lookup Interface. Setting up Multiple Values (Binary).

        • Label : Text that will be displayed in the Grid.
      • Insert Button : Adds to the list the values informed on the fields Label and Value.
      • Update Button : Modifies the attributes of the selected item.
      • Remove Button : Remove the selected item from the list.
      • Clear Button : Clear the Fields.
      • Save Button : Allows the user to save all the items of the list, to use on other fields, just click on Load lookup definition.
      • Load lookup definitions : Allows to refresh the list of values predefined when using the lookup. It will be listed the existing definitions in ScriptCase and the ones saved by the user.
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.

URL

General Settings

URL field Configuration Interface. URL field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as a URL, it sets the value as a clickable link (Only if it contains a valid path).
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Do Not Repeat Value : Do not repeat the value of the field in case it is the same as the previous record.

    Diaplying repeated values.

  • SQL Type : Informs the datatype of field in the database.

Lookup Settings

A method used to offer the user a list of values that can be selected in the form applications. For example, the gender field in the Database with the values M or W can be presented like Man or Women or in a dynamic way, having these values recovered from the database.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Lookup Methods

    You will have available two types of lookup methods: Manual (informing manually the conditions of the select) or Automatic (using a database query).

    Selecting the lookup type. Selecting the lookup type.

    • Lookup Method - Automatic

      Automatic Lookup Interface. Automatic Lookup Interface.

      • SQL Select Statement : Define the SQL command that will recover the values that will be displayed on the form field. The command needs to have the following structure SELECT display_field FROM table WHERE key_field = {grid_field}.

      The Grid field needs to be refrenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

      • Multiple Values : When enabled, allows to select more than one item from the list, separated by a delimitator.
      • Delimiter : Defines the character used to separate the values selected in the form. Only inform a value to this field if you need to separate the selected options with a different delimiter then (;).
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.
      • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.
    • Lookup Method - Manual

      This method is used so that the developer can create manually the list of values that will be saved to the generated application. This method is mostly used when the database does not have a table that contains this information.

      Manual Lookup Interface. Manual Lookup Interface.

      • Lookup Type : Define the functionality of the lookup, being: Single Value, Multiple Values (delimiter), Multiple Values (position) and Multiple Values (binary).
        • Single Value :

        It will be displayed only one value for the field. And it will replace the stored value from the table with the one defined on the item label.

        Manual Lookup Interface. Setting up Single Value Lookup

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
      • Múltiplos Valores (Delimitador) It can be displayed various values for the selected field. The values should be separated by a delimitador that will be informed. It is done a replacment on the parts of the field, separated by the delimitador, with the values contained in the list.

        Manual Lookup Interface. Setting up Multiple Values (delimiter).

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Delimiter Characters used to separate Multiple Values in the table field. If not informed, the default delimiter is a semi coma (;).
      • Multiple Values (position)

         Allows to store a diversity of information selected on the field in only one string. For this information to be added, you need to inform the label, initial position and the number of bytes that each information occupies on a string.
        
         For this example, Gender, Marital status and Hobby were used. Gender uses one byte as does the Martial Status, the Hobby will use two bytes.
        
         The example below:
        
         | Label     | Value    | Start     | Size      |
         |-----------|----------|-----------|-----------|
         | Man       | M        | 1         | 1         |
         | Women     | W        | 1         | 1         |
         | Divorced  | D        | 2         | 1         |
         | Single    | S        | 2         | 1         |
         | Study     | SD       | 3         | 2         |
         | Sports    | SP       | 3         | 2         |
         | Read      | RD       | 3         | 2         |
        
         Example: Of you choose __Man__, __Single__ and __Read__, no banco de dados seria armazenado o seguinte valor __MSRD__.
        

        Manual Lookup Interface. Setting up Multiple Values (position).

        • Label : Text that will be displayed in the Grid.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Start : Starting position of the string that is going to be stored. The first position is always 1.
        • Size : Amount of bytes that is going to occupy in the string.
      • Multiple Values (binary)

          Allows to store a diversity of information selected on the field in only one value.
        
          In this example uses the following list (although it is not informed when inserting values to the list, each item has a value applied automatically according to the order):
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          To store the data, it is done an internal sum of the decimal number. See the examples below.
        
          Example 1: If the options __Sports__ and __Culture__ were selected, the number stored in the table would be __3__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 2 (Culture) = __3__
        
          Example 2: If the options __Sports__, __Pleasure__ and __Reading__ were selected, the number stored in the table would be __13__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 4 (Pleasure) + 8 (Reading) = __13__
        

        Manual Lookup Interface. Setting up Multiple Values (Binary).

        • Label : Text that will be displayed in the Grid.
      • Insert Button : Adds to the list the values informed on the fields Label and Value.
      • Update Button : Modifies the attributes of the selected item.
      • Remove Button : Remove the selected item from the list.
      • Clear Button : Clear the Fields.
      • Save Button : Allows the user to save all the items of the list, to use on other fields, just click on Load lookup definition.
      • Load lookup definitions : Allows to refresh the list of values predefined when using the lookup. It will be listed the existing definitions in ScriptCase and the ones saved by the user.
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.

Date

General Settings

Date field Configuration Interface. Date field Configuration Interface.

  • Data Type : Define the type of field for the application. When iti s defined as a Date and Time, it is allowed to define the format of the date.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Do Not Repeat Value : Do not repeat the value of the field in case it is the same as the previous record.

    Diaplying repeated values.

  • SQL Type : Informs the datatype of field in the database.

Values format

Format of Values with Regional Settings. Format of Values with Regional Settings.

Format of Values without Regional Settings. Format of Values without Regional Settings.

  • Regional Settings : Allows to apply the Regional Settings to format the dates of the field. When not enabled, it will be displayed the date separater attribute (Check the Regional Settings).
  • Display : Offers a series of formats predefined for displaying dates.
  • Detail Mask : Define the format of the field in the Grid, following the standards the PHP function Date.

    d-m-Y 25-09-2009
    F/Y September/2009
    j/n/Y \a\s g:i:s A 25/9/2001 as 14:30:11 PM
    l, d \d\e F \d\e Y Thursday, 25 of January of 2009
    h:i:s 11:33:20
    #h:i:s 123:43:27 (accumulating the hours)
  • Format Table

    Date Format Table

  • Internal Format : Allows to define the format the field when the SQL type is different from Date. You need to use the characters Y, M and D that correspond to Year, Month and Day.
    • Example 1 : Date stored in a SQL field of the type char(8) where the positions 1 to 4 represents the year, the positions 5 and 6 is the month and the position 7 and 8 is the day, define the internal format like: YYYYMMDD
    • Example 2 : Date stored in a SQL field of the type char(6) where the positions 1 and 2 represents the month and the positions 3 to 6 is the year, define the internal format like: MMYYYY

Lookup Settings

A method used to offer the user a list of values that can be selected in the form applications. For example, the gender field in the Database with the values M or W can be presented like Man or Women or in a dynamic way, having these values recovered from the database.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Lookup Methods

    You will have available two types of lookup methods: Manual (informing manually the conditions of the select) or Automatic (using a database query).

    Selecting the lookup type. Selecting the lookup type.

    • Lookup Method - Automatic

      Automatic Lookup Interface. Automatic Lookup Interface.

      • SQL Select Statement : Define the SQL command that will recover the values that will be displayed on the form field. The command needs to have the following structure SELECT display_field FROM table WHERE key_field = {grid_field}.

      The Grid field needs to be refrenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

      • Multiple Values : When enabled, allows to select more than one item from the list, separated by a delimitator.
      • Delimiter : Defines the character used to separate the values selected in the form. Only inform a value to this field if you need to separate the selected options with a different delimiter then (;).
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.
      • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.
    • Lookup Method - Manual

      This method is used so that the developer can create manually the list of values that will be saved to the generated application. This method is mostly used when the database does not have a table that contains this information.

      Manual Lookup Interface. Manual Lookup Interface.

      • Lookup Type : Define the functionality of the lookup, being: Single Value, Multiple Values (delimiter), Multiple Values (position) and Multiple Values (binary).
        • Single Value :

        It will be displayed only one value for the field. And it will replace the stored value from the table with the one defined on the item label.

        Manual Lookup Interface. Setting up Single Value Lookup

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
      • Múltiplos Valores (Delimitador) It can be displayed various values for the selected field. The values should be separated by a delimitador that will be informed. It is done a replacment on the parts of the field, separated by the delimitador, with the values contained in the list.

        Manual Lookup Interface. Setting up Multiple Values (delimiter).

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Delimiter Characters used to separate Multiple Values in the table field. If not informed, the default delimiter is a semi coma (;).
      • Multiple Values (position)

         Allows to store a diversity of information selected on the field in only one string. For this information to be added, you need to inform the label, initial position and the number of bytes that each information occupies on a string.
        
         For this example, Gender, Marital status and Hobby were used. Gender uses one byte as does the Martial Status, the Hobby will use two bytes.
        
         The example below:
        
         | Label     | Value    | Start     | Size      |
         |-----------|----------|-----------|-----------|
         | Man       | M        | 1         | 1         |
         | Women     | W        | 1         | 1         |
         | Divorced  | D        | 2         | 1         |
         | Single    | S        | 2         | 1         |
         | Study     | SD       | 3         | 2         |
         | Sports    | SP       | 3         | 2         |
         | Read      | RD       | 3         | 2         |
        
         Example: Of you choose __Man__, __Single__ and __Read__, no banco de dados seria armazenado o seguinte valor __MSRD__.
        

        Manual Lookup Interface. Setting up Multiple Values (position).

        • Label : Text that will be displayed in the Grid.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Start : Starting position of the string that is going to be stored. The first position is always 1.
        • Size : Amount of bytes that is going to occupy in the string.
      • Multiple Values (binary)

          Allows to store a diversity of information selected on the field in only one value.
        
          In this example uses the following list (although it is not informed when inserting values to the list, each item has a value applied automatically according to the order):
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          To store the data, it is done an internal sum of the decimal number. See the examples below.
        
          Example 1: If the options __Sports__ and __Culture__ were selected, the number stored in the table would be __3__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 2 (Culture) = __3__
        
          Example 2: If the options __Sports__, __Pleasure__ and __Reading__ were selected, the number stored in the table would be __13__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 4 (Pleasure) + 8 (Reading) = __13__
        

        Manual Lookup Interface. Setting up Multiple Values (Binary).

        • Label : Text that will be displayed in the Grid.
      • Insert Button : Adds to the list the values informed on the fields Label and Value.
      • Update Button : Modifies the attributes of the selected item.
      • Remove Button : Remove the selected item from the list.
      • Clear Button : Clear the Fields.
      • Save Button : Allows the user to save all the items of the list, to use on other fields, just click on Load lookup definition.
      • Load lookup definitions : Allows to refresh the list of values predefined when using the lookup. It will be listed the existing definitions in ScriptCase and the ones saved by the user.
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.

Time

General Settings

Time field Configuration Interface. Time field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as Time, it is possible to define a Time Format.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Do Not Repeat Value : Do not repeat the value of the field in case it is the same as the previous record.

    Diaplying repeated values.

  • SQL Type : Informs the datatype of field in the database.

Values format

Format of Values with Regional Settings. Format of Values with Regional Settings.

Format of Values without Regional Settings. Format of Values without Regional Settings.

  • Regional Settings : Allows to apply the Regional Settings to format the dates of the field. When not enabled, it will be displayed the date separater attribute (Check the Regional Settings).
  • Display : Offers a series of formats predefined for displaying dates.
  • Detail Mask : Define the format of the field in the Grid, following the standards the PHP function Date.

    d-m-Y 25-09-2009
    F/Y September/2009
    j/n/Y \a\s g:i:s A 25/9/2001 as 14:30:11 PM
    l, d \d\e F \d\e Y Thursday, 25 of January of 2009
    h:i:s 11:33:20
    #h:i:s 123:43:27 (accumulating the hours)
  • Format Table

    Date Format Table

  • Internal Format : Allows to define the format the field when the SQL type is different from Date. You need to use the characters Y, M and D that correspond to Year, Month and Day.
    • Example 1 : Date stored in a SQL field of the type char(8) where the positions 1 to 4 represents the year, the positions 5 and 6 is the month and the position 7 and 8 is the day, define the internal format like: YYYYMMDD
    • Example 2 : Date stored in a SQL field of the type char(6) where the positions 1 and 2 represents the month and the positions 3 to 6 is the year, define the internal format like: MMYYYY

Lookup Settings

A method used to offer the user a list of values that can be selected in the form applications. For example, the gender field in the Database with the values M or W can be presented like Man or Women or in a dynamic way, having these values recovered from the database.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Lookup Methods

    You will have available two types of lookup methods: Manual (informing manually the conditions of the select) or Automatic (using a database query).

    Selecting the lookup type. Selecting the lookup type.

    • Lookup Method - Automatic

      Automatic Lookup Interface. Automatic Lookup Interface.

      • SQL Select Statement : Define the SQL command that will recover the values that will be displayed on the form field. The command needs to have the following structure SELECT display_field FROM table WHERE key_field = {grid_field}.

      The Grid field needs to be refrenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

      • Multiple Values : When enabled, allows to select more than one item from the list, separated by a delimitator.
      • Delimiter : Defines the character used to separate the values selected in the form. Only inform a value to this field if you need to separate the selected options with a different delimiter then (;).
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.
      • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.
    • Lookup Method - Manual

      This method is used so that the developer can create manually the list of values that will be saved to the generated application. This method is mostly used when the database does not have a table that contains this information.

      Manual Lookup Interface. Manual Lookup Interface.

      • Lookup Type : Define the functionality of the lookup, being: Single Value, Multiple Values (delimiter), Multiple Values (position) and Multiple Values (binary).
        • Single Value :

        It will be displayed only one value for the field. And it will replace the stored value from the table with the one defined on the item label.

        Manual Lookup Interface. Setting up Single Value Lookup

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
      • Múltiplos Valores (Delimitador) It can be displayed various values for the selected field. The values should be separated by a delimitador that will be informed. It is done a replacment on the parts of the field, separated by the delimitador, with the values contained in the list.

        Manual Lookup Interface. Setting up Multiple Values (delimiter).

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Delimiter Characters used to separate Multiple Values in the table field. If not informed, the default delimiter is a semi coma (;).
      • Multiple Values (position)

         Allows to store a diversity of information selected on the field in only one string. For this information to be added, you need to inform the label, initial position and the number of bytes that each information occupies on a string.
        
         For this example, Gender, Marital status and Hobby were used. Gender uses one byte as does the Martial Status, the Hobby will use two bytes.
        
         The example below:
        
         | Label     | Value    | Start     | Size      |
         |-----------|----------|-----------|-----------|
         | Man       | M        | 1         | 1         |
         | Women     | W        | 1         | 1         |
         | Divorced  | D        | 2         | 1         |
         | Single    | S        | 2         | 1         |
         | Study     | SD       | 3         | 2         |
         | Sports    | SP       | 3         | 2         |
         | Read      | RD       | 3         | 2         |
        
         Example: Of you choose __Man__, __Single__ and __Read__, no banco de dados seria armazenado o seguinte valor __MSRD__.
        

        Manual Lookup Interface. Setting up Multiple Values (position).

        • Label : Text that will be displayed in the Grid.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Start : Starting position of the string that is going to be stored. The first position is always 1.
        • Size : Amount of bytes that is going to occupy in the string.
      • Multiple Values (binary)

          Allows to store a diversity of information selected on the field in only one value.
        
          In this example uses the following list (although it is not informed when inserting values to the list, each item has a value applied automatically according to the order):
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          To store the data, it is done an internal sum of the decimal number. See the examples below.
        
          Example 1: If the options __Sports__ and __Culture__ were selected, the number stored in the table would be __3__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 2 (Culture) = __3__
        
          Example 2: If the options __Sports__, __Pleasure__ and __Reading__ were selected, the number stored in the table would be __13__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 4 (Pleasure) + 8 (Reading) = __13__
        

        Manual Lookup Interface. Setting up Multiple Values (Binary).

        • Label : Text that will be displayed in the Grid.
      • Insert Button : Adds to the list the values informed on the fields Label and Value.
      • Update Button : Modifies the attributes of the selected item.
      • Remove Button : Remove the selected item from the list.
      • Clear Button : Clear the Fields.
      • Save Button : Allows the user to save all the items of the list, to use on other fields, just click on Load lookup definition.
      • Load lookup definitions : Allows to refresh the list of values predefined when using the lookup. It will be listed the existing definitions in ScriptCase and the ones saved by the user.
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.

Date and time

General Settings

Date and Time field Configuration Interface. Date and Time field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as a Time, it is allowed to define the format of the time.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Do Not Repeat Value : Do not repeat the value of the field in case it is the same as the previous record.

    Diaplying repeated values.

  • SQL Type : Informs the datatype of field in the database.

Values format

Format of Values with Regional Settings. Format of Values with Regional Settings.

Format of Values without Regional Settings. Format of Values without Regional Settings.

  • Regional Settings : Allows to apply the Regional Settings to format the dates of the field. When not enabled, it will be displayed the date separater attribute (Check the Regional Settings).
  • Display : Offers a series of formats predefined for displaying dates.
  • Detail Mask : Define the format of the field in the Grid, following the standards the PHP function Date.

    d-m-Y 25-09-2009
    F/Y September/2009
    j/n/Y \a\s g:i:s A 25/9/2001 as 14:30:11 PM
    l, d \d\e F \d\e Y Thursday, 25 of January of 2009
    h:i:s 11:33:20
    #h:i:s 123:43:27 (accumulating the hours)
  • Format Table

    Date Format Table

  • Internal Format : Allows to define the format the field when the SQL type is different from Date. You need to use the characters Y, M and D that correspond to Year, Month and Day.
    • Example 1 : Date stored in a SQL field of the type char(8) where the positions 1 to 4 represents the year, the positions 5 and 6 is the month and the position 7 and 8 is the day, define the internal format like: YYYYMMDD
    • Example 2 : Date stored in a SQL field of the type char(6) where the positions 1 and 2 represents the month and the positions 3 to 6 is the year, define the internal format like: MMYYYY

Lookup Settings

A method used to offer the user a list of values that can be selected in the form applications. For example, the gender field in the Database with the values M or W can be presented like Man or Women or in a dynamic way, having these values recovered from the database.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Lookup Methods

    You will have available two types of lookup methods: Manual (informing manually the conditions of the select) or Automatic (using a database query).

    Selecting the lookup type. Selecting the lookup type.

    • Lookup Method - Automatic

      Automatic Lookup Interface. Automatic Lookup Interface.

      • SQL Select Statement : Define the SQL command that will recover the values that will be displayed on the form field. The command needs to have the following structure SELECT display_field FROM table WHERE key_field = {grid_field}.

      The Grid field needs to be refrenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

      • Multiple Values : When enabled, allows to select more than one item from the list, separated by a delimitator.
      • Delimiter : Defines the character used to separate the values selected in the form. Only inform a value to this field if you need to separate the selected options with a different delimiter then (;).
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.
      • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.
    • Lookup Method - Manual

      This method is used so that the developer can create manually the list of values that will be saved to the generated application. This method is mostly used when the database does not have a table that contains this information.

      Manual Lookup Interface. Manual Lookup Interface.

      • Lookup Type : Define the functionality of the lookup, being: Single Value, Multiple Values (delimiter), Multiple Values (position) and Multiple Values (binary).
        • Single Value :

        It will be displayed only one value for the field. And it will replace the stored value from the table with the one defined on the item label.

        Manual Lookup Interface. Setting up Single Value Lookup

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
      • Múltiplos Valores (Delimitador) It can be displayed various values for the selected field. The values should be separated by a delimitador that will be informed. It is done a replacment on the parts of the field, separated by the delimitador, with the values contained in the list.

        Manual Lookup Interface. Setting up Multiple Values (delimiter).

        • Label : Text that will be displayed in the item list of the select field.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Delimiter Characters used to separate Multiple Values in the table field. If not informed, the default delimiter is a semi coma (;).
      • Multiple Values (position)

         Allows to store a diversity of information selected on the field in only one string. For this information to be added, you need to inform the label, initial position and the number of bytes that each information occupies on a string.
        
         For this example, Gender, Marital status and Hobby were used. Gender uses one byte as does the Martial Status, the Hobby will use two bytes.
        
         The example below:
        
         | Label     | Value    | Start     | Size      |
         |-----------|----------|-----------|-----------|
         | Man       | M        | 1         | 1         |
         | Women     | W        | 1         | 1         |
         | Divorced  | D        | 2         | 1         |
         | Single    | S        | 2         | 1         |
         | Study     | SD       | 3         | 2         |
         | Sports    | SP       | 3         | 2         |
         | Read      | RD       | 3         | 2         |
        
         Example: Of you choose __Man__, __Single__ and __Read__, no banco de dados seria armazenado o seguinte valor __MSRD__.
        

        Manual Lookup Interface. Setting up Multiple Values (position).

        • Label : Text that will be displayed in the Grid.
        • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
        • Start : Starting position of the string that is going to be stored. The first position is always 1.
        • Size : Amount of bytes that is going to occupy in the string.
      • Multiple Values (binary)

          Allows to store a diversity of information selected on the field in only one value.
        
          In this example uses the following list (although it is not informed when inserting values to the list, each item has a value applied automatically according to the order):
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          To store the data, it is done an internal sum of the decimal number. See the examples below.
        
          Example 1: If the options __Sports__ and __Culture__ were selected, the number stored in the table would be __3__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 2 (Culture) = __3__
        
          Example 2: If the options __Sports__, __Pleasure__ and __Reading__ were selected, the number stored in the table would be __13__.
        
          | Attribute Value   | Lookup Description    |
          |-------------------|-----------------------|
          | 1                 | Sports                |
          | 2                 | Culture               |
          | 4                 | Pleasure              |
          | 8                 | Reading               |
          | 16                | Music                 |
        
          1 (Sports) + 4 (Pleasure) + 8 (Reading) = __13__
        

        Manual Lookup Interface. Setting up Multiple Values (Binary).

        • Label : Text that will be displayed in the Grid.
      • Insert Button : Adds to the list the values informed on the fields Label and Value.
      • Update Button : Modifies the attributes of the selected item.
      • Remove Button : Remove the selected item from the list.
      • Clear Button : Clear the Fields.
      • Save Button : Allows the user to save all the items of the list, to use on other fields, just click on Load lookup definition.
      • Load lookup definitions : Allows to refresh the list of values predefined when using the lookup. It will be listed the existing definitions in ScriptCase and the ones saved by the user.
      • Use lookup in :
        • Grid : Applies the lookup to all the Grid formats (HTML, PDF, XML , CSV and RTF).
        • Summary : Applies the lookup only for the summary (HTML and PDF).
        • Both : Applies to both the Grid and Summary.
      • Default value : Defines the default value, used in the cases where the select command does not return any values.
      • Display original and lookup value : When selected No, its displayed onlt the value from the select command. Otherwise, it will be displayed the original value of the field and the value returned from the select command separated by the character in the “Separated by” field.
      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.

Image (Database)

General Settings

Upload field Configuration Interface. Upload field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as an Image ( Database), all the Images files are stored and loaded directly from the Database.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Image Border : Width of the Image border. Value in Pixels.
  • Image Height : Image height size. Value in Pixels.
  • Image Width : Image width size. Value in Pixels.
  • Maintain Aspect : Maintains the original aspect ratio of the image when resizing it.
  • Open in Another Window : Allows to open the image in another window.
  • SQL Type : Informs the datatype of field in the database.

Image (File Name)

General Settings

Upload field Configuration Interface. Upload field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as an Image (File Name), all the images files are stored and loaded in a directory of the server (Only the image name is stored in the database).
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Image Border : Width of the Image border. Value in Pixels.
  • Image Height : Image height size. Value in Pixels.
  • Image Width : Image width size. Value in Pixels.
  • Maintain Aspect : Maintains the original aspect ratio of the image when resizing it.
  • Open in Another Window : Allows to open the image in another window.
  • SQL Type : Informs the datatype of field in the database.

Document (Database)

General Settings

Upload field Configuration Interface. Upload field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as a Document ( Database), all the document files are stored and loaded directly from the Database.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Icon : Displays an icon beside the field to identify the type of document.
  • File Name : Defines the field that contains the name of the document stored in the database ( the field that contains this information also needs to be stored in the database).
  • SQL Type : Informs the datatype of field in the database.

Document (File Name)

General Settings

Upload field Configuration Interface. Upload field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as a Document (File Name), all the document files are stored and loaded in a directory of the server (Only the document name is stored in the database).
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Subfolder : Subfolder’s name that the files are stored.
  • Icon : Displays an icon beside the field to identify the type of document.
  • File Name : Defines the field that contains the name of the document stored in the server ( the field that contains this information also needs to be stored in the database).
  • SQL Type : Informs the datatype of field in the database.

QRCode

General Settings

QRCODE field Configuration Interface. QRCODE field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as a QRCODE, allows you to set values into a QRCODE.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • SQL Type : Informs the datatype of field in the database.

Values format

Interface of Values Format. Interface of Values Format.

  • Level of error correction : Codewords are 8 bits long and use the Reed–Solomon error correction algorithm with four error correction levels. The higher the error correction level, the less storage capacity.
  • Image Size : Size of the QRCODE.
  • Margin : Margin of the QRCODE.

Interface of Values Format. Interface of Values Format.

Display Settings

The Display Settings allows to define the CSS values individually for each field. For each Display schema of scriptcase, there are the same attributes available in Interface.

Display Settings configuration Interface. Display Settings configuration Interface.

  • Field Settings
    • Font Style : Allows to select the font family, that will be applied to the application field.
    • Font Size : Allows to choose the font size, that will be applied to the application field.
    • Italic Text : Formatting the Text to be Italic.
    • Bold Text : Formatting the Text to be Bold.
    • Don’t truncate : Do not truncate by the amount of bytes or by the Grid columns.
    • Number of characters : Amount of characters in bytes to display.
    • Horizontal Alignment : Allows to position the label of the filter in the desired location (left right, center and justify).
    • Vertical Alignment : Allows to position the label of the filter in the desired location (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Background Image : Background Image of the field.
    • Line Break : Allows the Line Break.
    • Font Color : Allows to apply a color to the font by choosing a color from the color palette.
    • Background Color : Allows to apply a color to the field background by choosing a color from the color palette.
    • Width : Allows to define a width to the field.
    • Height : Allows to define a height to the field.
    • Title Horizontal Alignment : Define the Title Horizontal Alignment of the field.
    • Title Vertical Alignment : Define the Title Vertical Alignment of the field.
    • Bold : Applies the bold type font to the field.

Bar code

General Settings

Configuration Interface of the Barcode Field. Configuration Interface of the Barcode Field.

  • Data Type : DataType of the field for the application.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it’ll be more clear for the comprehension of the user if the name would be “Client Name”.
  • SQL Type : Database field type.

Barcode

Configuration Interface of the Barcode Field. Configuration Interface of the Barcode Field.

  • Type : Type of Barcode.
  • Text : Barcode Text for illustration purposes.

  • There are 18 types of barcodes, that are listed below:

Barcode configuratio interface. Barcode configuratio interface.

Display Settings

The Display Settings allows to define the CSS values individually for each field. For each Display schema of scriptcase, there are the same attributes available in Interface.

Display Settings configuration Interface. Display Settings configuration Interface.

  • Field Settings
    • Font Style : Allows to select the font family, that will be applied to the application field.
    • Font Size : Allows to choose the font size, that will be applied to the application field.
    • Italic Text : Formatting the Text to be Italic.
    • Bold Text : Formatting the Text to be Bold.
    • Don’t truncate : Do not truncate by the amount of bytes or by the Grid columns.
    • Number of characters : Amount of characters in bytes to display.
    • Horizontal Alignment : Allows to position the label of the filter in the desired location (left right, center and justify).
    • Vertical Alignment : Allows to position the label of the filter in the desired location (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Background Image : Background Image of the field.
    • Line Break : Allows the Line Break.
    • Font Color : Allows to apply a color to the font by choosing a color from the color palette.
    • Background Color : Allows to apply a color to the field background by choosing a color from the color palette.
    • Width : Allows to define a width to the field.
    • Height : Allows to define a height to the field.
    • Title Horizontal Alignment : Define the Title Horizontal Alignment of the field.
    • Title Vertical Alignment : Define the Title Vertical Alignment of the field.
    • Bold : Applies the bold type font to the field.

SubSelect

General Settings

SubSelect field configuration Interface. SubSelect field configuration Interface.

Increment : Defines the space between the record lines of the SubSelect field. Connection : Displays a list of connections created in the current project. Table : Displays the tables related to the database connection selected previously. SubSelect : Displays the SQL of the chosen table in the previous option. Allowed to be modified and use field variables and global variables. SQLBuilder : Opens the ScriptCase SQLBuilder, to build the SQL commands.