Table of Contents
You can use this page type to add .
Change page settings
If you want to change the settings of a page, click on the corresponding cogwheel symbol in the navigation bar.
When editing table pages, you can make numerous page settings to tailor the displayed data from the underlying table precisely to a user group.
Preset filters, sorting and grouping
You can define preset filters, sorting and grouping in the page settings to limit and organize the displayed data for a user group.
To do this, click on Add filter, Add sorting or Add group, select the desired column and condition and confirm with Submit.
With the view options above the table, app users can remove existing groupings and sorting or make additional settings.
Hidden and read-only columns
In addition to the preset filters, you can also define hidden and read-only columns to further restrict the visibility and editability of certain data.
Simply click on the sliders or boxes of the columns that should be hidden or read-only for the users.
You can recognize write-protected columns by the fact that they are highlighted in grey in the table and marked with a lock symbol.
Link column settings
In the settings for the link column, you can define which data is visible and which operations are permitted for each linked table.
- Allow adding new entries: If you activate this slider, users can add new entries to the linked table. You can use the field settings to define which columns are visible and which columns are required, i.e. must be filled in.
- Allow linking of existing entries: If you activate this slider, users can link existing entries in the linked table. You can use the field settings to define which columns are visible.
- Limit links to a maximum of one row : If you activate this slider, users can only link to one row of the linked table in the cells of the link column.
- Preset filters: If you add a filter here, only options that fulfill the filter conditions will be displayed when linking entries.
- Activate big data function: If the big data function is activated, users can search through more than 20,000 data records, provided there are this many entries in the linked table.
Prevent duplicates from being added
On table pages where different users can make new entries in a base, it is easy for identical rows to be created. You can prevent this by preventing duplicates from being added. To do this, activate the corresponding slider and select the columns in which the values must match for an row to be considered a duplicate. If the addition of an row is blocked, a corresponding error message appears.
Format check for new entries
You can activate another slider to validate entries in text columns . As soon as the format check is switched on, the row details always open when someone wants to add a new entry to the table page - and this is only possible if the entries correspond to the defined format. An error message appears for entries with a different format.
For example, you can minimize typing errors for clearly defined character strings such as zip codes or account numbers. You define the regular expressions for validating the entries when you create a text column in the base.
Show cell formatting
If you use the coloring of cells in the underlying table, you can activate the option to display the cell formatting on the table page with one click.
Export table page as Excel file
This function is disabled by default. If you want to enable Excel export, activate the corresponding slider in the table page settings. All app users who have access to the table page can then export the visible data as an Excel file. To do this, click on the three dots in the view options and then on Export to Excel.
The data exported from the table page is independent of the current view. Even if you filter or hide columns, all data is included in the export.
Page authorizations
In the page authorizations , you can set exactly who is allowed to view and edit the table.
