Forum Discussion

Qrew Legend

3 years ago

Query Syntax difference between .EX. and .TV.

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

formula queries

AdamKirchhoff

Qrew Member

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

MarkShnier__You

Qrew Legend

3 years ago

I think I came to the conclusion that the TV was used to match on User field types.

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