Dbgrid

updated 2 yrs ago

Description

The database grid (dbgrid) part is a limited-functionality part you can use to display in a grid straightforward text and numeric information from a table or collection. You can configure the presentation of the data in limited ways and make the rows selectable as part of a record selection application. This version of the part is primarily for use without a framework, in a form node, or in a form-include part.

For more advanced runtime controls using data types like html, filtering, custom buttons, and row totals use the Dbgrid3 part, which is accessible in the StarterAppFramework form-part menu list.

Use

The db_grid part can be used in the designer by clicking Insert data resource table when editing a form. Data from a collection or a table can be presented to the user with the db_grid part. Users can select data from the grid by selecting a record.

Editor Fields

Details Tab Options

Field Name	Description/Use	Type/Options	Optional/Mandatory
Table type	Selectable: This option lets you to show the user a table or list of information and have the user select an item from the table. Not Selectable: If you choose this option, the system presents the user with a table made up of the data you specify from a resource data table or collection, but the user is not able to click the information in the table.	Selectable \| Not Selectable	Mandatory
Data object	This is the name of the data object in which the system will store the value of the selected record.	Data Object	Mandatory
Group	If you have a lot of data objects, you can use this field to keep certain items together by creating a group using this field.	Text	Optional
Selection field	When type is 'Collection of fields: By clicking add, you select which columns from your data table or collection you want to store to the data object.	Text \| Table	Optional
Type	Number: Store the record's position in the data object as a number. Text: Store the record's position in the data object as text. Collection of fields: Select the column values to store in the data object when a record is selected.	Number \| Text \| Collection of Fields	Mandatory
Submit on select	By clicking this checkbox, they user goes to the next step when they make their selection. If you do not click this checkbox, the user makes their selection and then clicks Next to go to the next step in the logicnet.	Checkbox	Optional
Data location	Data table: This is the table in the Resources/Data folder from which you want to include data. Collection: This option lets you include data from a previously created collection.	Data Table \| Collection	Optional
Collection	This is only required when Data location = collection. Click the ... button to select the set of information from which to choose or provide the name of the collection.	Data Object	Mandatory
Columns	By clicking add, you select which columns from your collection you want to show in the grid. You can give the column a caption in the title field. Only when Data location = data table. Use the ... button to automatically load all the existing columns from the data table.	Table	Mandatory
Data source(s)	This is only required when Data location = data table. This is the data resources table you want to use in your logicnet. Click select to browse the existing data tables available.	Table	Mandatory
Selection	This is only possible when Data location = data table. With this option you get the Selection Editor, which allows you to specify which data you want to use from your resource data table. For example, if you want to use only those data entries for customers with the last name Smith, you create a rule for that here. If you want to use a data object from a collection, you also choose that here.	Statement	Optional
Page size	Use this field to specify the number of records you want on each page. If there are more records, the system will create page numbers for the user to browse through each page. Leave this field empty to display all records on one page if possible.	Number	Optional
Column sort	If you check this checkbox you allow the user to click on the column header to sort the data in that column.	Checkbox	Optional
Group by	With this item, you retrieve data from the data table based on a group specification. For example, if you have a table that lists both state names and city names, you can group the data by the state. If you want to know which states your users come from and two users from the same state enter information, you can group the data by state. If more than one user enters the same state, you will see a list of the states with only one of each state showing.	Table	Optional
Order by	With this field you can presort your information based on the columns you select. For example, in your list of states, you can sort the states alphabetically.	Table	Optional
Enable tooltips	If you check this checkbox the system will display the value of the cell in a tooltip when you hover your mouse over a cell. This can be useful when the value is too large to be fully displayed on the screen.	Checkbox	Optional

Style Tab Options

Field Name	Description/Use	Type/Options	Optional/Mandatory
Table Style
Width	This field allows you to specify the width of the table; for example, '50%'.	Percentage	Optional
Background color	This field allows you to specify the background color of the grid; for example, 'blue' or 'yellow'.	Text	Optional
Border width	This field allows you to specify the width of the border in pixels; for example, '3'.	Number	Optional
Border color	This field allows you to specify the color of the border; for example, 'blue' or 'yellow'.	Text	Optional
Border style	This specifies the style of the border as explained in http://www.w3schools.com/cssref/pr_border-style.asp.	Options	Optional
Cell spacing	This allows you to specify the space between the cells.	Number	Optional
Border collapse	Collapse: If you select this option the table orders are collapsed into a single border when possible (the system will ignore border-spacing and empty-cells properties.) Separate: If you select this option the system detaches the table borders (the system will not ignore the border-spacing and empty-cells properties). This is the default option.	Collapse \| Separate	Optional
Table Header Style
No header	If you check this checkbox the system will not show the table header.	Checkbox	Optional
Font color	This field allows you to specify the font/text color; for example, 'blue' or 'yellow'.	Text	Optional
Font size	This field allows you to specify the size of the font/text.	Number	Optional
Font weight	Normal: If you select this option the system displays the text in the default way. Bold: If you select this option the system displays the text as bold text.	Normal \| Bold	Optional
Background color	This field allows you to specify the background color of the table header; for example, 'blue' or 'yellow'.	Text	Optional
Border width	This field allows you to specify the width of the table header border in pixels; for example, '3'.	Number	Optional
Border color	This field allows you to specify the color of the table header border; for example, 'blue' or 'yellow'.	Text	Optional
Border style	This field allows you to specify the style of the border as explained in http://www.w3schools.com/cssref/pr_border-style.asp.	Options	Optional
Padding	This field allows you to specify the padding in pixels; for example, '3'.	Number	Optional
Text align	This field allows you to specify the position of the text as explained in http://www.w3schools.com/cssref/pr_text_text-align.asp.	Options	Optional
Table Cells Style
Background color	This field allows you to specify the color of the table cells; for example, blue' or 'yellow'.	Text	Optional
Font size	This field allows you to specify the size of the font/text.	Number	Optional
Font color	This field allows you to specify the color of the font/text; for example, 'blue' or 'yellow'.	Text	Optional
Border width	This field allows you to specify the width of the cells in pixels; for example, '3'.	Number	Optional
Border color	This field allows you to specify the color of the table cells border; for example, blue' or 'yellow'.	Text	Optional
Border style	This field allows you to specify the style of the cells border as explained in http://www.w3schools.com/cssref/pr_border-style.asp.	Options	Optional
Padding	This field allows you to specify the padding in pixels; for example, '3'.	Number	Optional
Text align	This field allows you to specify the position of the text as explained in http://www.w3schools.com/cssref/pr_text_text-align.asp.	Options	Optional

Advanced Tab Options

Field Name	Description/Use	Type/Options	Optional/Mandatory
Download data	By clicking this checkbox you allow the user to download the data from the grid in a .csv format.	Checkbox	Optional
Link caption	This field allows you to specify the name of the exported file. This field is mandatory if Download data is enabled.	Text	Optional

Example

Please download and import the following example project in your workspace.

Like Follow

2 yrs agoLast active
51Views
2 Following

cancel

Mention someone by typing their name

No matching users