Forum Discussion

AaronB's avatar
AaronB
Qrew Trainee
2 years ago

Formula Text - using string comparison operators - not working

I am trying to use string comparison operators in a Formula-Checkbox field but am striking out at the simplest use-case.

Field Type = Formula-Text, Field name = Scan Bucket, Field ID = 45

Field Type - Formula-Checkbox, Field Name - IOSOtherHit, Field ID = 42

I want the box checked if 'Scan Bucket' contains the letters 'WAP'.  Unchecked if it doesn't.  The letters 'WAP' could appear anywhere in the string. 

I could not get the formula to work with just the .CT. comparison operator.  I had to put it within an 'if' statement and start it off with another boolean expression for it to not error out.  Here is what I am going with:

Formula for IOSOtherHit:   If(ToText(2)<>ToText(1) & "{45.CT.'WAP'}",true, false)

However, as you can see from the mini report below, it is still hitting on strings that do not contain the letters 'WAP'. 

Any suggestions as to what I am doing incorrectly will be appreciated.



------------------------------
Aaron B
ab1692@att.com
------------------------------
  • If(Contains([Scan Bucket], "WAP"), true)



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
  • AaronB's avatar
    AaronB
    Qrew Trainee

    Marcelo, Mark,

    So simple!!!!!   I have no clue how I was unaware of the "Contains" option. 

    Thanks to both of you.



    ------------------------------
    Aaron B
    ab1692@att.com
    ------------------------------