Skip to main content
Question

Query that determines the Maximum number in a set of records.

  • February 7, 2023
  • 0 replies
  • 823 views
Forum|alt.badge.img+6
Is it possible to create query that results in the maximum value for a set of records? I see SumValues and Size, but no Maximum.

------------------------------
George Bramhall
------------------------------
    This topic has been closed for replies.

    • BibhavRimal
    • Quickbase Alumni
    • February 7, 2023
    There should be Max function. 

    Hope this helps.

    ------------------------------
    Bibhav Rimal
    ------------------------------
    Forum|alt.badge.img+6
    • JoelHickok
    • Quickbase Alumni
    • July 5, 2023

    So while this has resulted in a bit of showing off knowledge for other purposes, the simple answer is that it cannot be done (as of July 2023). 

    If only Quickbase had a Formula that accepted a "Max" argument as a delimiter-separated string instead of multiple arguments.  There is not way to turn a string such as "1; 2; 4; 10" into multiple argument for the Max function to process.

    There is a way to pull this off in a Pipeline, but no way to run a Query for max and no way to determine max in a Formula Field.

    Terms & ConditionsAccessibility statement