Skip to main content
Question

Query Syntax difference between .EX. and .TV.

  • October 23, 2021
  • 0 replies
  • 94 views
MarkShnierYou
Forum|alt.badge.img+24
The Quickbase Junkie has a nice help page on Query Syntax, which have many uses including to be used on Formula Queries.

How to write Queries in Quickbase

What is the difference between the operator .EX. and .TV.  ?

thx
Mark



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

Forum|alt.badge.img+14
Just a guess but maybe TV is used only for checkboxes? An alternate to an Exact match of 1 or true?

------------------------------
Michael Tamoush
------------------------------
Mark, I believe this is to reference the index / ID# of a lookup field.

EX would match the input value,
TV would match the numeric reference value of a searched proxy field

------------------------------
Adam Kirchhoff
------------------------------
Terms & ConditionsAccessibility statement