Forum Discussion

GeorgeBramhall2's avatar
GeorgeBramhall2
Qrew Cadet
1 month ago
Solved

Query giving values of zero

What'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....
formula query
  • Denin's avatar
    Denin
    1 month ago

    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. 

     

GeorgeBramhall2's avatar
GeorgeBramhall2
Qrew Cadet
1 month ago

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

  • Denin's avatar
    Denin
    Qrew Captain
    1 month ago

    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.