Embedded Links in Reports

Overview

Links can be embedded in a Report in Decisions by adding an OpenURLInlineField calculated column to the Report. Next, this column should be connected to the desired field. This column can also use the current field value as an input for a URL query or text for a link. This tutorial explains how to configure the OpenURLInlineField calculated column to open a web page or run a Flow using a field value from the Report as an input in the URL query.

Example

1. Begin in the Designer Folder by selecting CREATE REPORT from the bottom action bar. 
2. Next, name the Report and select CREATE to proceed to the Report Designer.
3. In the Report Designer, add Account Data Source from Data Source > Common category.
4.  Next, under Data Fields, add Account Id and Email Address.
5. Then, expand the Calculated Columns category and add the OpenURLInlineField column to the Report.
6. In the resulting dialog, configure the URL column. First, configure the URL by clicking the ellipses.
7. In the Merge Text Editor, type the desired URL (in this example, we use the URL with query parameter for Google Search) and as a value for the search parameter, use the Email Address field from the Report Data Source.
8. Next, define the text for the URL. Use the Email Address field from Account Data Source. The displayed text of the URL will reflect the value of the current field (Email Address of the Current Account).
   
9. Finally, change the Column's Title. Click OK.
   
10. Save and close the Report Designer.
11. In the Designer Folder, select Run Report from the action menu by right-clicking the Report.
12.  The Report opens, select the URL in the specified column. First, select the Spongebob@bikinibottom.com link.
    
13. See that the Google search engine opens with the search results for admin@decisions.com as expected.