In this article, we will explore the various settings that can be customized for data tables.
Adjusting table settings of a data table can greatly impact how your data is presented in the Builder. Here, we will delve into the key aspects of these settings.
/Table%20Settings/tablesettings1.png)
Tip: To learn more about working with tables, see our article here.
Where can I access table settings?
Table settings can be found by selecting the down arrow icon to the right of the table's name in the Data section of the Builder:
/Table%20Settings/tablesettingsgif.gif)
Settings
Let's examine each setting and how it can impact your data presentation:
Table Name
The table's name is exactly what it sounds like. Here, you have the flexibility to change the name of your data table to ensure clear and effective identification of your data.
Ensuring the table name is clear and concise is essential for easy identification by other builders working with your data.
Display Field
By default, the display field will be the first field listed in the table's Fields view.
The display field is the field that you would like to be used to identify records. This field is used throughout the application when these records are displayed in connection fields for this table.
Tip: Ensure that the display field is easily recognizable, such as a name field, to facilitate quick identification. Avoid using auto increment fields and "ID" fields as they may not be as easily identifiable by their numerical codes.
Sort Order
This setting is for the default sort order of the table. Depending on the field type you select here, you will have different options to choose from in the dropdown selection to the right of your field selection.
Note: Table sorting preferences do not apply to records displayed in a view in any manner. Sorting on a table only applies to record sorting in the Builder and for drop-downs used with the table in a connection field.