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
MarkShnier__You
Qrew Legend
Qrew LegendThere is not currently a way to process the returned records to get the max value. Maybe in the future, but Formula Queries do not support Max at this time.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
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__YouHow large is your table, how many records?
------------------------------
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
------------------------------