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