Welcome to the multi-part video series that will teach you how to implement DataTables in your Claris FileMaker Pro solutions effectively. If you’re new to this series, we recommend starting from the introduction to maximize your learning experience. You can access the complete series here: Master DataTables with Claris FileMaker Pro.
In the previous post, we examined DOM elements. The settings that drive the searching, pagination, and other important customizations your users will utilize when interacting with the reports you build.
In this post, we will discuss the native searching feature in DataTables. Specifically, we will learn how to use and control the search (or filter) option in your DataTables report.
Controlling Search Appearance
As we will learn about all the DOM Elements in this series, there are two main approaches to controlling the appearance of an element in your report. We can toggle the search box on or off, affecting its presence when we preview the build.
Option 1: Modify the DOM Elements
We can control whether the search box appears on the report by modifying the values we set for DOM elements.
The default DOM arrangement is constructed like this:
If we want to prevent the user from being able to search on this report, we can remove the ‘f’ (filter):
Option 2: Control the JS Function’s settings
We can also disable searching for specific reports. We can also disable searching for specific reports. Even if the DOM element enables filtering (example: lfrtip), we can toggle the search feature on or off in each report’s settings.
The syntax that appears in the DataTables settings would appear like this:
Granular Search Control
The native search capability is often a reason why DataTables is utilized in a solution. However, there are times when including the search feature is necessary, but excluding specific columns of data is needed. Fortunately, search behavior can also be controlled on a column-by-column basis.
The same approach we used to toggle the search feature on or off for the entire report can be utilized on individual columns in your report. By default, the DataTables Builder constructed each column in the report to be searched upon, searchable: true. By modifying this setting to searchable: false – we exclude that column’s data from being included in the user’s search.
The demo file (see bottom of blog post to download) allows us to practice the various options for hiding or displaying the search feature and how we can modify column attributes to change search behavior.
In the video tutorial, I demonstrate practical search scenarios using the data in the demo file.
Multi-part searches are explained, where spaces can be used to filter data across multiple columns. DataTables uses a “subtractive method”, where consecutive searches narrow down the found set of records.
Using Search for Data Insights
It is important to know how the search feature works. Educating users on multi-part searches and other features can help them make the most of the search functionality.
Besides the obvious, searches can be performed to gain insights without creating complex relationships, scripts, or static reports. An example of this ad-hoc reporting approach is illustrated in the video. With proper training of the DataTables search feature, we can empower users to find answers to their questions.
The lessons in this series explore individual DOM elements in detail and how to customize and manipulate them even further.
In the next post, we cover pagination or the ‘p’ DOM element. We will learn how to control its visibility, placement, and styling options to enhance the navigation requirements of your report.
Join the Training Series Now
Subscribe to our YouTube channel to keep up with the video training series. Comment on the YouTube videos to interact with us and share your thoughts and questions. Also, don’t forget to join our mailing list for updates on new videos and additional resources.
Jody has been working with Claris FileMaker for over 19 years in various industries. She has a Masters in Business Administration and has worked in several “Analyst” roles over the years, always leveraging the power of Claris FileMaker along the way. She lives in central Minnesota, the Land of 10,000 lakes, with her husband, three teenagers, and a sweet English Cocker Spaniel. When not at work, you can either find Jody at her kid’s sporting events, coaching her daughter’s basketball team, or appreciating the outdoors.