GetFieldValues Query Question
GetFieldValues(GetRecords("{17.EX.'" & [Consignee - Related Consumer] & "'}and{7.EX.'" & [Load # - Description] & "'}",[_DBID_PRICE_HISTORY]),19) Can anyone tell me what is wrong with this query, I...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI believe that the the "and" is incorrect. I believe it is case sensitive and also I think it needs spaces.
Try this standardized syntax. The syntax is so difficult and the formula editor does not help much for Formula Queries, I try to keep mine very standard like this.
var text QUERY =
"{17.EX.'" & [Consignee - Related Consumer] & "'}"
& " AND "
& "{7.EX.'" & [Load # - Description] & "'}";
GetFieldValues(
GetRecords($QUERY, [_DBID_PRICE_HISTORY]),19)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Try this standardized syntax. The syntax is so difficult and the formula editor does not help much for Formula Queries, I try to keep mine very standard like this.
var text QUERY =
"{17.EX.'" & [Consignee - Related Consumer] & "'}"
& " AND "
& "{7.EX.'" & [Load # - Description] & "'}";
GetFieldValues(
GetRecords($QUERY, [_DBID_PRICE_HISTORY]),19)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
No spaces on the AND, it does need to be capitalized though.
So in the query it should look like:
GetFieldValues(GetRecords("{17.EX.'value'}AND{7.EX.'value'}",[_DBID_PRICE_HISTORY]),19)
------------------------------
Dwight Munson
------------------------------