Skip to main content
Question

Formula Query Error - The way this formula is built will take too long to process.

  • April 11, 2022
  • 0 replies
  • 234 views
Forum|alt.badge.img+6
Is URLEncode() not functional inside of a Formula Query? When I attempt to use it, I receive this error message.

Here is my formula:
Size(GetRecords("{52.EX." & URLEncode([Job]) & "}AND{276.XEX.2}AND{276.XEX.3}AND{276.XEX.5}AND{55.EX.''}", [_DBID_FABRICATIONS]))

// fid: 52 [Job]
// Issued For Fabrication Status
// fid: 276 [Related IFF Status] is not equal to:
// 2 - On Hold
// 3 - Cancelled
// 5 - Prerelease
// fid: 55 [Scope Item Name] is equal to null

Trying to avoid creating a table to table relationship to get this value. I'm getting this same error on another formula query to a different table where I am also using URLEncode().


------------------------------
Jon Froderberg
PRIME Developer
Harder Mechanical Contractors
https://www.harder.com
Portland, OR
801.946.0576
------------------------------
Jon Froderberg PRIME Developer Harder Mechanical Contractors https://www.harder.com Portland, OR 801.946.0576
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • April 11, 2022

I doubt it has to do with URLEncode. 

Here are some tips that might help but your table maybe too large for Formula Queries to handle. 


https://help.quickbase.com/user-assistance/formula_queries.html#Performance



------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+16
  • MikeTamoush
  • Quickbase Alumni
  • April 11, 2022
I get that error a lot when I'm trying to find duplicate values in a large table (30,000+ records).

Are you querying a large table?

------------------------------
Mike Tamoush
------------------------------
Forum|alt.badge.img+6
  • JonFroderberg
  • Author
  • Quickbase Alumni
  • April 11, 2022
It appears I will not be able to use formula query for my need as the table being queried has too many records and/or fields.  I will switch tactics and implement a table relationship to get the value I need.  Some guidance in the Formula Query documentation would be helpful as to what record count or table complexity may be too much for the function(s) to handle.

------------------------------
Jon Froderberg
PRIME Developer
Harder Mechanical Contractors
https://www.harder.com
Portland, OR
801.946.0576
------------------------------
Jon Froderberg PRIME Developer Harder Mechanical Contractors https://www.harder.com Portland, OR 801.946.0576
    Terms & ConditionsAccessibility statement