+13We’re planning a competition. I’ll have Attendees and Teams. Teams are made up of Attendees (two or four members per team). I want two columns on the Teams table: (1) a count of the number of checked-in members of that team and (2) a total count of members of the team.
The Attendees table will have a Checked-In field that is a Checkbox. Ideally, this would be the field that is being counted IF they are a member of the team.
+13Well this is embarrassing but it turns out this is the default behavior of the Rollup field! :grinning_face_with_sweat: :grinning_face_with_sweat: I became confused by the UI of the field and thought it was going to count all checked-in records in the linked table and not only the linked records for that team.
:skull:
Well this is embarrassing but it turns out this is the default behavior of the Rollup field! :grinning_face_with_sweat: :grinning_face_with_sweat: I became confused by the UI of the field and thought it was going to count all checked-in records in the linked table and not only the linked records for that team.
:skull:
What is “Checked in”? You also have a Count field type: https://support.airtable.com/hc/en-us/articles/202576519-Guide-to-formula-lookup-count-and-rollup-fields#count
+13What is “Checked in”? You also have a Count field type: https://support.airtable.com/hc/en-us/articles/202576519-Guide-to-formula-lookup-count-and-rollup-fields#count
Really sorry if I’m being presumptuous but did you maybe not read my comments? :winking_face: I answered my own question in my second post and the answer to your question is in the second paragraph of my first post:
The Attendees table will have a Checked-In field that is a Checkbox.
+4Really sorry if I’m being presumptuous but did you maybe not read my comments? :winking_face: I answered my own question in my second post and the answer to your question is in the second paragraph of my first post:
The Attendees table will have a Checked-In field that is a Checkbox.
Your brain clicks in right after you press the submit button.
Really sorry if I’m being presumptuous but did you maybe not read my comments? :winking_face: I answered my own question in my second post and the answer to your question is in the second paragraph of my first post:
The Attendees table will have a Checked-In field that is a Checkbox.
I mean in the “real world”, just trying to figure out the best way to solve your situation.
+13I mean in the “real world”, just trying to figure out the best way to solve your situation.
Ah OK. My apologies. Overall, my issue was solved once I realized how Rollup actually works. Also, I am using Count in another field “Total Members”. These two fields combined give me the ability to create a 3rd field (Formula) like this: “75% (3/4)”.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
