Skip to main content
Solved

Blacklist of many Words

  • November 20, 2019
  • 3 replies
  • 23 views

Forum|alt.badge.img

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?

Best answer by Elias_Gomez_Sai

can you write a short example?


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

3 replies

Forum|alt.badge.img+17

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


Forum|alt.badge.img
  • Author
  • Known Participant
  • November 21, 2019

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?


Forum|alt.badge.img+17

can you write a short example?


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