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?
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".
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.
I use that filtered Sheet URL - but our connected Table is going to pull all the unfiltered Data.
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.
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.
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.
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".
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.
I use that filtered Sheet URL - but our connected Table is going to pull all the unfiltered Data.
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
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