Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Blacklist of many Words

Topic Labels: Formulas
Solved
Jump to Solution
645 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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')