Skip to main content
Question

Query Help

  • March 12, 2023
  • 0 replies
  • 20 views

I am trying to create a query that searches a table for matching [Order] (fid 8) and then sums the field [Total Amount Claimed] (fid 250) from the found results. I haven't been able to get anything to work and wonder if it is because neither are manual entry fields. Order is rich text formula field and Total Amount Claimed is a formula currency field. 

Any help would be appreciated.



------------------------------
Rhonda Jones
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+22
    • MarkShnierYou
    • Quickbase Alumni
    • March 12, 2023



    Not tested, but try this  

    var text QUERY = 
      "{8.EX." & [Order] & "}";

    SumValues(GetRecords($QUERY,[_DBID_MYTABLE]),250)



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement