Open topic with navigation

Date and Time



Image1: General Settings Interface

Attributes:


Date and Time Format


Image2: Values Format with regional settings.



Image3: Values Format without regional settings.

Attributes:

  • Detail Mask - Define the grid display format to the field, according to the PHP Date function.

    Examples:

    d-m-Y

    25-09-2009

    F/Y

    September/2009

    j/n/Y \a\s g:i:s A

    25/9/2001 14:30:11 PM

    l, d \d\e F \d\e Y

    Thursday, January 25 2009

    h:i:s

    11:33:20

    #h:i:s

    123:43:27 (in hours)

    Formatting Table

    j

    day of the month

    "1" to "31"

    d

    day do month with zero at left

    "01" a "31"

    n

    month

    "1" a"12"

    m

    month with zero at left

    "01" a"12"

    M

    month (written format with 3 char)

    "Jan"

    F

    month (written format complete)

    "January"

    y

    year with 2 digits

    "09"

    Y

    year with 4 digits

    "2009"

    D

    weekday with 3 char

    "Mon"

    l

    weekday (written format complete)

    "Monday"

    g

    hour 12-hours format

    "1" a "12"

    G

    hour 24-hours format

    "0" a "23"

    h

    hour 12-hours format with zero at left

    "01" a "12"

    H

    hour 24-hours format with zero at left

    "00" a "23"

    i

    minutes

    "00" a "59"

    s

    seconds with zero at left

    "00" a "59"

    a

    pre and pos meridian

    "am" a "pm"

    A

    pre and pos meridian

    "AM" a "PM"

    #h

    hours accumulator

    #i

    minutes accumulator

    #s

    seconds accumulator

    \

    escape

  • Internal Format - Define the field formatting when SQL type is different from Date. Use the characters Y, M and D for Year, Month and Day to enter the format.

    Example1:
    For a date stored as char(8) SQL where the positions 1 to 4 represent the year, the position 5 and 6 the month and the positions 7 and 8 the day, define the internal format as: YYYYMMDD

    Example2: For a date stored as char(6) SQL where the positions 1 to2 represent the month and the positions 3 and 6 the year , define the internal format as: MMYYYY


  • Grid Lookup

    Used to modify the display of a grid field. For example, a field gender in the database with values M or F is displayed as Male or Female (see lookup manual) or the display values retrieve from a database table (see lookup automatic).

     

    Before Lookup
    After Lookup




    Grid Lookup - Automatic

    Lookup used to modify a field display dynamically, retrieving the values from a database table.


    Figure3: Automatic Grid Lookup Interface.

    Attributes :


    Grid Lookup - Manual

    Lookup used to modify a field display with predefined values.


    Figure1: Manual Grid LookupInterface.

    Attributes :

     Single Value 

    Display a single value to the field by direct substitution. The value store in the database is substituted by a label defined in a list.


    Figure1.1: Single Value lookup settings.



      Multiple Values (Delimiter) 

    Display more than one value for the selected field by replacing the string saved in the table by full description. The string values are separated by a defined delimiter. For example, the stored value S;M is displayed Sports(S) and Movies(M) in a list.


    Figure1.2: Multiple Value lookup settings (delimiter).



     Multiple Values (Position) 

    Display more than one value for the selected field by replacing the string saved in the table by full description. The values are retrieved based on the string position and size.

    For example, in a string to save Gender (one byte), Marital Status (one byte) and Hobby (two bytes) the information stored includes label, start position in the string and size in bytes that each info occupies in the list:

    Label Value Start Size
    Male M 1 1
    Female F 1 1
    Married C 2 1
    Single S 2 1
    Sports SP 3 2
    Movies MO 3 2
    Books BO 3 2
    Traveling TR 3 2

    A string saved as MMBO is displayed: MaleMarried Books .


    Figure1.3: Multiple Value lookup settings (position).

     



     Multiple Values (Binary) 

    Display more than one value for the selected field by replacing the string saved in the table by full description. In this options the values are stored as decimal and retrieved by specific algorithm.

    For example, the following information list has the data and the value automatically attributed relative to the position that each value occupies. (the values are displayed):

    Attributed Value Lookup Description
    1 Sports
    2 Movies
    4 Books
    8 Traveling
    16 Music

    To display the info 11 and 12 (stored in the database), according to the list above, use the following algorithm:

    11 = 1 + 2 + 8 = (Sports - Movies - Traveling)

    Attributed Value Lookup Description
    1 Sports
    2 Movies
    4 Books
    8 Traveling
    16 Music


    12 = 4 + 8 = ( Books - Traveling)

    Attributed Value Lookup Description
    1 Sports
    2 Movies
    4 Books
    8 Traveling
    16 Music


    Figure1.4: Multiple Value lookup settings (Binary).

    Label - Text displayed in the grid.

     

     


    DISPLAY SETTINGS

    Scriptcase will attribute to the field the options bellow.


    Figure5: Display Settings

    Attributes:


    Column Chart

    Display an icon on the side of the Field Title to display a chart.

    Column Chart Interface.



    Attributes: