Mar 20, 2021 06:21 PM
I have a phone-log table with times of phone calls organized by date. Sometimes there are multiple calls to the same numbers for each date. I have a field that shows the length of the calls. Is it possible to TALLY or ADD the total duration of all calls to one number? Right now my calendar looks like:
0:05
0:18
0:03
0:28
1:05
0:04
When I would prefer to just have one entry saying: 2:05 – Is this possible?
Apr 01, 2021 02:38 PM
Hello @Ramsey_Stoneburner!
This is definitely possible in a couple of ways, depending on what works best for your workflow. With a little table restructuring you could do this with three tables in on base. The first table would track Dates:
The second table for would track individual phone calls (one field linking to the date and one field linking to the phone numbers table) with a duration for each call:
The third table would track each phone number and include a total duration of the call:
The Total Call Duration field is a Rollup field that sums up the duration of all the calls:
If you’d like to learn more about this kind of table structure I recommend reading our article on Joins tables.
Another possible workflow could be achieved using Airtable Automations to update an existing phone number record’s total call duration if it already exists in a table.
Let me know if I can help provide any more information, and if this helped answer your question please mark it as the solution :white_check_mark: .