Created A,B and C gruop of 10 records
Hello all
I need help
does anybody know a formula for creating a group of 10 records and labeling those records as A, B etch based on levels 1, 2, 3, etc?
Level 1, max 10 records = "A"
...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendPuzzling.
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
------------------------------
When it's all said and done - your syntax all looks functionally ok from below so at face value it's not a syntax issue.
var text QUERY =
"{362.EX.'" & [Testing ESL Level] & "'}" & "AND"&
"{3.LTE.'" & [Placement ID] & "'}" & "AND"&
"{344.CT.'" & "ESL" & "'}" ;
If you're not getting a value at all or not getting a value you're expecting - then it likely has something to do with how you're forming the query. I would suggest picking an arbitrary record and trying to test the 'Ranking' query syntax your testing in a report. So pick a record that you know the general ranking it should be potentially - and then make a temporary report where you set the report filters to be the same as your query and plug in the values for Testing ESL Level and Placement ID against Field 362 and Record ID# and see if the report spits out the # of records you're trying to match. If the number of records is 1007 then you know it's working as intended. If it returns 0 then you know it's not. Then you can modify the report filters to get the results you want to make whatever updates might be needed in the query itself.
------------------------------
Chayce Duncan
------------------------------
Thank you for your follow-up. I find that part of the issue is fields used on the query are lookup field formulas.
------------------------------
Data System Analyst (Administrator)
------------------------------
