Discussions

Expand all | Collapse all

getting highest value in a child's record

  • 1.  getting highest value in a child's record

    Posted 9 days ago
    Hi,  I have a parent and a child table.

    On the child table I have several fields one of them being the severity level.  What I need to do is find the child record with the highest severity for one case.  

    Example:
    Case # 123456789
    5 child records related to case
    Record 1 - Severity level 0
    Record 2- Severity Level 1
    Record 3 - Severity Level 2
    Record 4 - Severity Level 2
    Record 5 - Severity Level 2

    What I need is a field that will tell me the  highest level is severity level 2.  I was able to do this with a checkbox formula.  However, the three records are all checked.  I just want one level 2 record checked.  How can I do this?

    Thank you in advance




    ------------------------------
    Sandralee Oster
    ------------------------------


  • 2.  RE: getting highest value in a child's record

    Posted 6 days ago
    You can create a summary field using the 'Summary of a specific field' option
    Select 'Maximum' for the field 'Security Level'

    Hope that helps!

    ------------------------------
    Hannah Jacobson
    ------------------------------



  • 3.  RE: getting highest value in a child's record

    Posted 6 days ago
    Hi,

    I already have the summary report setup to give me the Maximum severity level.  It does return the highest number, however, it will return all records with the highest severity level for the parent record.  I just want it to return one record with the highest level.  I need it so that only one checkbox is selected because I also have a report that counts closed cases by severity level.  So if one case has more than one checkbox selected for highest severity level, it will askew the results.

    ------------------------------
    Sandralee Oster
    ------------------------------



  • 4.  RE: getting highest value in a child's record

    Posted 6 days ago
    You have the Max Priority level up on the Parent.  Look that up down to the children and call it [Max Severity level].

    Then make a summary of the Maximum (or minimum) Record ID# where the Severity level = [Max Severity level] and call it [Record ID# of the first (last) child w/ Highest Severity Level]. 

    Then look that up down to the Children.

    Then your flagged child will be determined by formula where where the [Record ID#] = [Record ID# of the first (last) child w/ Highest Severity Level]

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: getting highest value in a child's record

    Posted 6 days ago
    That worked perfectly!  Thank you so much!

    ------------------------------
    Sandralee Oster
    ------------------------------