Blog

Home / Blog / FileMaker / Playing with a Web Viewer Integration
12Dec 2016

Playing with a Web Viewer Integration

About the Author

Jeremy Brown Jeremy Brown

Jeremy is proud to be a FileMaker 12-15 certified developer. He has worked previously at a charter school network where he built the student information system used for three schools. As with many other developers, he stumbled into the world of FileMaker and has become fascinated with solving business needs in the platform. He is an amateur magician and is currently addicted to the game "Factorio".

Comments (6)

MF Leong - December 21, 2016

Great work, Jeremy.
On the Data Tables integration, it will be nice if you can add horizontal scrolling , adjust individual column width and dynamically drag-n-drop to change column position

Reply
    Jeremy Brown
    Jeremy Brown - December 21, 2016

    Thanks for the feedback.
    It is pretty easy to add the features you are thinking of. Check out the documentation from the source tab. There’s a specific option to add to the code to enable those features. In the next version of this library, I’ll add those as well.

MF Leong - March 30, 2017

I have a question regarding the sorting. When data first display in web viewer, it looks to me it is sorted by the ID or creation order. I may be wrong on this one. is there a way I can configure the default sorting order ? Thank you very much

Reply
    Jeremy Brown
    Jeremy Brown - March 30, 2017

    Hi.
    Are you talking about the data table? For sure the default sort can be anything you want. Look in the DataTables scripts in my file to see where the scripting goes to the people table and loops thru the records. Simply put a sort there by whatever you wish.
    The data should be presorted before it gets gathered for the table.

    You might also want to check the documentation of the integration. There might be a setting to determine which column is the default sort. I haven’t looked into this, but it might be in there.

MF Leong - March 30, 2017

Hi,

I can confirm that the default sorting is on ID. Even when I sort the data before it gets gathered, the display is always sorted by the ID. I will check the documentation. As you have said , there might be a setting somewhere to determine the sort order. Thank you

Reply
    Jeremy Brown
    Jeremy Brown - March 30, 2017

    Hi.
    I had a chance to look thru it today. You’re right: it is default sorting on the ID, which is column 0. I read thru the documetation and found this option:
    “order”: [[ 2, “asc” ],[ 1, “asc” ]]

    I put this inside the JS Function, specifically inside the: $(‘#example’).DataTable( { . . . function.
    This is sorting by last name and then first time.

    I hope that works for you. Good catch. I’ll add that to my code for the next (hopefully soon) updated release with new integrations.
    Thanks

Leave a Reply