build apps by user

Define Cell Properties (Input Pane)

The cells in Input Pane are used for entering and display data of a record entry. Like a worksheet that is the basic unit of an application, each cell in Input Pane is the basic working unit of a worksheet. Each cell holds a piece of data of the record entry. Apart from entering data into each cell, formulas can also be added to manipulate data between cells automatically.

Basic Properties of a Cell

Let’s define some basic properties of a cell.
input pane properties - basic cell properties
 Cell Caption
The display name of a cell.
 Row
The row position of the cell in Input Pane. It starts from 1, 2, 3, … etc
 Column
The column position of the cell in a row. It starts from 0, 1, 2, 3, … etc.
 Width
The width of a cell. The basic value is 1000. The characteristics of cell width varies with cell types. It is explained in the below section of Cell Type.
 Extended Widths
It is used together with  Basic/Extended Description   to change the cell width in different use cases. It is explained in this section.
 Compulsory
If True is defined, the cell that must have value. A warning message pops up if a Compulsory cell has no value on saving the entry.

Cell Type

In the worksheet, the cells are mainly divided into single value cell that holds only one piece of data, and multiple value cell that holds multiple rows of data. The content of an entry is composed of single value cells and multiple value cells. Let’s see how to define the properties related with cell type.
input pane properties - cell type and nature
 Single/Multiple
It defines the cell type of a cell. It can be a single value cell, a multiple value cell or a label.
Single/Multiple Description
1 Single value cell. Each cell holds one piece of data only. The cell widths of single value cells resize as the width of Input Pane changes. The default cell width is 1000. If you want to create a cell with double width, the value of Cell Width is 2000.
2 Multiple value cell. It is used to hold multiple rows of data. For example, a merchandising invoice involves multiple items, and all item name, description, price and quantity can use multiple value cells. The width of multiple value cell does not change as Input Pane resizes.
3 It’s also single value cell. Type 3 is different from Type 1 in that its cell width does not change as Input Pane resize. One use of it is to be the summary row of multiple value cells.
4 It is a label cell that display a caption in Input Pane only. It is not for input or display of data, and therefore no need to define associated table and field. It can be used as a display title of a section in Input Pane, or a help instruction that tells user what to do. The display caption is defined in  Default . More than one label can be defined in the same row, and the cell widths resize with Input Pane like Type 1 single value cell.
 Nature
It defines some special purposes for a cell.
Nature Description
FixedCol In multiple value cells, some cells may spread horizontally out of the visible screen in Input Pane. Define FixedCol in a column makes all columns in the left of that column (inclusive) remain fixed as the multiple value cells are scrolled horizontally.
WorkFlow When a cell is defined with Workflow, the background color changes to light blue. It indicates the cell is for entering data parameter that is used for importing data from another worksheet. A Workflow cell can select more than one value from Info Pane.
RowHead In multiple value cells, it let you define the left most column to be a row header. While a row header can be associated with table field or not, it can only display data but not entering data.
Button When a cell is defined as Button, the background cell color is changed to dark grey making it looks like a button. A Button cell is used for triggering of calculation formulas of the other cells, and not for entering data. In normal case, when the value in a cell is changed, formulas related with that cell is triggered automatically. In some use cases, you may want to trigger formulas only when a Button cell is pressed.
Countering When a cell is defined as Countering, a button is created on the cell. It is different from the Button cell above that it executes formulas defined in Countering for processing of data. In normal case,  Countering   formulas are executed after saving a record entry. In some cases, you may want to process data on demand by pressing Countering button.
Information It changes the background color of cell caption to yellow brown. Originally it is used to indicate a cell that is for displaying data only. Actually, you can use it as a way to highlight some cells to capture attention for any purpose.
 Input Box
One of the main purpose of a cell is for the input of data. There are different kinds of input boxes to facilitate usages for different purposes.
Input Box Description
Text The standard input box of a cell. It is a simple text box on the cell. It can be used for entering of data of any data type.
TextCmb When an input selection is displayed in the Info Pane, TextCmb is used. It helps select a value from Info Pane.
Memo When it is used, a large text box with several rows is displayed. It helps input of long text. It can be used in any data type of the cell field, not limited to be used for the Memo data type. Double-click the text box if you want to enlarge it.
TextMemo It begins with a simple text box with one row height only. You can enlarge it by double clicking it to turn it into a Memo input box.
TextRef When defined with TextRef, the cell is for display only and you cannot enter data manually on the cell. Display formula and calculation formula can still be used. You can display something in Info Pane for referencing or calculate a value in the cell.
Jump It does not allow stopping on the cell. It is therefore no use adding display formula on the cell. It acts as a way of quick navigation when some cells have no need to be stopped over.
File It let you select a file as the content of the cell. Only the path of the file is stored on the cell.
Camera It pops up a small window of camera for you to take picture which acts as the input of the cell.

Key Field and Sorting of Multiple Value Cells

There are 2 properties that are useful for multiple value cells.
input pane properties - key field and index
 Sort Index
In some cases, you may like to display the rows in multiple value cells in a specific order. You can define a index that has a sorting order on one or more fields. The index is created by adding Indexing function in Countering formula. If there is no special requirement, the default value is the same as  Main Index .
 DocNo
It defines the key field of the table used in multiple value cells. In normal use case, the key field name of the table of single value cells (main table) and that of the tables of multiple value cells (related table) are the same. In some use cases, you may want to relate the key field of main table to a field of different name in the table of multiple value cells.