Forum Discussion
Puzzling.
This is probably not the problem, but I always include a space before and after the AND
var text QUERY =
"{362.EX.'" & [Testing ESL Level] & "'}" & " AND "&
"{3.LTE.'" & [Placement ID] & "'}" & " AND "&
"{344.CT.'" & "ESL" & "'}" ;
Are you sure when you found extra records in each group that they were within the same ESL Level? And also in the example above, obviously there will be many A's (I guess 1000 of them) because you started at 1000 and also the last group jumps up to 19,000. I suppose you have ~ 20,000 records?
Also I assume that you renamed your [Record ID#] field to be called [Placement ID]
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Hi Mark
yes, ten records per group if they are on the same level
the ranking part of the formula was just a test if I place back your original ranking distribution,
yes placement ID original was {Record ID#].
Fields 344 and 362 are formula fields that combine lookup view field types. So, I duplicated both fields to pretend there were data user input fields, so when I made those changes, your formula performed flawlessly ( 10 records per group and same level). Did you know if formula query cannot be used with formulas that use a lookup view field? Or did you know how to use lookup view fields in formula queries?
------------------------------
Data System Analyst (Administrator)
------------------------------
- MarkShnier__You4 months agoQrew Champion
I'm not aware of any limitations like that with using lookup fields in an FQ. I suggest a support ticket and post back if you have found a bug in FQs.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------