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
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.