Hi all, is it possible to have a formula that searches if a text field contains at least one item of an array? Specifically, I would like to achieve the following:
I define topic names and related keywords for each one manually in table #1: TABLE 1: TOPIC Name (string) | Keywords (Multi-select) Animals | dog, cat, elephant, Fruits | apple, banana, orange Colors | red, blue, yellow
I have some articles in another table and I want to update the Topic field by checking if the article title contains items of the array field from table 1.
TABLE 2: ARTICLES Title (string) | Topic (Lookup) (this should be the field updated by the formula) The dog is sleeping | Animals The apple is red | Colors, Fruits
I know I can use a formula and manually define keywords combining IF, AND, OR, FIND etc.
However, topics and keywords frequently change, so I should update the formula every time a new topic enters the table. Instead, I want a formula that searches if any item of an array (Keywords field) is contained in the Title field.