![Rob_Jameson Rob_Jameson](https://community.airtable.com/legacyfs/online/avatars/3X/f/0/f0a86569213417062b742c3ae55180239661db2d.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 04, 2025 06:16 PM
Hi everyone,
I've been struggling with counting all records from table A in table, B. I've read multiple forum posts and watched videos, but something is still not working ... so I've come here to ask for any insights.
My understanding is that I need to put all records from Table A into a single linked field in Table B, and then use a Count field to count them. So I set this up, like in the image
Then, I went to Automations and set up two steps:
Step one: look for any records and table that are not empty. (Table A is called "Entries" in my base)
Step Two: Add an "update record" where the "Table" is the Table B ("Metrics" for me), Record ID is of where I want all the linked records to show, and under "Fields" I added the linked field, and said to show a "List of Records"...
This gives "received invalid inputs"... Ive tried all the variations of this I can think of, which all result in this error....
Can anyone advise me on the solution? Also, I just want to confirm this will work as I'm imagining, where whenever a record is added/removed from Table A, this linked field will be updated automatically.
Thank you for the help!
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 05, 2025 11:24 PM
Ah, to apply it to all your existing records try pasting the 'Rollup' value into the entire column:
---
Also, how would I adjust if I wanted to show a count that meets a condition next to this? For example, on my rollup table, I want to show the count of all entries (which we've nearly solved) AND in the next column, the count of only entries with a multiselect choice of "option A)
Try using conditional filtering for that:
And I've updated the original base with this stuff too!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 04, 2025 10:59 PM
Does this look right?
If so, I'd recommend trying this:
This automation will trigger whenever a record is created and will link it to a single record in the other table, which will update the 'Count' field like you want
And yeap, it'd work like you want, once you add / delete a record from Table A it'd update the count on the other table
And I've set it up for you here!
![Rob_Jameson Rob_Jameson](https://community.airtable.com/legacyfs/online/avatars/3X/f/0/f0a86569213417062b742c3ae55180239661db2d.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 05, 2025 05:22 AM
holy wow!! Thank you @TheTimeSavingCo !!!
This is nearly it ...
My use case already has 4000 rows of data in Table A. How would I adjust this to add all the records I already have?
Also, how would I adjust if I wanted to show a count that meets a condition next to this? For example, on my rollup table, I want to show the count of all entries (which we've nearly solved) AND in the next column, the count of only entries with a multiselect choice of "option A) ?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 05, 2025 11:24 PM
Ah, to apply it to all your existing records try pasting the 'Rollup' value into the entire column:
---
Also, how would I adjust if I wanted to show a count that meets a condition next to this? For example, on my rollup table, I want to show the count of all entries (which we've nearly solved) AND in the next column, the count of only entries with a multiselect choice of "option A)
Try using conditional filtering for that:
And I've updated the original base with this stuff too!
![Rob_Jameson Rob_Jameson](https://community.airtable.com/legacyfs/online/avatars/3X/f/0/f0a86569213417062b742c3ae55180239661db2d.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 07, 2025 04:30 AM
Adam, phenomenal... THANK YOU!! That taught me a lot an makes sense now that I see how you've done things.
Cheers!
![](/skins/images/DD0CD7D0ACF200EF4456420D87029A3D/responsive_peak/images/icon_anonymous_message.png)