Page History

Panel

borderColor	green
borderWidth	1
titleBGColor	#ddffcc
borderStyle	solid
title	Definition

List Grid is best described as a 表单表格 but with the capability to add in new records from a Data List.

...

Figure 1: Screenshot highlighting List Grid in Form Builder

列表表格 最好被描述为表单表格，但是能够从数据列表中添加新的记录。

Panel

borderColor	purple
borderWidth	1
titleBGColor	#ddccff
borderStyle	solid
title	New Feature

New feature added in Joget Workflow v6.

Paging
Delete Options
Multiple Lines Format Type

Image Added

图1：在Form Builder中突出显示列表表格的屏幕截图

修改了表单在 Modified the form in http://localhost:8080/jw/web/console/app/crm/1/form/builder/crm_contact

Image Modified

Figure 2: Screenshot highlighting adding new records using List Grid in Form图2：突出显示在表单中使用列表表格添加新记录的屏幕截图

Image Modified

Figure 3: Screenshot highlighting new records added in List Grid in Form

Image Removed

Figure 4: List Grid Properties

图3：突出显示添加在窗体中的列表表格中的新记录的屏幕截图

Image Added

图4：列表表格属性

名称

描述

ID

元素ID（通过声明为“account”，将创建相应的数据库表列“c_account”）

Label

元素标签显示给最终用户。

Data List

数据列表

Columns

这里定义的列必须对应于上面选择的数据列表。

Name

Description

ID

Element ID (By declaring as "account", a corresponding database table column "c_account" will be created)

Label

Element Label to be displayed to end user.

Data List

Data List to display for selection.

Columns

The columns defined here must be correspondent to the Data List chosen above.

Name

Description

Value

Field ID of the target form.

Example:

In "Account" form sourced in the Data List "Account Listing", there are Form Elements with the ID "id", and "accountName".

Label

Column Label.

Editable

Yes/No

目标表单的字段ID。

例：

在数据清单“Account Listing”中的“Account”表单中，有ID“id”和“accountName”的表单元素。

Label

列标签。

Editable

是/否

Format Type

如果你想格式化返回的值，你可以使用格式类型。

默认选择：文本。

可用的格式类型

Text -将文本格式的值设置为文本
HTML - 以HTML 格式输出数据
Multiple lines text - maintains the spacing formatting for multiple lines text, such as TextArea.
Date - 格式为日期。“ Format”字段中应包含原始日期和新的日期格式。
Panel
borderColor blue
borderWidth 1
titleBGColor #ddffcc
borderStyle solid
Format: [KB：输入格式] | [KB：输出格式]
使用示例：
原始值：2012/5/23
预期值：2012年5月23日
格式：M

Format Type

If you would like to format the returned value, you may make use of the format type.

Default choice: Text.

Available Format Types

Text - formats the value as text
HTML - outputs data as HTML
Date - formats as date. Original Date and New Date formats are expected in the "Format" field.
Format: [KB:input format]|[KB:output format]
Example of usage:
Original value: 5/23/2012
Expected value: 2012/5/23
Format: M
/d/y|y/M/d
Note: Please refer to
注：日期格式请参考Java SimpleDateFormat
for date format.
。
Decimal - - 格式为十进制。预期在“ Format”字段中的小数位数。
File - 显示值作为附件的链接。在“ Format”字段中预期form def ID。
Image - 将该值显示为附件的缩略图。在“Format”字段中预期form def ID。
Options - Show the label of multiple choice element given the value given. Form Def ID
formats as decimal. Number of decimals is expected in the "Format" field.File - Show the value as a link to the attachment. Form Def id
is expected in the "Format" field.
Image - Show the value as a thumbnail of the attachment. Form Def id is expected in the "Format" field.

Format

Depending on your chosen Format Type, additional argument may be entered here.

Info
title Expected Form Def ID
Specify the Form Def ID that contains the actual Select Box / Radio / Check Box form element.

Format

根据您选择的格式类型，可能会在此处输入其他参数。

Width

列宽以字符为单位

Width

Column width in characters.

Code Block

title	Sample

200px

Image Added

Image Removed

图5：列表表格属性 Figure 5: List Grid Properties - UI

Name名称

Description描述

Enable Sorting Feature

Determines if ordering of rows is to be enforced.确定是否强制执行行的排序。

Field ID for Sorting

Field to keep the ordering sequence; must correspond with a field id in the target form.字段保持排序顺序; 必须与目标表单中的字段ID相对应。

Insert Button LabelInsert Button Label

