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...
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 ------------------------------
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 ------------------------------
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 ------------------------------
The 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 ------------------------------
.. so I think that HAS is similar to a report filter where you want to filter on a Multi Select field and it says "includes" as the filter comparison operator in the report filter. I just did an old style report for "incudes" in a multi select field and used the More .. to show the expanded URL and that translated to a Query with "HAS". Also with a filter on a userid it translated to TV
