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.