Displaying links in search box

[trick247]

Hi all,

I have added a search box to my table which allows me to search the data in my database. However, there are hyperlinks in my data base which it does not display. Is there anyway to display clickable hyperlinks within my search?

This is currently what I'm using:

=FILTER(Table1,(ISNUMBER(SEARCH(B10,Table1[Record Number])))+(ISNUMBER(SEARCH(B10,Table1[Title]))) +(ISNUMBER(SEARCH(B10,Table1[Type])))+(ISNUMBER(SEARCH(B10,Table1[Description])))+(ISNUMBER(SEARCH(B10,Table1[Lead/Support])))+(ISNUMBER(SEARCH(B10,Table1[Link])))+(ISNUMBER(SEARCH(B10,Table1[Status]))),"No Records Found")[/CODE][/CODE]

 

[Fluff]

Not that I'm aware of.
Are you searching every column in your table with that formula?

 

[trick247]

Yes I am! The table has a link column, but when it appears in the search box it only has text

 

[Fluff]

In that case you can shorten the formula like

=FILTER(Table1,MMULT(--(ISNUMBER(SEARCH(B10,Table1))),SEQUENCE(COLUMNS(Table1),,,0))>0,"No records found")

but hyperlinks will not work.