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

Question

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------------------------------

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community