Skip to main content
Solved

Issue with Automations counting all records in Linked fields

R

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!

Best answer by TheTimeSavingCo

Rob_Jameson wrote:

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) ?


 

 


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!

View original
Did this topic help you find an answer to your question?

4 replies

TheTimeSavingCo
Forum|alt.badge.img+18

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!

 

Adam, Consultant @ The Time Saving Co
R
  • Rob_Jameson
  • Author
  • Known Participant
  • 10 replies
  • February 5, 2025

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) ?


 

 

TheTimeSavingCo
Forum|alt.badge.img+18
Rob_Jameson wrote:

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) ?


 

 


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!

Adam, Consultant @ The Time Saving Co
R
1 person likes this
  • R
    Rob_Jameson
R
  • Rob_Jameson
  • Author
  • Known Participant
  • 10 replies
  • February 7, 2025

Adam, phenomenal... THANK YOU!! That taught me a lot an makes sense now that I see how you've done things.

Cheers!

TheTimeSavingCo
1 person likes this
  • TheTimeSavingCo
    TheTimeSavingCo

Reply


Most helpful members this week

Terms & Conditions