I am trying to create a simple rollup field that counts the number of check boxes from a linked table for attendance purposes.
I create the rollup field like this:
You can see that Abdelnasir and Aamir both have at least one check mark for attendance:
However nothing changes and the rollup field shows zero:
I’ve literally done this exact same thing before and it worked fine, but now I cannot figure why this time it is not working. Any ideas? (Note: I’ve also tried this with the Count field to no avail)
Solved! Go to Solution.
You’re missing the formula to apply to your rolled up values (last input field on the configuration – TBH, I’m surprised Airtable let you create that field without a formula). In your case, I assume that would be
SUM(values). If that is correct, and as BTW, you do not need to filter your Attended? checkbox in the rollup, because unchecked boolean fields count as 0 and checked ones as 1, so the
SUM(values) alone will give you the correct result.
And, just to make sure, you do have the records of the people you are trying to roll up attendance for linked to one or more “English Calendar” records, yes? Apologies for asking something so basic, but sometimes, it is a matter of “is it plugged in?” :grimacing:
Hmm … judging from your screenshot, that “Contact” field does not contain linked records, but some kind of literal data (linked fields have a faint blue box around then, as seen in your “Class” field). I wonder what is going on there?