Rollup - Not working

[Danielle_Quinto]

I’m attempting to use the Rollup feature for the first time, and it isn’t working as expected. I have a very simple design – A campaign table that will display rolled-up data from an Invoice table.

Campaign Table:

Here are the settings for one of my Rollup fields:

Invoice Table:

I want the rows of the Invoice table to aggregate based on Campaign ID/Record ID.

Unfortunately, you can see that it is only linking one of the invoice rows – not both of the qualifying Campaign IDs.

What am I doing wrong?

[kuovonne]

Welcome to the Airtable community!

Danielle_Quinton:

Unfortunately, you can see that it is only linking one of the invoice rows – not both of the qualifying Campaign IDs.

A rollup field will not link records for you. You must link the records yourself. The rollup bases its calculations on only existing linked records.

[Danielle_Quinto]

I did create the link

So why isn’t it linking all of the invoices for “abc” to this record?

Why is it only linking to one of the records?

What do I need to do differently?

Danielle

[kuovonne]

When you create a linked record, you create a link to a specific record in the other table, not to all records with a similar value. Thus, you linked to one specific “abc” record, not to all records with “abc” in the {Campaign ID} field.

If you want to link to all records with “abc” in the {Campaign ID} field, you must link them all individually. You can create the links from either table.

This is one way that Airtable is very different from other relational databases.