Hi there,

I would like to filter a table (Google Spreadsheet) to only show an array of row (1 - 46).

I couldn't see a way of doing this form within wpDataTables os added an extra column at the spreadsheet end and numbered the rows.

I then filtered this column in wpDataTables using a number range.  This worked, but the I then hide the column from the front end, the filter no longer has any effect.

Is there a way around this, or a better way to display an array of rows from a Google Spreadsheet?

I look forward to any thoughts or ideas.

Kind regards
James

Actually, I've just created a new table and dropped in the Google spreadsheet filter view url and this seems to work.

J

Hi Aleksandar,

In a final twist, the client has just said that they removed the unwanted rows in the google spreadsheet itself so, although I didn't solve the issue, it's resolved itself.

Please feel free to mark this as complete.
J