We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
Hello
I have a table synced with Google Sheets. The default table has 1000 rows but the rows with data vary over time, sometimes it has 200 rows with data and sometimes 500 rows, and sometimes more or less. Never exactly 1000 rows with data.
What I want to do is to delete or remove the empty rows automatically after the data is fetched from Google Sheet API. How to do this?
I tried to do this with conditional formatting for the columns but failed. I have the possibility of giving a standard value to empty cells/rows/columns in Google Sheets if empty, for example, the value "empty". How can I tell your plugin to remove the cell/row if the value is "empty"? This is an example solution, please enlighten me if there is another better solution for this. Thanks.
Hi Edwin
Thank you for reaching out to us.
You should be able to achieve this using conditional formatting by adding a simple rule like this
This class should work automatically, hiding the rows that are empty, but if it doesn't work straight away, you can go to wpDataTables settings/Custom JS and CSS/Custom CSS field, and add this:
table.wpDataTable .hide { display: none !important; }Please note, though, that on pages where you have rows affected by this condition, they will only be hidden from view, but they will still be present on the page. So, if you have 10 rows on the first page of the table, and there are 9 hidden rows, you will only see 1 row on the first page.
If you have a lot of these entries, you may want to consider increasing the number of rows that exist on the page. If the table exceeds 2.000 rows, choosing the option "All" is not recommended, because the page loading time will increase, and it can also break due to the amount of data.