Skip to main content
Question

calculate # of records that have a specific value

  • April 27, 2018
  • 0 replies
  • 35 views
I'm trying to calculate the number of records that share a specific value, and I want this number to appear in each record. For example if 5 out of 10 records have value x in field y, I want every record with value x to show the number 5. 

Does anyone know how to do this easily? I'm looking at the API_GetNumRecords, but I'm not sure how to deploy it. 
    This topic has been closed for replies.

    • ChrisChris
    • Quickbase Alumni
    • April 27, 2018

    If you have a parent table related to the table in question, you can set up a custom summary field in the parent that summarizes the number of child records where = "x". I'm taking you literally. You will have an easier time of doing what you want this way. Then, you can pass the value back into the child table as a lookup field.

    Terms & ConditionsAccessibility statement