Forum Discussion

AndreonnaGarret's avatar
AndreonnaGarret
Qrew Assistant Captain
7 years ago

Formula based on the number of records in a report link?

So I have a report link on a record that references back to the same table. Is there a way to build a formula based on the number of records on this report? Since it's not a relationship I can't add a...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
I suggest that you in fact make a relationship of the table to itself.

Make a formula field called [Part # mirror] with a formula of [Part #]

Use that field in the right side of the relationship. Then make a summary field. It will show up weird looking in the relationship, but it will work.
  • AndreonnaGarret's avatar
    AndreonnaGarret
    Qrew Assistant Captain
    7 years ago
    Does the formula field have to be numeric for this to work? Because out part number fields are text due to being alphanumeric. 
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    They do not need to be numeric, but the key field of the table would need to be set to be the Part # field.

    If the key field the table is currently Record ID number and you have a never change the key field before, then I suggest making a copy of your app and practicing on a copy first.