Forum Discussion
I can't really see a problem with your formula. So I'm sort of grasping at straws.
1. Is the phrase "Water Trmt" actually in the data?
2. Is brravks49 the correct target table?
3. Maybe try this
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" & " '}";
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
I tried the formula you posted and now I am getting:
Formula syntax error
A formula cannot end with an assignment to a variable declaration.
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" & " '}";
I also tried it without ToText and got the same error.
------------------------------
Denis Rochat
------------------------------
- MarkShnier__You3 months agoQrew Champion
Well you still need this part ofter you define the Query
Size(GetRecords($QUERY, "brravks49"))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------ - DenisRochat3 months agoQrew Trainee
1. Is the phrase "Water Trmt" actually in the data? verified
2. Is brravks49 the correct target table? verified
------------------------------
Denis Rochat
------------------------------- DenisRochat3 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
------------------------------