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!
Hi there,
Apologies as this is my 3rd support question in 3 days, but is there a way to add a <span> tag around cell content linked with a Google spreadsheet?
I would like to style the content of table cells without styling the cells themselves (as I want a border, but not the cell border or I'll need to add border-spacing).
I was wondering if I could use the Cell Content Prefix and Suffix fields, but that just displays the tag as text.
Or maybe the conditional formatting, using a token for the cell content.
I look forward to your thoughts.
Kind regards
James
Hi James.
Not a problem, that's why we're here.
Unfortunately, our plugin can't apply custom CSS classes or rules to parts of the cell. So, if you want to add content similar to this:
it's not going to work.
If you try to add some conditional formatting, like
IF CELL VALUE CONTAINS <span SET CELL CLASS customclass
it will do just that, but it'll apply the custom class to the entire cell, not just the "blue". So, in short - you can customize each cell, but not individual words or characters inside a cell.
It is possible to add <span> to a table, like shown in our documentation. Please inspect the page and take a look at any of the teams, under "Team" column. You'll see the logos were added using span. That column is set to be String, so <span>, <a href..> and so on can be used.
I hope this helps.
Best regards.
Kind Regards,
Aleksandar Vuković
[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
Hi Aleksandar,
Many thanks for your help. Ok, that's great, I'll use the string setting.
Is there a token I can use in the conditional formatting output for the content of the cell?
i.e.
Kind regards
James
Hey James.
Well, yeah, if you set it up correctly it should work just like that. See the column settings:
And you can see how it works in the attached screencast.
Please check and let me know if it works for you.
Best regards.
Kind Regards,
Aleksandar Vuković
[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
Many thanks Aleksandar,
We're using a linked Google spreadsheet so can't add the cell content manually (i.e. 'blue text').
Can we use a token/placeholder that will bring in the content and use that (i.e %cell content% or similar)?
So, for example, if the Google spreadsheet cell content for a given cell was 'Brownstone' and my code added to the conditional formatting output was:
Then on the front end, a visitor would see:
BROWNSTONE
Is that possible?
Kind regards
James
Hi again James.
I am sorry to disappoint you, but this is not possible with the plugin's built in features.
You'd need to modify each cell's content in Google Spreadsheet, so it'd look like this:
But conditional formatting, unfortunately, cannot search for "brownstone" inside a cell and apply the rule just for that word.
Also, using placeholders is only available for JSON, PHP, XML and MySQL query based tables.
I'm sorry for any inconvenience.
Best regards.
Kind Regards,
Aleksandar Vuković
[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
Ok, thanks Aleksander, we'll look for a workaround.
Feel free to mark this closed.
Kind Regards
James
Alright James.
Sorry I couldn't be of any more help.
If you have any more issues or questions feel free to open a new ticket, we will gladly help.
Best regards.
Kind Regards,
Aleksandar Vuković
[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