How to manipulate Show Click Link If URL Input in Text Type Column?

[FerdyanH]

Hello AppSheet Community,

I have a question regarding how to display content in AppSheet. I have a column with a Text data type, and the input in this column could either be plain text or a URL. I want the following behavior:

• If the input is plain text, it stays as is.

• If the input is a URL (from the [match_stream_admin] column), I want it to be clickable as a hyperlink.

Currently, I'm using this formula in the Initial Value:

IF([match_vod_reference] = "NewOne", [match_stream_admin],
IF([match_vod_reference] = "MediaOne", TRUE, ""))

The [match_stream_admin] value is always a valid URL, but since the column is typed as Text, it doesn’t render as a clickable link.

My question is: is there any way to manipulate or format the output so the URL becomes clickable even though the column type is Text? Perhaps using Format Rules or any other workaround?

Thanks in advance!