Formatting of plain text outputs from table transformer

Green, Desmond

How do I better format text coming from a table transformer macro, where the results are in plain text?

With a table transformer macro returning plain text, my page is structured as per the below.

The plain text from the table transformer gets displayed on a new line and I seem to have little control over the formatting of this text.

There is static text 'Hybrid' with a H3 heading, to which I probably want to postfix a date, in the same format, coming from a table transformer. To be clear, I might like to format the text as follows:

Hybrid 28/11/2023

The same is true of the next column, 'Cloud' plus date.

How do I get more control over the formatting of plain text from the table transformer?

 

Stiltsoft support

Hi @Green, Desmond ,

I think we've already had questions where you changed font size, here is an example: https://docs.stiltsoft.com/tfac/cloud/advanced-table-cells-formatting-58426218.html#Advancedtablecellsformatting-Сhangingfontsize,style

So, you'll be able to make your text bigger.

To place a macro on the same level as your heading is not possible, so the workaround may be to put the description inside your SQL query as well.

For example, 

SELECT CONCAT("Hybrid ", FORMATDATE(MAX('Date'))) AS 'Max Date'
FROM T1

will give me 

Hybrid 03 Nov 2023

Now you'll be able to set a bigger font for the whole phrase.

SELECT
FORMATWIKI("{cell:font-size=50px|font-weight=bold}", CONCAT("Hybrid ", FORMATDATE(MAX('Date'))), "{cell}")
AS ''
FROM T1