0

Dbgrid

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.

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 3 mths agoLast active
  • 33Views
  • 2 Following

Home