How to use "contains" filters for a column that has page links?

1

Hi. Could someone help with this?

I have a table with a column “Link” where I add one or more pages using the @pagename function. I would like to use the “contains” filter on this column but it doesn’t work. Is there a way to make this work? Or a workaround? Maybe by adding a new column that extracts the page names as plain text? I tried using thisRow.Link.ToText() but I get the below result. I’m not able to figure out how to do this. Thanks!

image
image1584×398 25.3 KB

1 Like
2

Hello @ap606 ,

Please share a dummy doc, so we can see exactly what you are doing and how you are using the CFL (Coda Formula Language).

My guess would be that you have to use something like link.containstext(“filter text“).

Greetings,
Joost

1 Like
3

Hey @joost_mineur

Here is a sample doc

I’ve created a few pages and a summary table that has these page links. For the table, I added a filter for “Page links” column. What I’d like to achieve is to use that filter, search for “name” and be shown only rows 2 and 3.

1 Like
4

Hi @ap606

I edited your doc to include a possible solution.
My approach was to convert the text column with the link into HTML using a pack and then extracting the name of the link. I created a second column that contains the “name” of the links, and you can use it to filter.

2 Likes
5

This is excellent. Thank you @Felipe_Arnhold!