Size(GetRecords Formula Query
I am trying to populate a table named Metrics using formula queries. I populated several fields from the Opportunities table with no problem. See Attachment. I am trying to populate # QWT Leads (numb...
Forum Discussion
What field type is this field?
[Month (First Day)]
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Month (First Day)] is a Date field.
Lead Status and Lead Type are Multiple Choice.
------------------------------
Denis Rochat
------------------------------
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
------------------------------Well you still need this part ofter you define the Query
Size(GetRecords($QUERY, "brravks49"))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
