I would like to determine if a field contains a certain text string and if it does enter a "Y" in the field else "" (two pair of double quotes or blank/null).
I'm hoping that the following is close, but I know I'm missing something. Please help me edit this formula or suggest another method.
if {InStrRev ({Player.FirstName},"REFUSE" ,1 ,1 )} then "Y" else "" //Generates error "The field name is not known"
if InStrRev ({Player.FirstName},"REFUSE" ,1 ,1 ) then "Y" else "" //Generates error "A boolean is required here"