Turn Off Date Filtering

  • Resolved fox3586

    (@fox3586)


    5 years, 12 months ago

    I have multiple data table including multiple date and non-dates. I notice that if the majority of the table is dates, all the rows including non-date cells are display as blank with the short code.

    I have tried a few adjustments from the jQuery DataTables pages without luck and also tried turning off Datables (class=”no-datatables”) but that didn’t work either.

    I have read in other topics that this plugin displays the data provided, but I can’t find what is making my date data show while making non-dates blank.

    My shortcode at the moment:
    [gdoc key=”XXXXXXX” use_cache=”no” query=”select A, M” datatables_dom=”lfrtip” datatables_paging=”false” class=”no-datatables”]

    Image of the Input and Output:
    https://photos.app.goo.gl/g747MHrh4WVvSzBJ6

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Meitar

    (@meitar)

    Fix the data in your Google Sheet? A column should only have one type of data. That’s how spreadsheets work.

    Thread Starter fox3586

    (@fox3586)

    All columns are text strings, however this plugin or DataTables is deciding the column is made of dates. Is there a way to inform the plugin that the data requested should be treated as a string?

    I agree that changing the data in my column would work – but as the data shows exactly what I want it to, I don’t want to change it.

    Plugin Author Meitar

    (@meitar)

    Is there a way to inform the plugin that the data requested should be treated as a string?

    As asked-and-answered previously, the DataTables’s columns.type option (the datatables_column attribute of the shortcode) is intended for that.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Turn Off Date Filtering’ is closed to new replies.