This section is still being updated. Some information might be incomplete. If you have any questions, feel free to drop us a message here.
The Run & Build button opens to a table view of your app. On this page, you can set up your table according to your specifications.
![App Builder – Table View App Builder - Table View](https://cdn.statically.io/img/wpdataaccess.com/wp-content/uploads/2024/05/table-view.png)
Table Builder #
The Table Builder opens up to a sidebar where you can customize the table view of your app. The Table Builder sidebar has three option tabs: Table – Columns – Theme, each with its group of settings.
Changes and configurations appear in real-time on your table as you set them, but you still need to save your settings to finalize your changes.
![App Builder – Table Builder Tabs App Builder - Table Builder Tabs](https://cdn.statically.io/img/wpdataaccess.com/wp-content/uploads/2024/05/msedge_sUkI9tUJjD.gif)
List of Table Builder Settings #
Table Tab # |
|
Large Table Support | Opens options available for large tables including row estimations, search field behaviors, paginations, and more. |
Pagination | Opens options related to pagination buttons. |
Global Search | Expands to options related to the general search behavior of your table. |
Column Filters | Column filters can be enabled, or set up to load upon table startup. More options include filter positioning. |
Row Actions | This is where you can enable or disable row actions for your rows such as allowing insert, view, update, or delete. |
Bulk Actions | Bulk Actions offer options that enable export to selected file types such as PDF, CSV, JSON, Excel, and XML. You can also enable Bulk Delete in this section. |
Default WHERE | Set a Default WHERE to your table. This field accepts valid SQL statements only. Click on the (show examples) link to see example statements. |
Default ORDER BY | Choose a sort order based on a column. |
Language | Choose a default language for your table elements. Data and Column titles are not affected. |
Responsiveness | Offers two options to accommodate table responsiveness. |
Density | Sets a default density to your table. A button to change density is enabled by default. You can disable this if you don’t want users to change density. |
Inline Field Settings | Contains design options for inline fields when they’re enabled. |
Columns Tab #
The Columns tab lists your table’s columns. Each column expands to a list of available configurations based on column types.
![Table Builder – Columns Tab Table Builder - Columns Tab](https://cdn.statically.io/img/wpdataaccess.com/wp-content/uploads/2024/06/Table-builder-columns.png)
Per Column Options # |
|
Width | Set a width for your column. |
Column Settings |
Expands to show the following options:
|
Column Actions |
Expands to show the following options:
|
Lookup | Contains the button to start the Lookup Wizard. This option is only available for string and numeric data type columns. |
Aggregations | Allows aggregations on a column. This option is only available on numeric data type columns. |
Column Metadata | Displays the column metadata. |
Computed Field #
You can add a computed field based on calculations generated from other fields. Click on the (show examples) link to see examples of computations you can use. Code MUST return a valid JavaScript expression.
References: JavaScript Expressions (flaviocopes.com)
![App Builder – Computed Field App Builder - Computed Field](https://cdn.statically.io/img/wpdataaccess.com/wp-content/uploads/2024/04/msedge_6RtY4D0zTi.png)
Theme Tab #The Theme tab contains several options to personalize and design your table. |
|
Font |
Expands to show the following options:
|
Palette | Expands to show a color palette selector. |
Layout |
Expands to show the following options:
|