Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Blacklist of many Words

Topic Labels: Formulas
Solved
Jump to Solution
1985 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')