Table Block
Patrick avatar
Written by Patrick
Updated over a week ago

The Table Block will be your pillar of data organization and presentation at Frontly. It will be your essential tool for neatly arranging and displaying your data. Its versatility, readability, and structured layout makes it a format that will help your users to make sense of complex data, identifying trends and making comparisons to other data sources.


Basics

Label

A simple visual label that displays at the top of your Block container. Also used for your internal reference in the page builder.

Spreadsheet

Select the spreadsheet to display in your Block.

Columns

The Table block displays your spreadsheet data in rows and columns. The Columns can be customized in a few ways, including:
- Toggled on/off to show/hide that column

- Change the Type for visual display, with options like Image, Badge,

Layout Position

If you've selected a Layout for your page, you will see the Layout Position select dropdown. This setting determines which 'slot' in your Layout the current Block is located in. As you change the Layout Position, you'll see your block move around into different Layout slots.

Alternatively, you can add a new block to a specific layout slot by clicking on the slot directly.


Filters

Visible Filters

Give users the ability to filter the data in your Table with select dropdowns and other input fields.

Hidden Filters

If you need to limit the data a user can see in your app based on who is logged in, you can create a Hidden Filter using custom user fields.

With this simple feature, you can build a dynamic application that shows different data to different users, while keeping all data in a single sheet.

Example: Your company has three distinct teams accessing the same page, but you want them to only view the records that relate to their team.

Show Search Bar

If on, a search bar will appear in the filters area in the top of your Block container, allowing users to easily filter through the records using a keyword search.


Actions

Record Click Action

Define the functionality for when a user clicks on a specific record (row) in your Table. There are 4 options: Default Detail View, Custom Detail View, Custom Action, and None (no action).

Custom Action
When you choose the 'Custom' Record Click Action, you will see the Custom Click Action setting, allowing you to define a custom action to be triggered when a specific record (row) in your Table is clicked.

Show Create Action

If enabled, a button will appear in the top right corner of your Block container, allowing users to trigger a 'Create New Record' view where they can add new records to the spreadsheet linked to this block. Newly created records will appear in the Block immediately once created.

Row Actions

Define multiple custom actions to appear in a dropdown menu in each Table row.


Other Settings

Results Per Page

Determine how many results should show in the Table before displaying the 'pages' navigation at the bottom of the container, which allows users to move through the multiple pages of results, if any.

Record Label

Provide a label in singular format (Dog vs Dogs) to use in various text labels around your Block and related features. By default, if this setting is not configured, the generic term 'Record' will be used as a placeholder.

Examples using 'Project' as the Record Label:


Additional Resources

Click here to learn how to Adjust Table Column Types

Did this answer your question?