# Get an average of scores from Airtable

**URL:** <https://community.thunkable.com/t/get-an-average-of-scores-from-airtable/1595500>\
**Category:** Questions about Thunkable X\
**Tags:** beginner\
**Created:** [November 3, 2021, 1:22pm UTC](https://community.thunkable.com/t/get-an-average-of-scores-from-airtable/1595500 "2021-11-03T13:22:01Z")\
**Posts on this page:** 4\
**Page:** 2

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [November 7, 2021, 4:43pm UTC](https://community.thunkable.com/t/get-an-average-of-scores-from-airtable/1595500/21 "2021-11-07T16:43:12Z")

</div>

I made a quick project for your review.  
[https://x.thunkable.com/projectPage/6187ef95280f1a0010dac7e7](https://x.thunkable.com/projectPage/6187ef95280f1a0010dac7e7)

The idea is to create a group. I created it by looping through the records and filling a list. Ideally you want to create the grouping inside Airtable.

See this example

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/6/9674f4537930c7403df131efb8c4c55791295b82.png)  
I’m here making a column as a group which adds two fields together within Airtable by doing this  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/8/58865b35ef4bf49ad4d62b1edf3f2a06953fc6a0.png)

Now that I do not have access to your table to add a column, I did the grouping in Thunkable. Once the grouping is done, I then filled the list with group names from the list without repeating the names. (I made the names from the 3 columns with “||” as separator.

When you click on the item in the list, I loop through the main list to count the entries and total the scores and in the end I display the average.

Hope this helps.

---

<div class="post-metadata">

**Author:** ![brunospavei2kqs](https://avatars.discourse-cdn.com/v4/letter/b/bbe5ce/32.png) [@brunospavei2kqs](https://community.thunkable.com/u/brunospavei2kqs)\
**Post date:** [November 7, 2021, 9:35pm UTC](https://community.thunkable.com/t/get-an-average-of-scores-from-airtable/1595500/22 "2021-11-07T21:35:46Z")

</div>

It’s work!!  
I tested just for today, then I’ll se in other “local” and days.  
Thanks very much for all!  
Maybe I come back here :]

---

<div class="post-metadata">

**Author:** ![brunospavei2kqs](https://avatars.discourse-cdn.com/v4/letter/b/bbe5ce/32.png) [@brunospavei2kqs](https://community.thunkable.com/u/brunospavei2kqs)\
**Post date:** [November 7, 2021, 9:36pm UTC](https://community.thunkable.com/t/get-an-average-of-scores-from-airtable/1595500/23 "2021-11-07T21:36:43Z")

</div>

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/5/65a594a74d3f4a25a869d5e64c54918b969f0132.png)

---

<div class="post-metadata">

**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\
**Post date:** [November 8, 2024, 1:14pm UTC](https://community.thunkable.com/t/get-an-average-of-scores-from-airtable/1595500/24 "2024-11-08T13:14:31Z")

</div>

Closed on November 8, 2024, 1:14pm UTC



[Previous page](https://community.thunkable.com/t/get-an-average-of-scores-from-airtable/1595500.md?page=1)