Relation Rollup based on field value


I am trying to figure out how I can get a count of records in a relation field based on a value in the related records field.


Table A
Name, Relation, Rollup Count (of records with “Active”)
Record A, [Relation A, Relation B, Relation C], 2

Table B
Name, Status
Relation A, Active
Relation B, Active
Relation C, Inactive

I would use a Query column instead of a Relation, so you can specify additional criteria in the query. Then do your Rollup using the Query column.


Worked flawlessly! Thanks Jeff!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.