Use case
You need to add background and text color.
Solution
- Switch the page to the edit mode.
- Insert the Table Transformer macro and paste the table or the macros outputting tables within the macro body.
- Select the macro and click Edit.
- In the Presets tab select Custom transformation and click Next.
Enter the following SQL query:
SELECT FORMATWIKI("{cell:bgColor=yellow}", T1.'Rep', "{cell}") AS 'Rep', FORMATWIKI("{cell:bgColor=#FFE5B4}", T1.'Department', "{cell}") AS 'Department', FORMATWIKI("{cell:bgColor=orange|textColor=yellow|align=center|vertical-align=bottom|width=500px}" , T1.'City', "{cell}") AS 'City', FORMATWIKI("{panel:bgColor=orange|textColor=white}", T1.'City', "{panel}") AS 'City 1', FORMATWIKI("{color:orange}", T1.'City', "{color}") AS 'City 2' FROM T1
You can write both a color name from this list and your own HEX code in the SQL query.
Keep the following order of attribues: bgColor, textColor, align, width.
- Click Next.
- Define the table settings and view options if needed.
Save the macro and the page.