Pull data from only visible columns

Pull data from only visible columns

thegamechangerprothegamechangerpro Posts: 81Questions: 30Answers: 1

Hi there folks!

I am attempting to sort of recreate the "csv or excel" extend functions:
I am using datatables in a webviewer and those two are not quite working as I had hoped.

I only want to collect data from inputs from the filtered/found rows and visible columns.
I can get the below to work without issue, but as soon as i try to only collect data from visible columns only, I run into issues.

Does anybody have any tips or pointers they could pass my way?


className: "fa-regular fa-file-export",
text: '<span style="font-size: 11px; font-family: Arial, sans-serif; margin-left: 11px;">Export found rows</span>',
action: function(e, dt, node, config) {
var table = $('#table').DataTable();

    // Get filtered data
    var filteredData = table.rows({ search: 'applied' }).data().toArray();

    // Convert the array of objects to a JSON string
    var jsonString = JSON.stringify(filteredData);

    // Use FileMaker.PerformScript to call the script
    FileMaker.PerformScript('getData', jsonString);


This question has an accepted answers - jump to answer


Sign In or Register to comment.