Embedded Links in Reports
  • Updated on 09 Dec 2014
  • 4 minutes to read
  • Print
  • Dark
    Light

Embedded Links in Reports

  • Print
  • Dark
    Light

This tutorial shows how to embed links in Report.
Links can be embedded in a Report in Decisions . To accomplish this, a specific OpenURLInlineField C alculated Column should be added 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 URL query or as text for the Link . This tutorial explains how to configure OpenURLInlineField Calculated column to open web page or to run a Flow using a field value from the Report as an input in URL query.
Example
We begin in the Designer Folder by pressing Create Report > Create Report from Folder Actions panel to create a new Report .
Next, we name the Report and press OK to proceed to the Report Designer.
2018-07-02_152841.jpg

In the Report Designer, we add Account Data Source from Data Source > Common category in the Tool Box .
2018-07-02_152949.jpg

Next, we add the desired fields to our Report from the Account Data Source.
2018-07-02_153049.jpg

Then, we expandCalculated Columns category and add OpenURLInlineField column to our Report .
2018-07-02_153154.jpg

In the resulting popup window, we can configure our URL column. First, we configure URL by clicking ellipses. In the Merge Text Editor, we 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 we use Email Address field from the Report Data Source.
2018-07-02_153357.jpg

Next, we define text for our URL . In this Example, we usetheEmail Address field from Account Data Source . The displayed text of our URL will reflect the value of the current field (Email Address of the current Account ).
2018-07-02_153453.jpg

Finally, we change our Column's Title to reflect its purpose. We then press Ok to save and close this popup window.
2018-07-02_153557.jpg

This completes our Report . We can now save and close the Report Designer .
Back in the Designer Folder, we select Run Report from the report's action menu to test our report. 
2018-07-02_153709.jpg

TheReport opens, and we can click the URL in specified column. First we click admin@decisions.com link.
2018-07-02_153807.jpg

We can see that the Google search engine opens with the search results for admin@decisions.com as expected.
2018-07-02_153845.jpg

Next, we are going to create a Flow that a user can run using a link in the Report .
In the Designer Folder, we click Create Flow from the Folder Actions panel.
2018-07-02_154048.jpg

We name our Flow and click OK to proceed to the Flow Designer.
2018-07-02_154207.jpg

We then locateFlow Input Data in the flow properties menu and click the Show Editor link to add an input to our Flow .
2018-07-02_154254.jpg

In the resulting popup window, we name our Input Data and define its type as String . We can now click Close to save and close the data definition popup window.
2018-07-02_154406.jpg

Using the Quick Add Step dialog**,** we locate the Send Notification step in All Steps [Catalog] > Communication category and add this step to our Flow.
2018-07-02_154458.jpg

Next, we connect ourSend Notification step to theEnd Step.
2018-07-02_154528.jpg

We then configure our Send Notification Step. First, we click Add New to configure the NotifyUser field.
In the resulting popup window, we pick our current account and click Ok to add it to the NotifyUser list.
2018-07-02_154633-1.jpg

We define a mapping type for Notification step as Text Merge.Plain .
2018-07-02_155016.jpg

We click Show Editor button to configure the text that will show up in the Send Notification message.
In the Text Merge Editor, we we select our previously established Flow Input Data .
We click Ok to save and close this Text Editor.
2018-07-02_155112.jpg

For Notification Subject, we define Mapping Type as Constant and configure desired Value .
2018-07-02_155243.jpg

This completes our Flow . We can save and close Flow Designer.
In order to build a URL to run the Flow, we need to get a URL to call our Flow. From the flow's Action menu, we click Run [Advanced] > Integration > View Integration Details.
2018-07-02_155831.jpg

On the Integration page for our Flow, we will generate a Call Via Get URL for API calls and copy the resulting URL.
2018-07-02_160117.jpg

Next, locate Report that was created earlier in this tutorial and click Edit Report from its Action menu.
2018-07-02_160209.jpg

In the Report Designer, we click the Edit option for our OpenURLInlineField Calculated column.
2018-07-02_160256.jpg

Next, we replace the previously entered text with our generated URL to call the Flow . We paste the URL and we use as Email Address field from Account Data Source as the value for the Clicked Field parameter*.*
2018-07-02_160840.jpg

Next, we change the column Title to better reflect the purposes of our Link . When finished, we can save all changes and close the Report Designer.
2018-07-02_160947.jpg

We Run Report to test our Links . First, we click on admin@decisions.com link... Notification pops up saying that we clicked admin@decisions.com.
32_Notification-1.png

Next, we click different link... In this example, we clicked the example@decisions.com account. We should be able to see a new Notification with example@decisions.com as the Address.
33_Notification-2.png

Was this article helpful?