If you are not happy with the results below please do another search
…ID’, title: ‘ID’, visible:false }, {data: ‘FirstName’, title: ‘First’}, {data: ‘LastName’, title: ‘Last’}, {data: ‘Title’, title: ‘Position’}, { data: ‘City’, title: ‘City’ }, { data: ‘State’, title: ‘State’ }, { data: ‘Country’, title: ‘Country’ } ] }); We’ve written a lot about DataTables. Find the posts here. DataTables has a great API that you can call to change something about the table. You can: Add more data Remove rows Change the column or…
…, and we’ll discuss those in the future. There’s one more method for using DataTables in FileMaker. For all my talking about using JavaScript in FileMaker, I’ve got a config file that will allow you to set up an integration without knowing any of the underlying JavaScript. Check that out here. Onward DataTables in FileMaker is one way we can innovate in FileMaker. We can provide a professional set of functionality to our clients. This functionalit…
…nfig The goal of this file was to give anyone the ability to implement the DataTables integration into their custom app. And the DataTables JavaScript library provides a heck of a lot of functionality for list views or lists of related records with no additional coding. You can set up a web viewer that shows related records with column sorting, go-to-related-records, column or row colors, filtering, etc. DataTablesConfig.fmp12 is a FileMaker file…
…as a whole lot more. If you need a lot of functionality in your list view, DataTables in JavaScript is the way to go. So here are the steps to set up a DataTables list. In the following examples, we will use the JSPlayground file from FileMakerDevCon 2019‘s training day as a place to set up what we need. Then we’ll explore extracting it from the playground file and placing it into your custom app. Let’s begin. Below are the steps we’ll walk throug…
…tanding.. You can download the file with the button below. It contains the DataTables & FM WebViewer Bridge exercise. Use this file to follow along with the videos below. (Click to Play) Jeremy begins this integration by simply initializing the table and making it ready to accept data. (The table isn’t yet drawn, but it will be) (Click to Play) Now that the table has been initialized, we need to tell DataTables the records we want it to show. Jere…
…r remove data or to change the type of graph. Charting Google Charts Table DataTables DataTables is a JavaScript library that takes your data and turns it into a table in a web viewer. The built-in features provide a lot of functionality out of the box, and the library can handle thousands of records.The DataTables library has been tested by thousands of users and is used many places throughout the web. It is a reliable library. Finance FinanceJS…
…good sense of how to work with any JavaScript library. C3 JS Integrations DataTables Integrations Work with the FM WebViewer Bridge In the final hours of the session (we were pretty brain-shot), we took a look at how to work with the FileMaker WebViewer Bridge. We saved the best for last. The functionality of this API works like magic and solves a lot of web viewer problems. We spent our time working with DataTables and the C3 Charting library (y…
…ath: A series of familiar FileMaker use cases and exercises in JavaScript. DataTables Config file: A demonstration of using DataTables without knowing any of the JS. You can create settings in a FileMaker record, and use those to create a configuration. DataTables: A list of all the blog posts we’ve done on this library. C3 Charts: Another charting library. The post provides a start and end file and steps on how to integrate. Audio Player: A cool…
…sorted the data using both position and Last Name (yes, that’s built into DataTables). I used a FileMaker popover, global fields, and a FileMaker script to add a new record. When the record was added: The new row immediately appeared The sort state did not change The record was added to the rows, there was no flash. We still loaded the new record into the web viewer, but we did so without resetting the web viewer. That’s the power of the FileMake…
…DataTables integration, Women of FileMaker fundraiser, and pickers! Topics DataTables Integration: The Complete Guide Not everything is a nail, but those things that are nails deserve a hammer. Jeremy Brown loves working with the FileMaker Web Viewer object and looks for reasonable opportunities to include some kind of integration in projects. He recently dove deep into the DataTables JavaScript library and learned a lot in the process. Jeremy wil…