Forum Discussion
Here is an example
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
HI Mike.this is awsome
I made all modifications but placed all records with the letter "A" the max of records per letter needs to be 10 max
var text QUERY = "{344.CT.'" & "ESL" & "'}" &
"{362.EX.'" & [Testing ESL Level] & "'}" &
"{3.LTE.'" & [Placement ID] & "'}";
var number Ranking =Size(GetRecords($QUERY));
If(
$Ranking <=10, "A",
$Ranking <=20, "B",
$Ranking <=30, "C", "Z"
)
------------------------------
Data System Analyst (Administrator)
------------------------------
- ChayceDuncan5 months agoQrew Captain
Just a suggestion looking at your query - formula queries are both very powerful but finicky in their performance if implemented less than optimal. In your first query parameter you're doing a contains statement - if possible you should try and swap that to be EX so its more efficient for QB than doing a string contains query. If you're not able to - I would refactor the order of your query so that the CT is the last thing you're doing. The idea being you want to minimize the work QB has to do so something like:
"{362.EX.'" & [Testing ESL Level] & "'}" & "AND"
"{3.LTE.'" & [Placement ID] & "'}" & "AND" &
"{344.CT.'" & "ESL" & "'}";
------------------------------
Chayce Duncan
------------------------------- Data_SystemAnal4 months agoQrew Cadet
Hello. Thank you for the suggestion; I haven't been able to find the solutions, even with your help. I will keep digging to find a solution. Thank you both.
------------------------------
Data System Analyst (Administrator)
------------------------------- MarkShnier__You4 months agoQrew Champion
Sorry, I assumed from your last response that we had this solved. Can you show (copy paste) your current code and explain what the problem is now?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------