MattMakris
2 years agoQrew Assistant Captain
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
------------------------------