
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 17, 2019 03:18 PM
I am have two tables.
In table 1, I have:
- a (non-primary) field with 3 single select options (let’s call it field A)
- a field linked to records in table 2 (field B)
In table 2 , I have:
- the table’s primary field, from field B in table 1 (field C)
- a field that counts the number of linked records (field D)
I would like to filter the field that counts the number of linked records (field C) in table 2 so it only counts for one of the 3 single select field (field A) in table 1.
I looked around the forum, and some answers seemed to deal with the same issue but I could not get any to work for my case.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 17, 2019 04:22 PM
Make a Formula field ({Field E}
) in [Table 1]
: IF({Field A}='Desired single select option',1)
. You can hied this field from view.
Add a Rollup field ({Field E}
) to [Table 2]
to sum the values of `{Field E})

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 17, 2019 04:22 PM
Make a Formula field ({Field E}
) in [Table 1]
: IF({Field A}='Desired single select option',1)
. You can hied this field from view.
Add a Rollup field ({Field E}
) to [Table 2]
to sum the values of `{Field E})
