Visual Composer drag&drop page builderVisual Composer integration and how to add tables in the WordPress visual editor
WPBakery Visual Composer has became a “standard” of sorts in the world of WordPress. It is a powerful, but extremely easy to use drag&drop page builder that allows a user to change standard page layouts. It can be used without any need for coding, or even for shortcodes of elements such as accordions, buttons, multi-column blocks, headlines, message boxes, pie charts, and other useful UI elements that are not available in WordPress by default. Visual Composer comes bundled with most modern themes on ThemeForest, and even this site was built using this powerful tool.
wpDataTables can be integrated with Visual Composer. You can insert tables and charts you’ve created with wpDataTables onto your pages using the Visual Composer interface. The only thing to note here is that you should build your tables first (with “Table Creation Wizard“) before inserting them in any page you create with Visual Composer.
If you open the Visual Composer back-end editor after wpDataTables installation you will see two new buttons in the “Add element” Visual Composer popup:
Adding a wpDataTable to a pageHow to add a wpDataTable in a page that you create with Visual Composer
If you click the “wpDataTable” button, you will see a table configuration popup with two tabs. The first tab contains a dropdown with the list of the wpDataTables that you previously created:
The second tab contains three inputs from which you can configure variable placeholders for your table:
Please refer to this documentation section to see what these placeholders are and how they work.
When you choose the table, and pick the table view, you can click the “Save changes” button and Visual Composer will store the data. You can see the wpDataTable block, and the name of wpDataTable that was chosen on previous step:
You can insert the table inside another Visual Composer element: column, tab, accordion, etc.
If you click the “wpDataChart” button, you will see the popup with a list of charts that you created (using the Chart Creation wizard):
You can choose a chart, and when you click “Save changes” it will be inserted in your page. You can also insert the charts in other Visual Composer elements, e.g. row columns, tabs, etc.:
When you save the page, the wpDataTables and wpDataCharts are inserted as you configured them in the Visual Composer:
- Creating editable tables and filling the table data manually
- Creating non-editable tables from Excel files
- Creating non-editable tables from Google Spreadsheets
- Responsive design
- Conditional formatting
- Sorting tables
- Per-column filtering
- Pre-filter tables through URL
- Row grouping
- Using Placeholders – Adjusting MySQL queries dynamically based on shortcode attributes
- Calculating totals (sum row)
- Table layout and word wrap
- Table data export tools