Discussions

 View Only
  • 1.  Problem with a Report

    Posted 11-29-2021 22:33
    Hi all, hoping this is an easy question.  It feels like the answer should be easy, but I can't figure it out.

    Put simply:  I have an App where an Employee has many Cases.  Each Case has a Drop Down field that is either A or B, with another drop down field called Status which is either Open or Closed.  

    I'm Trying to create a report to show Employees who have an Open A Case, and an Open B Case.  

    Appreciate this community's help.



    ------------------------------
    Troy
    ------------------------------


  • 2.  RE: Problem with a Report

    Posted 11-30-2021 06:49
    Edited by Mark Shnier (Your Quickbase Coach) 11-30-2021 16:04
    Problem. Make a boolean checkbox summary field on the relationship and use that middle radio button to select if Any Cases subject to a filter where type = A.

    Then duplicate the field to type B.

    Now you will have a clean checkbox field on the employee record and you can filter a report where the employee has both Any cases of Type A and also Any cases of Type B.

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



  • 3.  RE: Problem with a Report

    Posted 11-30-2021 13:45
    Thanks Mark!    This is precisely what I needed.

    Appreciate it very much.

    ------------------------------
    Troy MacPherson
    ------------------------------