I have 39 columns in a Google Sheet with 692 rows. Loading is a bit slow (7 seconds). But I see that I am using only 10 (6 visible) of the 39 columns. If I remove unused columns the search will surely speed up based on your documentation.
How do I do this without losing all the existing column settings I have for the 10 columns in use. I can create a new view (sheet) with only the needed columns. If I then change the Input file path or URL to point to this new sheet (tab), will wpDataTables auto-update removing the no longer available columns and keep all my settings for the existing columns which are being kept with the same column names?
Don't want to redo existing work... Please advise. Thank you.
Unfortunately your table will break if you change existing url of google spreadsheet with second url with different number of columns. My suggestion is to make new one and set up again, because you can't use same settings from previous table made from google spreadsheet.
I think there should be a feature to not include certain columns when pulling data from external source like Google Sheet. This would be different than just hiding the column of course.
Thank you for your suggestion.We carefully follow customers requirements and try to implement most of them if they appears in requests from time to time so we will add to our idea list and look into some possible solutions on plugin side in future.
Hi.
I have 39 columns in a Google Sheet with 692 rows. Loading is a bit slow (7 seconds). But I see that I am using only 10 (6 visible) of the 39 columns. If I remove unused columns the search will surely speed up based on your documentation.
How do I do this without losing all the existing column settings I have for the 10 columns in use. I can create a new view (sheet) with only the needed columns. If I then change the Input file path or URL to point to this new sheet (tab), will wpDataTables auto-update removing the no longer available columns and keep all my settings for the existing columns which are being kept with the same column names?
Don't want to redo existing work... Please advise. Thank you.
Paul
Hi Paul,
Thank you for your purchase.
Unfortunately your table will break if you change existing url of google spreadsheet with second url with different number of columns. My suggestion is to make new one and set up again, because you can't use same settings from previous table made from google spreadsheet.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi.
I think there should be a feature to not include certain columns when pulling data from external source like Google Sheet. This would be different than just hiding the column of course.
Thanks.
Hi Paul,
Thank you for your suggestion.We carefully follow customers requirements and try to implement most of them if they appears in requests from time to time so we will add to our idea list and look into some possible solutions on plugin side in future.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables