Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

If statements and search function

Topic Labels: Formulas
473 0
Showing results for 
Search instead for 
Did you mean: 

Hello, for context I am creating a form that will be shared publicly, that will be shared widely, where the names of people will also be able to be seen in a public view (it is for a petition). I am afraid of people writing inappropriate/joke names and would like to catch as many as I can with an if statement that would turn them blank in this public view. I am not sure how to go about this exactly especially since I know the case matters. For instance

IF(OR(Name=“Jesus christ”,Name=“Jesus”),Blank(),Name)

is there a function i can use that disregards case and/or just searches the string for certain inappropriate word?


0 Replies 0