Signature

dbo.fnMFExcelObjectHyperlink(
    @MFTableName      NVARCHAR(100),
    @MFObject_MFID    INT,
    @ObjectGUID       NVARCHAR(50),
    @HyperLinkType    INT,
    @ReferenceColumn  NVARCHAR(100)
)

Returns

  • NVARCHAR: a string formatted to render as a hyperlink in Excel, using the provided reference column as the link label.

Parameters

  • @MFTableName NVARCHAR(100) (required) - Valid class table name, e.g. ‘MFAccount’ or ‘MFCustomer’.

  • @MFObject_MFID INT (required) - The objid column value in the class table.

  • @ObjectGUID NVARCHAR(50) (required) - The GUID column value in the class table.

  • @HyperLinkType INT (required) - 1 = Desktop show - 2 = New Web link show

  • @ReferenceColumn NVARCHAR(100) (required) - The column in the class table to use as the hyperlink label (e.g. name_or_title).

Purpose

Return an M‑Files object hyperlink specifically formatted to display as a clickable link in Excel, labeled using the specified reference column.

Notes

  • The reference column value is shown as the link text in Excel, instead of displaying the URL.

Examples

-- desktop - show (option 1) with label from name_or_title
SELECT mc.[name_or_Title] AS Account,
       [dbo].[fnMFExcelObjectHyperlink]('MFAccount', mc.[objid], mc.[guid], 1, 'name_or_title') AS ExcelLink
FROM [dbo].[MFAccount] AS mc;

-- new style web - show (option 2) with label from name_or_title
SELECT mc.[name_or_Title] AS Account,
       [dbo].[fnMFExcelObjectHyperlink]('MFAccount', mc.[objid], mc.[guid], 2, 'name_or_title') AS ExcelLink
FROM [dbo].[MFAccount] AS mc;

Changelog

Date

Author

Description

2025-08-19

LC

Update hyperlinks to show new style web link

2020-05-18

LC

Update documentation

2019-08-30

JC

Added documentation

2019-05-15

LC

Update options available

2017-09-05

LC

UPDATE BUG IN URL