Skip to main content

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?

Welcome to the Airtable community!





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.

Welcome to the Airtable community!





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.


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

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.

Reply


Terms & Conditions