插入按钮标签

Form to Edit Row

After addition of row, user may edit the record row by opening it in the Form defined here.在添加行之后，用户可以通过在这里定义的表单中打开它来编辑记录行。

Form Submit Button Label (Normal Mode)

Label of the Submit button in normal mode.正常模式下的提交按钮的标签。

Form Submit Button Label (Readonly Mode)

Label of the Submit button in read-only mode.提交按钮的标签处于只读模式。

Display field as Label when readonly?

Readonly

Determines if the element is editable.确定元素是否可编辑。

Disable Add Feature

Determines if a new row can be added.确定是否可以添加新行。

Disable Delete Feature

Determines if a row can be removed.确定是否可以删除一行。

Delete confirmation message

Confirmation message

when deleting a row.删除一行时的确认消息。

Show Row Numbering?

Show additional column on the leftmost to denote numbering

在最左边显示附加列来表示编号。

Paging Size

Items to be displayed per page.

Popup Dialog Height

Height in character字符高度

Code Block

title	Sample

500px

Popup Dialog Width

Width in character

Code Block

title	Sample

90%

Image Added

Image Removed

Figure 6: List Grid Properties - Validation & Data Binder

图6：列表表格属性 - 验证和数据绑定器

名称

描述

Validator

附加一个Validator插件来验证输入值。

Name

Description

Validator

Attach a Validator plugin to validate the input value.

Info

title	When will validation takes place?

Validation will takes place whenever form is submitted except when it is submitted as "Save as Draft".除非提交表格为“另存为草稿”，否则将在提交表格时进行验证。

Unique ColumnColumn/

Field ID to identify record ID.列/字段ID来标识记录标识。

Min Number of Row Validation (Integer)

最小行数验证（整数）

Min

Max Number of Row Validation (Integer)

Error Message

Error message to be shown when row requirements set above is not met.

Load Binder

Option by default. Grid data will be saved/loaded in JSON format in its defined database cell.

Store Binder

Option by default. Grid data will be saved/loaded in JSON format in its defined database cell.

Image Removed

Figure 7: List Grid Properties - Advanced

最大行数验证（整数）

Error Message

当不满足上述行要求时，将显示错误消息。

Load Binder

默认选项。表格数据将在其定义的数据库单元中以JSON格式保存/加载

Store Binder

默认选项。表格数据将在其定义的数据库单元中以JSON格式保存/加载

Delete Associated Grid Data?

If the popup form have grid element(s), this option will delete the inner grid data.

Panel

borderColor	#ffa700
borderWidth	1
titleBGColor	#ffdb99
borderStyle	solid
title	Caution

These 3 options: (Delete Associated Grid Data, Delete Associated Child Form Data, Delete Files), in combination, does apply to nested grid/child elements.

These options traverses the entire form tree. Upon encountering a 'false' condition, it will move on to the next grid/child element.

Example: Consider that the popup form has a form grid, form grid has a subform, subform has a file upload element with abc.pdf. If all options are checked, abc.pdf will be deleted. If all except ONE of the option is checked, abc.pdf will NOT be deleted.

Delete Associated Child Form Data?

If the popup form have child element(s), this option will delete the child data.

Panel

borderColor	#ffa700
borderWidth	1
titleBGColor	#ffdb99
borderStyle	solid
title	Caution

These 3 options: (Delete Associated Grid Data, Delete Associated Child Form Data, Delete Files), in combination, does apply to nested grid/child elements.

Delete Files?

If the popup form contains file upload element, this option will delete the actual uploaded file(s).

Panel

borderColor	#ffa700
borderWidth	1
titleBGColor	#ffdb99
borderStyle	solid
title	Caution

These 3 options: (Delete Associated Grid Data, Delete Associated Child Form Data, Delete Files), in combination, does apply to nested grid/child elements.

Abort Related Running Processes?

If there are process instances related to the deleted row, this options will abort those process instances.

Image Added

图7：列表表格属性 - 高级

名称

描述

URL Request Parameters for Datalist

通过在此处定义过滤条件来优化目标数据列表选择。

名称	描述
参数	目标数据列表过滤器参数名称
字段ID	当前表单元素字段ID
默认值	搜索参数的默认值

Name

Description

URL Request Parameters for Datalist

Refine the target Data List selections by defining the filter criteria here.

Name	Description
Parameter	Target Data List filter parameter name
Field ID	Current form element field ID
Default Value	Default Value for the search parameter

Page tree

Versions Compared

Old Version 1

New Version Current

Key