Adding a Hyperlink

Creating a Hyperlink from a Database

  1. Prepare the URL link in your database tables.

  2. In the Data Models and Views tab, right-click and select New Data Model to create a Data Model.
  3. In the Data Model Designer, set up the Format field:
    1. In the Categories section, select Hyperlink and click OK.

    2. In the upper left-hand corner, click File and select Save Data Model.
  4. Back to the Data Model and Views tab, create a new view from the data model where you set up the Format field and select Worksheet.
  5. Add the Hyperlink (URL) fields.
  6. By clicking the link in the worksheet grid, a new window will open to display the URL in a browser.

Creating a Custom Calculated Column Hyperlink

  1. In the Data Model Designer, right-click on a column and select Add Calculated Column to create a new custom column.
    1. Add a custom name for the new column in the Column Heading field (optional).
    2. In the Advanced > Data Type section, select CHAR and click OK.

    3. In the Category section, select Hyperlink and click OK.

    4. Next you want to Edit Calculation to add the desired custom URL.

      ExampleExample with values

      '<html><a href="https://necca01l0006.nectariqa.com/StandAlone/Index?PID=490000414&VID=490000398&envID=e2d8dcf6-ad78-4d9d-b996-163fe39b018b&OpeningAction=LinktoView&CP=2a1aad5a&F=%5BInvoiceLines.StockItemID%5D%20%3D%20'+cast([InvoiceLines.StockItemID] as nvarchar)+'" target=_blank">'+cast([InvoiceLines.StockItemID] as nvarchar)+'</a></html>'

      <a href="'+'https://necca01l0006.nectariqa.com/StandAlone/Index?PID=490000414&VID=490000398&envID=e2d8dcf6-ad78-4d9d-b996-163fe39b018b&OpeningAction=LinktoView&CP=2a1aad5a&F=%5BInvoiceLines.StockItemID%5D%20%3D%20'+cast([InvoiceLines.StockItemID] as nvarchar)+'" target=_blank">'+cast([InvoiceLines.StockItemID] as nvarchar)+'</a>'

      https://necca01l0006.nectariqa.com/StandAlone/Index?PID=490000414&VID=490000398&envID=e2d8dcf6-ad78-4d9d-b996-163fe39b018b&OpeningAction=LinktoView&CP=2a1aad5a&F=%5BInvoiceLines.StockItemID%5D%20%3D%2040

      '['+cast([ZINVOICE].[ITMREF_0] as nvarchar)+'](https://www.google.ca/search?q='+ cast([ZINVOICE].[ITMREF_0] as nvarchar)+')'

    5. In the upper left-hand corner, click File and select Save Data Model.
  2. Back to the Data Model and Views tab, create a new view from the data model where you set up the Format field and select Worksheet.
  3. Add the Hyperlink (URL) fields.

    Custom links open in a new browser tab.

 

Important

If you do an export of the worksheet containing the hyperlink, please proceed as follows before opening the file in Excel:

  • Open the link in your browser and make sure to select any option that will save the session data in cookies (like the Remember me feature when logging in) (right after the links should work on other browsers)
    OR
  • Change the registry key value: (Click here for more information.)
    1. Quit any programs that are running.
    2. Press the Windows + R keys to open the Run window.
    3. Enter regedit and press the Enter key.
    4. In the Registry Editor, browse to one of the following sub-keys (create the key if it does not exist):
      • For a 32 Bit version of Office on 64 bit version of Windows:

        HKLM\SOFTWARE\Wow6432Node\Microsoft\Office\9.0\Common\Internet\

      • For a 64 Bit version of Office on 64 bit version of Windows:

        HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\9.0\Common\Internet

    5. Right-click on the Internet Subkey, click on Edit and select New then DWORD.
    6. Enter ForceShellExecute as Value Name and open it.
    7. Set the Value Data to 1 and click on OK.
    8. In the Registry Editor, click on File and select Exit.