Forum Discussion

MattMakris's avatar
MattMakris
Qrew Cadet
2 years ago

Getting a "too many records" error on a formula field with a query function

I am receiving the following error popup when I try to save a formula field with a query function in it:

"Uh-Oh! The way this formula is built will take too long to process. Please try refining your formula."

var date prevDay = [Date Yesterday]-Days(1);
GetFieldValues(GetRecords("{63.EX.'"& $prevday &"'}AND{69.EX.'" & [Related Product] & "'}"),143)

It's a large table, but this is unavoidable. Is there a way to skirt around this? This is very disappointing Quickbase hasn't figured this out yet. Thanks!



------------------------------
Matt Makris
------------------------------

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago

    Out of curiosity, how many records are in the table.  Also does it make any difference if you flip the conditions.  ie check for related product first.  That would eliminate more records on the first pass. 

     



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • MattMakris's avatar
      MattMakris
      Qrew Cadet
      2 years ago

      ~275,000 records in the table. I swapped the conditions, but I'm still getting the error.



      ------------------------------
      Matt Makris
      ------------------------------