Spreadsheet filters vs. query

  • Resolved Martin Sauter

    (@martinsauter)


    9 years, 5 months ago

    We have a Google spreadsheet that is used in daily business but feeds a table on our website as well.

    When someone filters the spreadsheet, the table on the website is filtered accordingly. This is not our intention; we want the table to display the data as defined in the query. Is this not possible or are we simply missing something?

Viewing 1 replies (of 1 total)
  • Thread Starter Martin Sauter

    (@martinsauter)

    9 years, 5 months ago

    OK, here is the solution we found so far:

    1. Create a new table in your spreadsheet.
    2. In this new table define a QUERY function that retrieves the data from the main table.
    3. Make sure you have an ORDER BY clause in your query, otherwise sorting the main table will still affect your result set.
    4. In your WordPress shortcut simply use the URL of your new table for the KEY parameter. (The table within a Google Spreadsheet document is identified by the query string parameter GID.) You don’t need a QUERY parameter in the WordPress shortcut anymore.
    5. To be on the safe side, lock the new table so nobody changes your query accidentially.
    • This reply was modified 9 years, 5 months ago by Martin Sauter.
Viewing 1 replies (of 1 total)

The topic ‘Spreadsheet filters vs. query’ is closed to new replies.