Blacklist of many Words

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?

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


This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.