Forum Discussion

JonFroderberg's avatar
JonFroderberg
Qrew Cadet
3 years ago

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

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{27...
formula queries
JonFroderberg's avatar
JonFroderberg
Qrew Cadet
3 years ago
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
------------------------------