Hey there, Awesome Customers!
Just a heads up: Our team will be out of the office on Monday, November 11th in observance of Armistice Day, but don’t worry—we'll be back in full swing on Tuesday, November 12th.
In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.
Thanks a bunch for your understanding and support!
Warm regards,
TMS
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