Forum Discussion
MarkShnier__You
Qrew Champion
If you would like I can have a quick look at your app. Please contact me directly by my email address in my signature line.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
DenisRochat
3 months agoQrew Trainee
I sent you an email.
------------------------------
Denis Rochat
------------------------------
- MarkShnier__You3 months agoQrew Champion
Just to close the loop.
We changed the formula like this. I writing it vertically like this we were able to comment out the different conditions one by one to find out who the culprits were and we simplified the syntax.
var text QUERY ="{145.OAF." & ToText(FirstDayOfMonth([Month (First Day)])) & "}"& " AND "& "{145.OBF." & ToText(LastDayOfMonth([Month (First Day)])) & "}"& " AND "& "{80.CT.'Qualified'}"& " AND "& "{81.CT.'Water Trmt'}";Size(GetRecords($QUERY, "brravks49"))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------