Expanded URL to Formula Query
Hello, I am hoping someone much smarter than I can help solve this puzzle. I have a report on an activities table. I want to search the same parameters that the report has within a size(GetRecords(...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendActually, I'm with Don here. What I always do with anything remotely complex is to make a formula checkbox field to match the report filters. Then check that the record count matches for qualifying records. Then the formula query is stupid simple.
var text QUERY = "{99.EX.1}";
Size(
GetRecords($QUERY))
// Replace the 99 with the formula checkbox field ID#
This is a much better idea than putting the pieces in a formula query.