I have about 20 tables that I link to Google Sheets that I need to change the data type of 15 columns to Float from String. Is there a way to do this in bulk?
I would also be interested in adding the same conditional formatting rule to the all the columns too.
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
2. Adding one Conditional rule to multiple columns at the same time :
Sorry to disappoint on that one, as well, but we currently don't have any built in way to achieve it.
You can leave two separate development suggestions and we will do our best to work on it in the future.
I have about 20 tables that I link to Google Sheets that I need to change the data type of 15 columns to Float from String. Is there a way to do this in bulk?
I would also be interested in adding the same conditional formatting rule to the all the columns too.
Hi Joe,
Sorry to disappoint you, but we don't have a way to bulk change multiple column's data type at the same time.
At this time, you would need to go into each column settings one by one and change the data type.
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
2. Adding one Conditional rule to multiple columns at the same time :
Sorry to disappoint on that one, as well, but we currently don't have any built in way to achieve it.
You can leave two separate development suggestions and we will do our best to work on it in the future.
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