I’m new to this but I am trying to check if a text field includes a set of key phrases.
I have a Customer Table with a text field called “Notes” where someone could type a note in a cell.
There is a Phrase Table with a text field “Phrases” that holds a set of predefined phrases.
I would like to check if any of the phrases are found in the note.
This is what I got, the field is located on the Customer Table. It returns False in all cases.
A script would be a better tool here than a formula.
Why formulas aren’t great here
After you write a formula, it executes once per row. During that runtime, it only has access to the data in that table’s row. So ‘Phrases’ is inaccessible data for a formula existing in the Customer table. Also the FIND function only looks up one word at a time, so that would be a headache to write for multiple phrases.