Quickbase Discussions

 View Only
  • 1.  Formula Help - Getting a Field Name based on Maximum value

    Posted 12 days ago
    Here is my formula, which returns the value of the maximum. But I'd like the field name of the maximum:

    If([Sample Size]>1,ToText(Max([Bird Damage],[Bruise],[Corking],[Decay],[Discoloration],[Growth Crack],[Hail Damage],[Insect Damage],[Leaf/Limb Rub],[Mechanical],[Mixed Sizing?],[Mold],[Open Suture],[Potato Skin],[Russeting],[Scar],[Shriveled],[Silvering],[Slip Skin],[Soft],[Soft Tip],[Speckling],[Split Pit],[Staining],[Stem Pull],[Sun Burn],[Undersize],[Worm],[Worm Hole],[Glass/Metal/Rocks/etc.])),null)

    ------------------------------
    Davis Ward
    ------------------------------


  • 2.  RE: Formula Help - Getting a Field Name based on Maximum value

    Posted 12 days ago
    Try this, assuming that you already have a field called [max Value] to calculate the Maximum

    List(", ",
    Case([Max Value],

    [Bird Damage], "Bird Damage",
    [Bruise], "Bruise",
    etc
    [Glass/Metal/Rocks/etc.], "Glass/Metal/Rocks/etc."))


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



  • 3.  RE: Formula Help - Getting a Field Name based on Maximum value

    Posted 11 days ago
    That did the trick. I had to add a "Max Value" equivalent field. I was just attempting to do it without a middleman field.

    Thanks!

    ------------------------------
    Davis Ward
    ------------------------------