The time barrier
But I do realize that there are barriers to the language for us FileMaker people. I asked a question about this a couple of weeks ago. Most people responded with ‘time’. They simply don’t have time to learn the language. I think that is more of a perception than reality, but I acknowledge that idea. My training session will work to break down that barrier, by the way.
Introducing DataTables Config
Gettin’ you hooked
Features of the DataTables config file
There’s too much to explain in detail here in a blog post, so be sure and check out the video that walks you through the app. But here are some highlights of its features.
- DataTables comes with a lot of default features and options. If you don’t want to customize your implementation, you can generate the default code quickly.
- You can add or remove features and options using the FileMaker data fields and UX provided here.
- There are detailed examples of how to format the text you wish to put in. For example, if you choose to have your default table sorted by column 3, you can choose the ‘order’ option and then pass to that option the following text: [2, “asc”] (this is a 0-based index). That’s easy enough to type, don’t you think?
- You can add additional extensions to your implementation, functionality that makes the integration more complex. Such as something that looks like a sub-summary report (grouped records) in little time.
- There’s plenty of help and descriptions of the features.
- You can (and should) map your fields to this config, and you can describe how each column should behave.
- You can add a callback function (Run a FileMaker script when you click on a row) and even assign a column to use in the search.
- You can set this file up to be a module, a separate file next to your custom apps and link to it. This action allows you to use the code stored here to display the data.
- Give some basic custom styling to the table.
There’s so much more that can be done, and we’ll explore Extensions, custom CSS, and calling FileMaker scripts in later posts and videos.
FileMaker Integration: Give it a try
I strongly encourage you to give it a try. Play with it, mess it up, do all sorts of stuff to it and figure it out. I promise it will not take hours and hours (maybe one or two). It won’t be a huge drain on your life.
Feel free to reach out at firstname.lastname@example.org with questions if you wish. I can answer some questions, or we can set up an implementation package to do some custom development with this configuration in your custom app.
Let me know how it goes.