Forum Discussion
MarkShnier__You
Qrew Legend
2 years agoNot tested but try this. TV is a special operator intended to be used with user fields.
AND {19.TV." & ToText([Current User]) & "}";
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- IvanWeiss2 years agoQrew Captain
Nope, that did not work either. Would I swap out the ToText([Current User]) with the fid maybe? I didnt try but I am not sure what the TV means
------------------------------
Ivan Weiss
------------------------------- MarkShnier__You2 years ago
Qrew Legend
I just did a test to count children of a parent where the current user is the record owner and it worked.
var text QUERY ="{7.EX." & ToText([Record ID#]) & "}"& " AND "& "{4.TV.'" & ToText(User()) & "'}";Size(GetRecords($Query, [_DBID_CHILD]))So maybe its those pesky single quotes that will fix it.AND {19.TV.'" & ToText([Current User]) & "'}";
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- IvanWeiss2 years agoQrew Captain
I actually got to work via {19.TV._fid_66}
------------------------------
Ivan Weiss
------------------------------