Preselecting Columns

  • Resolved Lady Phoneix

    (@lady-phoneix)


    11 years, 7 months ago

    I am trying to publish a paint conversion chart to convert hobby paint manufacturers codes from one brand to another.
    Unfortunately there are so many brands that the width of the date makes the page look awful.

    Im aware that the user can select columns using the show/hide columns (Which is an excellent feature) but is there any way to preselect the columns so that the data is more compact

    For example, lets suppose we have 10 manufacturers listed from 1-10

    The data is preselected to show manufacturer 1 and 2 but hide 3-10

    The user can then, for example, turn off manufacturer 2 and turn on manufacturers 5 and 9.

    Any help appreciated, other than that this seems an excellent plug in and I can certainly get some good use out of it

    https://ww.wp.xz.cn/plugins/inline-google-spreadsheet-viewer/

Viewing 1 replies (of 1 total)
  • Plugin Author Meitar

    (@meitar)

    11 years, 7 months ago

    If I understand correctly, you want to know how to show/hide columns programmatically when the table first loads? As described in the DataTable docs I just linked, you’ll need to use some JavaScript to customize the display of your table; a good place to put your custom JavaScript code is in your blog’s active theme (or a child theme if you don’t have one already).

    If you are certain you don’t want to show a specific column or set of columns at all, as in, to make sure they will never load in the HTML of your page, you can use the query parameter in the gdoc shortcode this plugin provides to preprocess your table with a SQL-like syntax described by Google here.

    Hope this helps. 🙂

Viewing 1 replies (of 1 total)

The topic ‘Preselecting Columns’ is closed to new replies.