Can I filter hyperlinked text?

Ask the Community
#1

Hi there,

I have a column in my table that is being used to link off to other pages. I want to filter by this column but anything that is hyperlinked doesn’t seem to appear when I search for it.

Is there a way to filter hyperlinked text at all?

Thanks

#2

Hi there @Matt_Hui and Welcome to the Community :tada: !

You can filter by hyperlink but not directly I think :blush: .

I think you could just add a Text field to your table, convert your hyperlink into text with something like :

thisRow.Pages.ToText()

And use that Text field in your filter instead of the page field. (See the [View of Table 3] in my very humble sample)

Capture d’écran 2021-01-18 à 14.10.17
Capture d’écran 2021-01-18 à 14.10.172354×938 211 KB

Or do the conversion directly in the Filter formula :blush: .

Capture d’écran 2021-01-18 à 14.15.26
Capture d’écran 2021-01-18 à 14.15.262354×938 197 KB

Another option, could be to use an interactive filter maybe (Which I did for the [Table 3]) …

1 Like
#3

Thanks that’s exactly what I needed!

1 Like
#4

You’re welcome :grin: !