Forum Discussion

MattMakris's avatar
MattMakris
Qrew Assistant Captain
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 you...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
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 Assistant Captain
    2 years ago

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



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