Hey everyone!

With the holiday season upon us, we want to share our upcoming working hours:

After that, we’ll return to our regular schedule and assist you as quickly as possible.

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.

Thanks a bunch for your understanding and support!

Warm regards and happy holidays!

TMS

Okay
  Public Ticket #3515391
Google Sheets - Data Filter Views
Closed

Comments

  • Frank Bell started the conversation
    November 5, 2023 at 7:32pm

    Can you explain how wpdatatables plugin works related to if a Filter View is being used on a Google Sheet that we are sharing and replicating (i guess - sort of if caching is set).  


    Does wpdatatables (with the google sheet sharing api configured) replicate ONLY the data within the Filter View?  Or does it still replicate or show the data for the entire sheet even though the filter view will filter out many rows? 

    It seems that the urls are different with or without a filter view.  so I'm guessing that it just shares or saves to the cache row and column of .data ONLY what is visible within a FILTER VIEW?

    I just want to confirm this.

  •  1,847
    Miloš replied
    November 6, 2023 at 9:03pm

    Hi Frank,

    Sorry to disappoint you, but it is not possible to use only a Filtered View from a Google Sheet.

    I just made a test with this simple Sheet, where i got some dummy 'clients' data, and i have this Column in the Sheet that provides "Business Type".

    2529282600.png

    If i make a new filter view on that Sheet - i notice the URL on top changes to provide that filtered View.

    Let's say if we just want to show the "IT" people in this Group.

    6958886164.png

    I use that filtered Sheet URL - but our connected Table is going to pull all the unfiltered Data.

    8477088898.png

    You can only try to use an !importrange function or similar to make a Copy of this Sheet which only pulls your filtered Data - and then use that new Sheet ( tab) URL for a Table.

    Same goes if you want to use some Formula or Script on a Google Sheet.

    Please check more details how to achieve that on this Guide from our Documentation.

    In short, it is making a new blank Sheet, and providing an !importrange in cell A1 -   then it passes just the data you need to that Sheet copy and link that to our Table.


    I hope that helps.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables