I have a Project Table and a Tasks Table that are related. I would like to either check a box or count the number of specific tasks that are marked Completed. I tried doing it this way but it doesn't work:
So if 3 Specific Tasks are marked "Complete" (which is a checkbox based on a date field) then I can mark the Cabinet as having been Installed.
I also tried the beginning of a formula query using just one field and it didn't work either:
Size(GetRecords("{6.EX'Set Cabinet'}and{19.EX'true'}",[_DBID_TASKS]))
Any help would be appreciated
------------------------------
Thomas Ringkamp
------------------------------
Question
Distinct Count for Multiple Tasks in Related Table
This topic has been closed for replies.
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.