Formula Syntax Error Question
Hi All, Here's the formula I thought would work: todate(max(getfieldvalues(getrecords("{756.EX. '"&[Record ID#]&"'}", "abdc3n4ne"),1))) The logic is, find all records where fid 756 (related f...
Forum Discussion
Rats!
So, my next thought was to change the formula field type to text and then use another field to parse out the data I want. The formula was:
totext(getfieldvalues(getrecords("{756.EX. '"&[Record ID#]&"'}", "abdc3n4ne"),1))
But when I clicked save I got the following error:
Uh-Oh! The way this formula is built will take too long to process. Please try refining your formula.
Not sure what to do with that.
------------------------------
Daniel Johnson
------------------------------
So, my next thought was to change the formula field type to text and then use another field to parse out the data I want. The formula was:
totext(getfieldvalues(getrecords("{756.EX. '"&[Record ID#]&"'}", "abdc3n4ne"),1))
But when I clicked save I got the following error:
Uh-Oh! The way this formula is built will take too long to process. Please try refining your formula.
Not sure what to do with that.
------------------------------
Daniel Johnson
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendHow large is your table, how many records?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- The table the formula is querying has 42,000+ records.
------------------------------
Daniel Johnson
------------------------------- MarkShnier__YouYou would probably have to reach out to the care team but I think right now they are throttling the use of queries on larger table sizes. 42,000 records is not really that big for Quickbase but they seem to be going very cautiously on these formulas. They are afraid the Formula Queries will hurt the performance of the app and the platform.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------I may be partly to blame for the throttling. I opened a support case because all of my apps in the realm went offline when I tried to save a formula query. a couple days after they closed the ticket is when I saw that message for the first time.
It's interesting that they can present something in one of the empower workshops this year and show a query working on a data set of over 300k records, but cannot deliver that performance in production.
------------------------------
Paul Peterson
------------------------------
