Help

Re: Lookup Field and Count are not working for me

Solved
Jump to Solution
3214 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Justin_Thomas
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello everyone!

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:
Screen Shot 2021-08-31 at 2.23.44 PM

You can see that Abdelnasir and Aamir both have at least one check mark for attendance:
Screen Shot 2021-08-31 at 2.11.03 PM

However nothing changes and the rollup field shows zero:
Screen Shot 2021-08-31 at 2.09.37 PM

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)

Thanks!
Justin

1 Solution

Accepted Solutions
Martin_Kopischk
7 - App Architect
7 - App Architect

If that link was lost, the counterpart on the contacts table was orphaned, too; you might have duplicate linked columns there now. Check your rollup if it points to the correct linked one …

See Solution in Thread

9 Replies 9
Martin_Kopischk
7 - App Architect
7 - App Architect

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.

Yeah, sorry I just updated the screenshot. I used the COUNTALL(values) formula because I wasn’t sure the SUM would work

OK, just tried the SUM formula unfiltered and then filtered and neither of them are changing the rollup values. This is just really weird.

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:

Yes, I believe so. This is what “English Calendar” looks like. The contact name is linked to the “All Contacts” table and I am trying to add the rollup field to the “All Contacts” table.

Screen Shot 2021-08-31 at 2.45.10 PM

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?

You’re right, somehow that was changed from linked to text. So, I’ve changed it back and still no luck.

Screen Shot 2021-08-31 at 2.54.12 PM

Martin_Kopischk
7 - App Architect
7 - App Architect

If that link was lost, the counterpart on the contacts table was orphaned, too; you might have duplicate linked columns there now. Check your rollup if it points to the correct linked one …

Ahhhhhhhhhhh, perfect! There were 3 iterations of “English Calendar” and they were all hidden fields. So, I deleted 2 of them and made sure the one left was the true link between tables. All is working now. Thank you for your help, my friend!

Justin