Make url value as Hyperlink at form level

[desmond_lee]

Hi Expert

Is it possible to make the column PROJECT SLIDE LINK a link where I click it it automatically launch google slide? At the moment i need to copy and paste. At the mean time it's just a virtual column with this ANY(SELECT(Project List[CTBG OFFICIAL PROJECT UPLOADED],[PROJECT ID]=[_THISROW].[PROJECT ID]))

[Steve · Accepted solution]

Make the PROJECT SLIDE LINK column type Show, Category of Url, and a Content expression that uses HYPERLINK().

[Steve · Accepted solution]

Make the PROJECT SLIDE LINK column type Show, Category of Url, and a Content expression that uses HYPERLINK().

[desmond_lee]

HYPERLINK(). - How are we going to put this link ? Because my link change when OE-SAVE_ID change.

[Steve]

It's an expression, so it can use the value of the OE-SAVE_ID column.

[desmond_lee · Accepted solution]

Thank you. HYPERLINK(ANY(SELECT(Project List[CTBG OFFICIAL PROJECT UPLOADED],[PROJECT ID]=[_THISROW].[PROJECT ID])), [OE_SURVEY ID])