If some of the columns that you have in the input data source shouldn’t be visible to the front-end users, you can easily hide them. There are two ways to do this:
First would be to click on “Column settings” buttons which you can find in header of every column in “Table preview and columns setup” section.
Column settings modal will open and, under “Display” tab, you can find “Visible on front-end” option.
Second way of doing this would be to click on “Complete column list” button to open a modal where you can quickly access some column settings.
In the modal you can click on show/hide icon to toggle visibility for each column.
Columns hidden by unticking of “Visible on front-end” checkbox or clicking the “Show/hide the column” will not be displayed to the front-end users.
Please note a couple of things about column visibility:
- Invisible columns are still passed to the front-end. It means that if there are a lot of invisible columns, they will load the page without need. So if you don’t need that data in the front-end at all, it’s better to delete these columns in the data source when possible.
- Invisible columns can be used for filtering. If the advanced filter is enabled, and is rendered in the form, or a widget, the filter can also use the data from invisible columns. Please see this documentation section for details.
- Creating editable tables and filling the table data manually
- Creating non-editable tables from Excel files
- Creating non-editable tables from Google Spreadsheets
- String columns
- Integer columns
- Float columns
- Date columns
- DateTime columns
- Time columns
- Image columns
- URL link columns
- E-mail link columns
- Currency/price columns
- Formula (calculated) columns
- Coloring and styling columns