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

Question

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 Junkie for her videos on formula queries!

@Quick Base Junkie

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

markshnier__you · Answer

I would also like to know the difference between EX and TV

and ditto on those Quickbase Junkie videos. Fun and highly informative! I know Sharon works hard to make them seem effortless to create the way she just breezes though the topics, but they are not. It must take a lot of editing to get them that clean with such great flow.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

miketamoush · Answer

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
------------------------------

markshnier__you · Answer

Actually the bottom of this help article does explain the comparison operators.
https://help.quickbase.com/api-guide/do_query.html

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

miketamoush · Answer

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------------------------------

quickbasejunkie · Answer

Thanks for the shoutout @Mike TamoushThe way I think about HAS vs CT (right or wrong) is HAS is for a text list fields where you may have values like.- Approved- Approved with conditions- Approved on a limited basis​Using CT.'Approved' would get a positive on all 3 as all 3 contain "Approved."vs HAS.'Approved' which would only match on the complete match of "Approved".For TV, that is used with fields that have multiple properties like User. A user field contains the user ID, the user name, and the user email.When using this operator you can 'mix and match' such that you don't have to only compare an email field to an email value, you could use TV and compare an email field to a user field.For anyone interested in learning about Quickbase Queries, here is my video (and more is available on https://quickbasejunkie.com/blog).

------------------------------Quick Base Junkie------------------------------

Forum Discussion

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

6 Replies