Date and time
Date and Time field Configuration Interface.
Define the type of field. When setting it to Date and Time, you can inform its format into this field.
The Label option lets you define the title of a field. Example: If the database field name is “cmp_name_client”, You can display a different name for the user, like “Client Name”.
Do Not Repeat Value
Do not repeat the value of the field if it is the same as the previous record.
It informs the data type of field in the database.
Format of Values with Regional Settings.
Format of Values without Regional Settings.
It allows applying the Regional Settings to format the dates of the field. When not enabled, it displays the date separator attribute (Check the Regional Settings).
It offers predefined formats for displaying dates.
Define the format of the field in the Grid. It uses the patterns of 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)| ![Date Format Table][cons_data_format_date]
It allows defining the field format when the SQL type is different from Date. You must use the characters Y, M and D that correspond to Year, Month and Day.
- Example 1 : If the field is storing the Date value in a 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, you must define the internal format as: YYYYMMDD
- Example 2 : If the field is storing the Date value in a char(6) where the positions 1 and 2 represents the month and the positions 3 to 6 is the year, you must define the internal format as: MMYYYY
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.
- 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.
This option allows breaking the line in the PDF file when exported.
By using this option, you will see an icon on the Field Title, this icon displays a chart relating to the field.
On this type option you need to choose two columns to build the chart. The first one is the field its self that you are working with, and the second one is the you chose and is called “Column for Label”.
Bar Chart Interface.
- Group by Label : Groups the values of the column by the label. Similar to the effect of the group by of the a Select.
- Summary Function : Function that summarizes the data applied to the column. The functions that can be used on the field are the following: Count, Sum, Max, Min and Avg.
- Configurable Chart : Allows the user to setup the parameters of the chart creation when the application is running.
- Display Values : Displays the values of the generated chart.
- Column for Label : Selecting the column that will be the label for the field.
- Chart Width : Width of the chart, in pixels.
- Chart Height : Height of the chart, in pixels.
Chart layout settings interface.