Use caseLink to Use case

You have several pages with unique 'Project' mini-tables. You need to create clickable links to each project. Since project settings may change over time, you decide to set parts of the URL as custom (user) variables: it will be easier to change them later if required.

SolutionLink to 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:

    SET @var1 = "https://www.123.com/portal/";
SET @var2 = (SELECT T1.'Project' FROM T1);

SELECT FORMATWIKI("[Link|", @var1, @var2, "]") AS 'Project Link';
    SQL

  6. Save the macro and the page.


The result link is: https://www.123.com/portal/TFCS-324