Hello AirTable community! I am trying to create a separate table that takes just the created by name, their email, and the number of approved records they have (in this case, approved is referring to any record in the original table that receives a check mark) from the create table, and populate just those values in the notify table. The values are populated in there through an automation (if record has a check mark in the create table, put these specific values into the notify table)
The issue I'm running into is that in the notify table, if a user has multiple records approved, then their name will appear multiple times. I would prefer it to be their name, their email, and then a column with a summed up numbers of how many records they've had approved ( want it to be a real time moving number). I cannot figure it out for some reason. Please help, thank you!!
Current Output
| Created By Name | Email | Number of Records |
| Spongebob SquarePants | ssquarepants@bikinibottom.com | 1 |
| Spongebob SquarePants | ssquarepants@bikinibottom.com | 1 |
| Patrick Star | pstar@bikinibottom.com | 1 |
| Patrick Star | pstar@bikinibottom.com | 1 |
| Patrick Star | pstar@bikinibottom.com | 1 |
| Mr. Krabs | mkrabs@bikinibottom.com | 1 |
Desired Output
| Created By Name | Email | Number of Records |
| Spongebob SquarePants | ssquarepants@bikinibottom.com | 2 |
| Patrick Star | pstar@bikinibottom.com | 3 |
| Mr. Krabs | mkrabs@bikinibottom.com | 1 |
