Properties depend on your widget type. Tables are one the most used widget. They allow you to make sure you have exactly the data you need before you convert your widget into another widget type.
The Properties tab in a table widget allows you to view and modify information based on the data set defined at the widget creation.
Besides the options in the properties tab, you can also further customize your widgets by adding Filters to your widgets or by adding calculated values.
You can modify the following information in the Properties tab:
Columns
The columns section lets you determine which columns will be displayed in your table and their order also defines the display order in your widget.
You can reorder the column by clicking the positioning bar on the left hand side of the column and dragging it to a new location.
You can add columns as needed by clicking the + Add Column in the Columns section.
You can remove columns by clicking the (-) Delete column icon on the right hand side of the column you want to remove.
The different columns you can add are divided by categories specific to the form you previously selected. It is possible to have the same column name from two different categories (e.g., a communication date and a grievance date).
You cannot select columns from more than one relation.
If you added a calculated value, you should also add a column with your calculated value in order to display it in the widget. The calculated value will always appear at the start of the list.
Sort column
You can use sort columns to display data in ascending or descending order.
You can add a sort column by click the + Add sort column in the Column section.
Select the value from the Sort column drop-down list and then select the value from the Sort order drop-down list.
You can add several sort columns but their order defines the priority of the sorting process.
You can reorder the column by clicking the positioning bar on the left hand side of the column and dragging it to a new location.
Maximum number of records to display
After adding a Sort column, you can specify the Number of records to display to limit the amount of data appearing in the table.
For example, if you select Descending for your Sort column, and you specified 10 in the Number of records to display, you could create a top 10.