+11What's wrong with this query format. I have checked all the values and I should be getting values other than zero.
SumValues(GetRecords("{80.EX.'"&[Concate Distance]&"'}and{47.EX.'Shipping'}and {66.XEX.0}",[_DBID_DISTANCES]),66)
If I don't have the "and' filters QB gives me the error"Uh-Oh! The way this formula is built will take too long to process. Please try refining your formula."
Best answer by Denin
The API has good performance. You could try the same query in the API and see if you get the results you need then use AI to create a basic code page for that API query.
See here:
https://developer.quickbase.com/operation/runQuery
You can just fill in the blanks and it will basically make the API query for you under code sample tab. Recommend to use Javascript ES6.
+11In various webinars, I remember it's mentioned how formula queries have issues at scale. How many records do you have?
+112.6 million records. I guess a query is not the solution here. Unfortunately, I'll to make one more table relationship to add to my spaghetti web all just to retrieve one field value from the remote table.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
