1 - Make your view filterable
When displaying a lot of data it can be useful to offer the possibility to filter your data on certain columns. In our example, we will add a category filter to sort classes by types and a date filter to sort them by starting date.
To achieve this, we will need to write "categoryFilter" and "dateFilter" in the relevant columns.
2 - Make your view prettier with keywords
Keywords can be an easy way to make your view more pleasant to browse. You can use them to display pictures, links or lists for example.
In our example, we would like to replace these ugly registration links by clickable buttons. We will use the following keyword : buttonType.
- Create a new column called "Register" filled with the text we would like to display in the buttons
- Add the keyword in the newly created referencing the link column. So here : buttonType(F)
- Update the data range in "Data Source" to include the new column. Ex : A1:G
You should get a similar result :