Help

Blacklist of many Words

Topic Labels: Formulas
Solved
Jump to Solution
1798 3
cancel
Showing results for 
Search instead for 
Did you mean: 
airtableManuel
6 - Interface Innovator
6 - Interface Innovator

A kind of Word-Blacklist : test1,test 2, test3, test4
and if question if its true then markt the formfield with the word Error

how can i do that?

1 Solution

Accepted Solutions

IF(OR(FIND({Word1}, {Field}), FIND({Word2}, {Field})), 'There is at least a word')

See Solution in Thread

3 Replies 3

You can make a Formula with an IF function, using an OR function to join several checks, using FIND to find those words.

can you write a short example?

IF(OR(FIND({Word1}, {Field}), FIND({Word2}, {Field})), 'There is at least a word')