Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Search for sum of records from another table

Topic Labels: Base design
Solved
Jump to Solution
498 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi everyone,

I would like count the number of records form another table.
For example, I have created a table with all the payments that the company receives, and they are linked to the customer master record.

But I would like to add a control in the customer table of the number of payments made by this customer (the number of records, because a payment is represented by a line).

Is there a way to search a second table and count the number of records for a client?
Many thanks in advance for your help.

Have a very nice day.
Alexia

1 Solution

Accepted Solutions

A rollup field can give you the sum of the values in all the linked records.

A count field can give you the number of linked records.


If this answers your question, please mark this post as the solution. Otherwise, could you please give a bit more details and a screen capture?

See Solution in Thread

2 Replies 2

A rollup field can give you the sum of the values in all the linked records.

A count field can give you the number of linked records.


If this answers your question, please mark this post as the solution. Otherwise, could you please give a bit more details and a screen capture?

Awesome!! You help me a lot. Thank You so much for your quick reply.
Have a nice day.
Alexia