Feedback Print

Document (Database)

General Settings

Document (Database) field Configuration Interface. Document (Database) 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.
  • Progress bar : Displays a progress bar when sending the files to the server.
  • Upload area : Displays a drag and drop area to upload the file.
  • 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).
  • File Size : Defines the field that contains the file size.
  • Extensions to allow : Extensions allowed to upload, separated by a semi coma (;). If left in blank, all the extensions are allowed. e.g. docx;jpg;png;xls
  • Hidden Field : This option makes the field hidden, but still allows its value to be processed through JavaScript or PHP.
  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the data type of field in the database.

Multi-upload

This option allows to upload multiple files and store them on a table referencing a record from another table.

To use this option you first need to create a virtual field._

Multi-Upload Configuration. Multi-Upload Configuration.

  • Amount of columns : Amount of columns to displays the files in the Field.
  • Files sorting : Enables files sorting after the upload.
  • Position of the delete : Checkbox option to delete files position.
  • Position on the upload : Position of the records when uploading.
  • Show status : Display the upload status.
  • Table : Select the table that will store the information of the files when uploading.

After selecting the table, you will see a list of all the fields of the chosen table, where you will associate the parameters for each field when inserting a new record or updating an existing record.

Multi-Upload fields of the table Configuration. Multi-Upload fields of the table Configuration.

  • File Name : Obtains the name of the file that is being loaded.
  • Upload : Obtains the binary value of the file.
  • Auto Increment : Used only when field in the database in an auto increment or similar.
  • Manual Increment : The form will be responsible for managing the auto-increment, calculating the value of the field before inserting the record.
  • Foreign Key : Associates the file with a value of a field in the current form.
  • Defined : You can specify a constant value or use a global variable. [global_var]
  • Date of Insertion : Obtains the data of the server when inserting the record.
  • Datetime of Insertion : Obtains the data and time of the server when inserting the record.
  • User IP : The field will contain the IP of the computer that is accessing the application.
  • Calculated by the Database : The value of the field is applied in the database.
  • Calculated by the Database if empty : The value of the field is applied in the database if not informed by the application.
  • Null : The field will the null value.

Watch bellow a video about Multiupload option:

Display Settings

The Display Settings allows to define the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallet.
    • Background Color : Allows to define the color for the field, the color can be selected from the color pallet.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallet to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,right,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallet.
    • Background Color : Allows to define the color for the field, the color can be selected from the color pallet.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallet to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,right,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallet.
    • Background Color : Allows to define the color for the Input Object, the color can be selected from the color pallet.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallet to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,right,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

Allow the developer to set up instructions and hints about the field’s use, allowing the developer to help the users about the system usage.

Help Configuration Interface.

Description of the settings attributes.

Help Description

In this area, you can set up a text that will be shown in the application according to the type of help selected below.

Help Type

Pop-up - Display a default icon ! beside the field. To display the message just click in the icon that a Pop-up will be displayed with the help text.

Help Display Type Configuration Interface.

Hint - Display a default icon ! beside the field. When the mouse is above the icon a help text will be displayed.

Help Display Type Configuration Interface.

The icon displayed when selecting the types Hint or Pop-up vary according to the theme that is being used in the application. This icon can be modified in the CSS Buttons.

Text - Display a text inside of a <span></span> beside the field.

Help Display Type Configuration Interface.

Help button position

Allow to set up where the help button will be displayed in the field, there are two options:

Beside: The help icon will be displayed beside the field.
Column: The help icon will be displayed beside the label of the field.