Forum Discussion
DenisRochat
Qrew Trainee
1. Is the phrase "Water Trmt" actually in the data? verified
2. Is brravks49 the correct target table? verified
------------------------------
Denis Rochat
------------------------------
DenisRochat
3 months agoQrew Trainee
That was embarrassing.
Thank you for helping me with thus. Unfortunately, it still does not work.
------------------------------
Denis Rochat
------------------------------
- MarkShnier__You3 months agoQrew 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
------------------------------- DenisRochat3 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
------------------------------