Forum Discussion

MikeTamoush's avatar
MikeTamoush
Qrew Commander
3 years ago

HAS vs CT in new formula queries - what is the difference?

I just made a query and interchanged both HAS and CT and both worked just fine. Which leads me to the question, what is the difference? When do I use each one? Also, a huge thanks to QuickBase Junk...
formula queries
MikeTamoush's avatar
MikeTamoush
Qrew Commander
Mark, any chance TV can be used for negative numbers, like, absolute value? Just a thought.

I thought HAS was going to be used on formula lists, and CT would be for formula text, but I tried both on a multi-select text field and they both worked just fine.

------------------------------
Mike Tamoush
------------------------------
  • MikeTamoush's avatar
    MikeTamoush
    Qrew Commander
    3 years ago
    Interesting. It seems my guess on HAS and CT was correct. It specifically says not to use CT on multi select text field, yet I did and it worked perfectly...wonder why...

    I'll change it just in case!

    ------------------------------
    Mike Tamoush
    ------------------------------