Back to contents

JetEngine: Tables Builder Overview

 

This overview will describe the general settings of Tables Builder and how to use it.

From this tutorial, you’ll learn how to create and customize Tables Builder from the JetEngine plugin. With Tables Builder, you can get the data from the previously created Query dynamically, fetch a sample of the data to find all possible columns, and preview the table. Also, you can display the table with the help of the Dynamic Table widget in Elementor and Gutenberg. 

Create a Query

The first thing you need to do is to go to JetEngine > JetEngine > Modules > External Modules, and enable the Dynamic Tables module.

The next thing you need to do is to create a Query with Query Builder
In our case, we’ll create a Posts Query for the post.

Tables Builder Overview

After you’ve enabled the Dynamic Tables module, you’ll see the Tables Builder block in the JetEngine dashboard. Let’s have a closer look at it. 

General settings 

  • Name. Here you can add the name of the Custom Content Type that will be shown in the admin menu;
  • Data Query. In this field, you need to choose the query you’ve created before with the Query Builder. No worries if you didn’t create it. There’s always an opportunity to create a new query or edit the existing one; 
  • Fetch the data. Fetch a sample of the data to find all possible columns and preview the table.
NOTE!
Don’t forget to click on the “Re-fetch Data” button when you change the post type in the Data Query field.

Columns

In this block, you can add the needed columns for your table. It works similarly to the meta fields.

  • Column Name. The column name is displayed in the table heading;
  • Column Content. Here you can choose the type of content that will be displayed in the column. There are two options: “Raw Value” and “Template”.

If we choose the Raw Value, then there will be an opportunity to choose the Data Source for the current column, such as Fetched Column, Post/Term/User/Object Field, and Meta field. Let’s have a closer look at each of them. Fetched Column. Here you can select a column from previously fetched columns.

You can also enable the Filter Column Output toggle if you need to choose the Callback function to filter the column value.

If you enable the Customize Column Output option, then you can output the format.

NOTE!
Fetched Column doesn’t work with WooCommerce because it has another structure and can’t get data from the database.

Post/Term/User/Object Field. Select a field from the current object to show in this column.

Meta Field. Select meta field from JetEngine fields to show in this column. 

If you choose Template Column Content, then you’ll be able to choose the template to use as the base template for current column items.

Table Styles

In this module, you can adjust the width and set the alignment for the table. 

NOTE!
Table Styles that you’ll add in this module will override styles in the Dynamic Table widget.

You can always preview the result if you click on the “Reload Preview” button. 

Dynamic Table widget in Elementor

There’s an opportunity to display tables on any page with the Dynamic Table widget. Go to the needed page and click on the Edit with Elementor button. Search for the Dynamic Chart widget and add it to the page. Let’s have a closer look at it.

In the Table field, you need to select the table we’ve created before. Also, you can show column names in the table header and footer, and allow horizontal scroll that is quite user-friendly. 

Moreover, there’s an opportunity to style the table. Don’t forget, that if you want to style the table only in the widget, then you need to remove styles on the backend. Styles on the backend override widget’s styles. What is more, styles in the widget will apply to the whole table, not the separate column.

Dynamic Table block in Gutenberg

You can also add the Dynamic Table widget in Gutenberg. Open the needed page, click on the plus icon,  and search for the Dynamic Table widget. 

After that, you can simply add the widget to the needed section. In the widget’s settings, you’ll need to choose the Table you’ve created before.

Now let’s have a look at the result. Below we can see our posts in the table view.

Congrats! Now you know how to use Tables Builder functionality from the JetEngine plugin.