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
------------------------------
Question
Formula Query - Size ?
This topic has been closed for replies.
+24try this
var text Query = "{'192'.EX.'1'}" checkbox fid is 192
Size(GetRecords($Query), [_DBID_Table Alias]))
Let me know if that works. 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.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
var text Query = "{'192'.EX.'1'}" checkbox fid is 192
Size(GetRecords($Query), [_DBID_Table Alias]))
Let me know if that works. 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.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.