Group data in the FileMaker web viewer using DataTables by any column or data point and summarize the data

Grouping & SubSummaries

Grouping & SubSummaries | 

Learn how to use most of the features of DataTables with the context of FileMaker.

Build your own mechanism to fetch some of the data instead of the entire data set

Fetch Some Data

Fetch Some Data | 

Add background color, text color, or style to a column or a row depending on the value of any data point

Conditional Formatting

Conditional Formatting | 

Fetch all the data after DataTables loads, showing an indicator that data is being fetched

Fetching All Data

Fetching All Data | 

Refresh the table with new or edited records without wiping out the web viewer and refetching all the data

Refreshing the Data

Refreshing the Data | 

Build functionality to add additional rows of data to each row

Expanded Rows

Expanded Rows | 

Add buttons to a new column or a link to an existing piece of data

Adding Buttons & Links

Adding Buttons & Links | 

Add an image from the FileMaker table to a column

Adding Images

Adding Images | 

Add a new column with calculated data from the existing data, or update an existing column's data with some type of calc such as formatting

Performing Calculations

Performing Calculations | 

Use one code base but pass in different configurations that defines the columns, the look, the behavior, and other attributes

Multiple Configurations

Multiple Configurations | 

Make changes to the table without refreshing the web viewer 

Deep Dive on the API

Deep Dive on the API | 

Fixed Columns & Headers

Fixed Columns & Headers | 

Tap into the power of DataTables' styling possibilities by using other style frameworks

Custom Styling

Custom Styling | 

Build functionality to select one or multiple rows, get the selected rows, and pre-select some rows

Selecting Rows

Selecting Rows | 

Hide or show columns in the web viewer either statically or dynamically from FileMaker

Column Visibility

Column Visibility | 

Save all the attributes of a table and apply those when the user revisits the layout

Saving the Table's State

Saving the Table's State | 

Explore DataTables' ability to put in advanced filtering: either through column-specific filters or a "query builder" extension

Advanced Filtering

Advanced Filtering | 

Explore other random functionality of DataTables

Bits & Pieces

Bits & Pieces | 

Customize the look of as much as possible, getting to almost every part of the table, and learn how to find other ways to change the style

DataTables in Depth

What we will study