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