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
I will bet you a hamburger that you can write a query that matches those parameters but it will not work. That is too many variables for a formula query to swallow. I will often get the failure message when my only parameter is
{3.EX.'" & [Record ID#] & '"}
Formula queries are very fragile. I crippled a clients main application last week when I was testing what I though was a small one. I had to open a Support Case to get the application back up and running. The complexity of the query, yours is very high, and the size of the table combine to cause the instability.
- MarkShnier__You
Qrew Legend
Actually, 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.
