Using Find in a Formula

Topic Labels: Formulas
707 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.

IF(FIND(Phrases ,Notes)>=1,“True”,“False”)

1 Reply 1
10 - Mercury
10 - Mercury

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.