How to Match Keywords in a Text Column and Return Categories from Another Table

1

Hi,

I have a “Quotes” table with:

  • “Quote Content” text column
  • Auto-detected “Category Keywords” column (this is the one causing me problems).

I have a second “Category” table with:

  • “Category Title” text column
  • “Keywords” list column (with multiple keywords per row)

I’m looking for a formula for the “Category Keywords” column so that it detects which keywords are present in the quote and displays the categories.

Do you have any suggestions?

Thank you very much.
Vincent

2 Likes
2

Hello @Vincent_Mgnr! Here is the solution:

The problem was using a “Category“ database instead of a “Keyword“ database. Switching this detail will make the filter work.

2 Likes
3

Awesome ! Thank you for this quick and efficient answer Kyton :folded_hands: It works perfectly !
Vincent

2 Likes
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

5

:waving_hand: Welcome to the community @Vincent_Mgnr! Excited to have you here. Whether you’re deep in a build or just exploring, this is a great place to ask questions, share wins, or help someone else untangle a tricky formula.