I use AirTable to manage membership in my local organization. I have a table with the member data including their dues owed. In another table I upload the payroll reports every other week when they come. I can group those records by employee ID to see the total they have paid and compare it manually to the amount they owe. I would love to have AirTable do that part for me. I can’t figure out how to get the total amounts from the grouped records to automatically populate to the original table.
So what I want is the sum of the records attached to the user ID to be displayed in the other table in the record for the user. Does that make sense?