Use case

You need to create tooltips for the records in your source table.

For example, for the records in the 'Number of Issues' column, you need to set the same tooltips, telling your colleagues that "The cancelled issues are not counted". And for the records in the 'Project Manager' column, the tooltips should be different and taken from the 'Status of the Project Manager' column.

Solution

  1. Switch the page to the edit mode.

  2. Insert the Table Transformer macro and paste the table or the macros outputting tables within the macro body.

  3. Select the macro and click Edit.

  4. In the Presets tab select Custom transformation and click Next.

  5. Enter the following SQL query:

    SELECT 'Project',
FORMATMARKDOWN("[" + T1.'Number of Issues' + "](# \"The cancelled issues are not counted\")")
AS 'Number of Issues',
FORMATMARKDOWN("[" + T1.'Project Manager' + "](# \"" + T1.'Status of the Project Manager' + "\")")
AS 'Project Manager'
FROM T*
    SQL

  6. Click Next. 

  7. Define the table settings and view options if needed. 

  8. Save the macro and the page.