# Airtable Summary

**URL:** <https://community.thunkable.com/t/airtable-summary/1055918>\
**Category:** Questions about Thunkable X\
**Created:** [January 18, 2021, 1:14pm UTC](https://community.thunkable.com/t/airtable-summary/1055918 "2021-01-18T13:14:05Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![1604796tj](https://avatars.discourse-cdn.com/v4/letter/1/bc8723/32.png) [@1604796tj](https://community.thunkable.com/u/1604796tj)\
**Post date:** [January 18, 2021, 1:14pm UTC](https://community.thunkable.com/t/airtable-summary/1055918/1 "2021-01-18T13:14:05Z")

</div>

G’day

So my app extracts and uses data populated in Airtable, all working well.

Airtable has a summary row at the bottom of the fields… question; can I lift this data into my app?  
or do I have to pull airtable down into a list and then sum the list?

Thanks in advance.

 ![Screenshot from 2021-01-18 13-10-42](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/5/8509ce4f1fdf4e0a784c733ecae7a942509a276f.png)

---

<div class="post-metadata">

**Author:** ![1604796tj](https://avatars.discourse-cdn.com/v4/letter/1/bc8723/32.png) [@1604796tj](https://community.thunkable.com/u/1604796tj)\
**Post date:** [January 22, 2021, 1:07pm UTC](https://community.thunkable.com/t/airtable-summary/1055918/2 "2021-01-22T13:07:40Z")

</div>

Ok guess that’s not possible then.

So alternatively I’m trying to create a list from an airtable column, then I’ll sum the list I’ve create.

If a cell does not have data (number) in it… do I have to do some kind of verification/validation to prevent a an error in the list such as NaN?

 ![Screenshot from 2021-01-22 12-37-15](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/0/80fb0739f738d8a29dd2ab85e1232e991f59f421.png)

---

<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:** [January 22, 2021, 3:21pm UTC](https://community.thunkable.com/t/airtable-summary/1055918/3 "2021-01-22T15:21:21Z")

</div>

Use this component  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/6/e6af9dc6208b52b2fc5e7f1660b77ed055bc31d7.png)

It will get all values in the selected column and assign it to a list variable.

From the List drawer you can use  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/1/115cf7f2362c34b556b8be34166cbf6d92009f44.png)

To get the total of that column in the table.

You can then repeat the same for each column you want to get it’s total.

---

<div class="post-metadata">

**Author:** ![1604796tj](https://avatars.discourse-cdn.com/v4/letter/1/bc8723/32.png) [@1604796tj](https://community.thunkable.com/u/1604796tj)\
**Post date:** [January 23, 2021, 11:03am UTC](https://community.thunkable.com/t/airtable-summary/1055918/4 "2021-01-23T11:03:29Z")

</div>

Hi Muneer,

Nice, yes this is much cleaner and does appear to form a list of the numbers… my next problem is that the “sum of list” function does not appear to add add the numbers together and give a sum value.  
When called it present the list of numbers in sequence…?

The airtable column is formatted as Integer and the data entered are integer numbers.

---

<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:** [January 23, 2021, 3:29pm UTC](https://community.thunkable.com/t/airtable-summary/1055918/5 "2021-01-23T15:29:48Z")

</div>

Can you share the blocks or screen capture to understand the issue better

---

<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:30pm UTC](https://community.thunkable.com/t/airtable-summary/1055918/6 "2024-11-08T13:30:41Z")

</div>


