# Relation Rollup based on field value

**URL:** <https://community.glideapps.com/t/relation-rollup-based-on-field-value/70363>\
**Category:** Ask for Help\
**Created:** [February 1, 2024, 1:36pm UTC](https://community.glideapps.com/t/relation-rollup-based-on-field-value/70363 "2024-02-01T13:36:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Connor\_Finlayson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/connor_finlayson/32/79079_2.png) [@Connor\_Finlayson](https://community.glideapps.com/u/Connor_Finlayson)\
**Post date:** [February 1, 2024, 1:36pm UTC](https://community.glideapps.com/t/relation-rollup-based-on-field-value/70363/1 "2024-02-01T13:36:18Z")

</div>

Hi,

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.

I.e.

**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

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [February 1, 2024, 1:57pm UTC](https://community.glideapps.com/t/relation-rollup-based-on-field-value/70363/2 "2024-02-01T13:57:03Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Connor\_Finlayson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/connor_finlayson/32/79079_2.png) [@Connor\_Finlayson](https://community.glideapps.com/u/Connor_Finlayson)\
**Post date:** [February 1, 2024, 2:08pm UTC](https://community.glideapps.com/t/relation-rollup-based-on-field-value/70363/3 "2024-02-01T14:08:14Z")

</div>

Worked flawlessly! Thanks Jeff!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [February 8, 2024, 2:09pm UTC](https://community.glideapps.com/t/relation-rollup-based-on-field-value/70363/4 "2024-02-08T14:09:12Z")

</div>

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