Formula Query - Size ?

Question

I am trying to find the correct syntax to use a Size formula query for all items with a check in a checkbox.

I am trying to use: Size(GetRecords("{##.EX.'yes'}", "????????")) but it is not returning anything. I also tried using 1 and '1'. Nothing is yielding a result at the moment.

------------------------------
Paul Peterson
------------------------------

quickbasejunkie · Answer

@Paul Peterson The issue may be the extra escaped quotes in your Query that aren't necessary.

I'm not sure if you've seen my recent video Query Writing 101, I've added it here.

I also have a number of new Formula Query resources over on the Quick Base Junkie Blog that you may find helpful.

------------------------------
Quick Base Junkie
------------------------------

​------------------------------Quick Base Junkie------------------------------

markshnier__you · Answer

try thisvar text Query = "{'192'.EX.'1'}"&nbsp; checkbox fid is 192Size(GetRecords($Query), [_DBID_Table Alias]))Let me know if that works.&nbsp; One way to generate a query is to run a report or search with filters and then use the old report style and then "More" to show the expanded URL.&nbsp;------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

paulpeterson1 · Answer

I'm getting closer, had to tweak yours a little to get rid of a syntax error "Expecting )"

var text Query = "\"{'196'.EX.'0'}\", \"?????????\""; //checkbox fid is 196 and ????????? is the table ID

Size(GetRecords($Query))

I am getting something, but it is 0 for 1 and 0 and I know there are several thousand records in that table.

------------------------------
Paul Peterson
------------------------------

markshnier__you · Answer

this tested OK for mevar text Query = "{'209'.EX.'1'}";Size(GetRecords($Query,[_DBID_PARENT]))------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

paulpeterson1 · Answer

Finally found my problem.&nbsp; I wasn't handling the table ID correctly.This version actually worked:var text tableID = "????????";var text Query = "{'192'.EX.'1'}AND{'1260'.EX." &amp; [Month]&amp; "}";// &amp; $tableID; //checkbox fid is 192Size(GetRecords($Query, $tableID))I also wanted to refine the search by month.THANK YOU both for your help!!!------------------------------Paul Peterson------------------------------

Forum Discussion

Formula Query - Size ?