How To Create A Customised Table In Kentico Cms That Is A New Feature In The Kentico Cms That Allows You To Store And Show Data In Tables?

 

The Customised Table is a new feature in the Kentico CMS that allows you to store and show data in tables. It works much like a spreadsheet with columns of data that you can sort and filter. This is very useful for organizing data and showing it in a clean and easy-to-read format, with the added bonus of keeping it up-to-date.

Create a Custom Table in Settings Account

In settings account, navigate to the Custom Tables tile and click "Create". The Custom Table will then appear on your dashboard and you can add fields to it. To add fields, either manually enter the field names or upload a CSV file with column headers.

Set the Table's Field Types

The table fields you choose in Settings Account will be available on the Customised Table when you edit it or add a new one. These include Text, Numbers, Predefined Choice List and Notes fields. For example, if you have an opportunity tracking system in your business, you might want to track its name, status, type (organic, new market, etc), owner, and forecast. You could even use multiple fields for each year of the forecast so that you have a clear view of how the opportunity has performed over time.

Make it sortable: You can customize how the table data is sorted by using the Sort button from the Table Tools > Layout menu. This will allow you to sort by a particular column, or select an individual cell and change the sort level.

Apply Filters & Segments: Once you have the table data ready to be displayed, select your metrics, dimensions, segments and filters. This will enable you to point Analytics to your table as the primary source of data for unsampled daily reports, which can be a great way to keep your analytics up-to-date and show your audience relevant data.

Display a Tiny Chart of Selected Columns: This feature lets you highlight specific numeric columns and add small charts to the table. You can use this to create sparklines or bar charts, for example.

Creating Custom Tables in the Survey Tool:

Customised Table Dubai Styles and Borders: The table layout can be customized in many ways, including font sizes, font styles, colors, and alignment. You can also change the background color or add a border to a selected row/column.

Use a table variable as the filter or exclude function: The table_var function takes an arbitrary number of string arguments that are column names on your custom table and informs how to sort rows that satisfy the filters provided to it. It will return the first row that satisfies the filter after applying ordering.

When the custom table is used as the filter or exclude function, it's important to ensure that all the column values in your table are filtered or excluded. This will prevent unnecessary duplicate data from being returned and will ensure that your results are accurate.

Conclusion:

In the Survey Tool, when you add a custom table question to your survey, you will see an additional option to create a CSV/Excel export. This is an important option as it will determine how your Custom Table question will be exported to Excel.