Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
2 years ago

Formula Query to create Line Chart filtered by the current logged in user

Hi all, I am working on a formula query to try to build a line graph that will show cumulative sales for the current user in the current year and previous two years.  I had this working without the b...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago

Not 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
------------------------------
IvanWeiss's avatar
IvanWeiss
Qrew Captain
2 years ago

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__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago

    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
    ------------------------------
    • IvanWeiss's avatar
      IvanWeiss
      Qrew Captain
      2 years ago

      I actually got to work via {19.TV._fid_66}



      ------------------------------
      Ivan Weiss
      ------------------------------