1. Outline
A table is a control that lists data in an Excel matrix-like display format.
It is also possible to designate colors and shapes to create a well-designed table.
In the following, we will use the term "2. Development GuidanceIn addition, you can download a sample program that summarizes the most commonly used functions in the table at "3. ParametersThe section "Table" contains references to the parameters to be set in the table.
2. Development Guidance
This article introduces parameter settings that are commonly used to familiarize you with the table. The sample projects used in the explanation can be downloaded from the following links.
2-1. Create tables
Before we get into setting up the table control, we first create the table to be associated with the table.
Create a new file from the DB design function, and register "Item Name", "Physical Item Name" and "Type" from "Design" of the created table, respectively, as follows.
Click "Reload" under "Stored Data" in the table you created, and then enter values.
After entering a value, click "Commit" to register the entered value.
2-2. Create a table of table specification type
Place the table and set the design. In the Properties area, select Object Basic Info Style, in this case a gray and white table.
Connect the tables created in 2-1 to the table. The ties allow the data in the table to be displayed in a table.
Select "Table" from "Data" "Contents" in the Properties area and set "Table Name" to the table created in 2-1.
Check the "Column Header" and "Row Header" boxes.
Next, press the "Display Items" button in the figure above to launch the "Display Item Settings" screen, where you can set the items to be displayed in the table.
This completes the table linkage.
It is also possible to change the fill color of the area where the table is clicked.
2-3. Create a data form type table
2-3-1. Setting up data forms
In 2-2, we tied a table control to a table, but we can tie a form to a table.
Click on an empty area of the form (application screen), then go to "Data" "Contents" in the Properties area and set the "Table Name" to the table created in 2-1.
2-3-2. Linking Tables and Data Forms
Select the table again and choose "Data" "Contents" "Form" to link the table to the data in the table that was linked to the form above.
Check the "Column Header" and "Row Selection" checkboxes.
Clicking the "Display Items" button in the above figure starts up the "Display Item Settings" screen as in 2-2, so set the items to be displayed.
As in 2-2, the data in the table will be displayed in a table.
3. Parameters
By changing the parameters, you can easily set the position, size, color, shape, and items to be displayed in the table, so take advantage of them to create a well-designed, easy-to-understand screen.
In addition, by setting up actions to be invoked during screen operations, you can make the application perform various actions when the application user touches or clicks on a table.
object
The table's basic information and behavior settings are set from "Objects". By making the table inactive, it is possible to set up a table that becomes active only when the app user performs certain operations, etc.
Basic Information
| name | Table Name. For example, if you want the table to have behavior from the processing logic, Designate the table by this name. The default is "table + sequential numbers". |
|---|---|
| Size | The width and height of the table can be specified in detail in one-pixel increments. |
| position | You can specify the position of the table. The starting point is the upper left corner of the screen. |
| margin | You can create a blank area where the table is not displayed. Specified by the distance from the top and bottom of the table to the left and right. |
| type | You can check the type of control. No changes can be made. |
| style | By choosing from a selection of pre-prepared styles, Easily set parameters such as color and ruled lines. |
operation setup
| executable process | Sets the process to be executed after the table is touched or clicked and released. |
|---|---|
| long press (of button, esp. mobile phones) | Sets the process to be executed when the table is pressed and held (for 1 second or longer). |
| pushdown operation | Sets the process to be executed at the moment the table is pressed. |
possibility
| available | The table can be deactivated (operation disabled) by unchecking this checkbox. For example, when setting up a table that cannot be pushed until certain conditions are met. Use. |
|---|---|
| display | Uncheck this box to hide the table. Used to set up a table that will not be displayed until certain conditions are met. The following is a summary of the results of the study. |
| Bouncing. | Unchecking this checkbox allows you to set the table scrolling not to bounce Can be done. This is used, for example, to stop the scrolling range of a table at a limit value. |
data
Contents
Settings related to the table data to be displayed in the table are made in the "Data" section. It can display data from forms and databases.
form
Set this option if the table specified in the data form is used to link data in the table.
| Number of display lines | Specifies the maximum number of rows in a table without scrolling. You can also encourage scrollability by specifying a minority point. |
|---|---|
| display items | A separate window will appear when you click [Display Items]. Set the columns to be displayed in the table from the fields of the table specified in the data form I will do so. |
| column header | Check this box if you want to display column headers. |
| line header | When the field set at the top of [Display Items] is displayed as a row header Check. |
| line selection | Check this box if you want to select a single row when the table is pressed. |
table
Select this option if you want to directly specify the table name in the local database when tying data in a table.
| table name | Select the table from which to retrieve the display content. |
|---|---|
| Number of display lines | Specifies the maximum number of rows in a table without scrolling. A minority point can also be set to encourage scrollability. |
| display items | A separate window will appear when you click [Display Items]. Select the columns to be displayed in the table from the fields in the specified table. |
| column header | Check this box if you want to display column headers. |
| line header | When the field set at the top of [Display Items] is displayed as a row header Check. |
| line selection | Check this box if you want to select a single line when pressing down on the table. |
design
To set the color and shape of the table and the items to be displayed, regardless of style, change "Design". The table design can be set in detail.
Color and Shape
| font | Specifies font type. |
|---|---|
| Size | Specifies the font size. |
| bold-type | Check this box if you want to bold text. |
| image | Check this box if you want to add shadows to the text. |
| by return | Check this box if you want the text to wrap around. |
| Shrink to Fit | When the content does not fit within the control, the font size will be automatically adjusted to fit the content inside. |
| vertical alignment | The text position of the column header can be set to [Align Top], [Align Center Top], or [Align Bottom]. Select one of the following. |
| horizontal arrangement | The text position of the column header can be set to [Align Left], [Align Left], [Align Center], or [Align Right]. Select one of the following. |
| normal font | Specifies the font color during normal operation. |
| Normal Fill | Specifies the normal background color. |
| Normal ruled/box lines | Specifies the color of the ruled/framed lines during normal operation. |
| selection font | Specifies the font color of the selected area. If not specified, the color will be the same as the normal font color. |
| choice fill | Specifies the background color of the selected area. |
| Selection Ruled/Framed Lines | Specifies the color of the border of the selected area. |
| header font | Specify the font color of the header area. |
| Header Fill | Specifies the background color of the header area. |
| Header rules/frames | Specify the color of the ruled/border line in the header area. |
| even number line | Specifies the background color of even-numbered rows. |
| unavailable font | Specifies font color when operation is disabled. |
| unavailable fill | Specifies the background color when the operation is disabled. |
| Unavailable ruled lines/frames | Specify the color of the ruled/border line when the operation is disabled. |
| boundary line | Specifies whether to draw a border on the outer frame of the table. |
| vertical line | Specifies whether to draw vertical lines dividing cells. |
| horizontal line | Specifies whether to draw horizontal lines dividing cells. |
| ruled line margin | About the ruled lines that divide the cells, Specify the left, top, right, and bottom margins of the ruled cells. |
| Delimited line width | Specify the width of the line separating the header and detail sections. |
| line thickness | Specifies the thickness of the line. |
| roundness | Specify roundness. |
| thickness | Specify the thickness. |