# Using Airtable as a database **URL:** \ **Category:** Database\ **Created:** [September 9, 2024, 1:47pm UTC](https://forum.bubble.io/t/using-airtable-as-a-database/338664 "2024-09-09T13:47:37Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![dan37](https://avatars.discourse-cdn.com/v4/letter/d/9de053/32.png) [@dan37](https://forum.bubble.io/u/dan37)\ **Post date:** [September 9, 2024, 1:47pm UTC](https://forum.bubble.io/t/using-airtable-as-a-database/338664/1 "2024-09-09T13:47:37Z")
Hello, Im trying to group airtable data to use in charts. I can’t use bubbles group by feature since its an external data source. Has anyone used airtable and know how I can make charts based on in there? Example: I have sales data and i want to show sum of sales by month in a bar chart. ---
**Author:** ![eliot1](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/eliot1/32/215285_2.png) [@eliot1](https://forum.bubble.io/u/eliot1)\ **Post date:** [September 9, 2024, 2:03pm UTC](https://forum.bubble.io/t/using-airtable-as-a-database/338664/2 "2024-09-09T14:03:28Z")
Hi, you can actually use the :groupby feature with external data source but you have to do the API call to get a list of results you can then group by month if you have a date field and aggregate. e.g. with an API call to the Algolia API with a list of hits: ![image](https://us1.discourse-cdn.com/bubble/original/3X/6/f/6f9db9d3fcdd70bfa6d0da0285322080dbd6a713.png) ---
**Author:** ![dan37](https://avatars.discourse-cdn.com/v4/letter/d/9de053/32.png) [@dan37](https://forum.bubble.io/u/dan37)\ **Post date:** [September 9, 2024, 2:16pm UTC](https://forum.bubble.io/t/using-airtable-as-a-database/338664/3 "2024-09-09T14:16:07Z")
Ohh I see. Would you mind explaining how I do that in a quick loom? I am very new to bubble ---
**Author:** ![Baloshi69](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/baloshi69/32/136122_2.png) [@Baloshi69](https://forum.bubble.io/u/Baloshi69)\ **Post date:** [September 9, 2024, 2:24pm UTC](https://forum.bubble.io/t/using-airtable-as-a-database/338664/4 "2024-09-09T14:24:06Z")
Just make the api call to get the data, but make sure you make the call type as **DATA** not action. it will give you a content type to choose in elements and you can use `get external data` to call that api call and get the data. then use `grouped by` to group them by a field. ---
**Author:** ![Baloshi69](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/baloshi69/32/136122_2.png) [@Baloshi69](https://forum.bubble.io/u/Baloshi69)\ **Post date:** [September 9, 2024, 2:39pm UTC](https://forum.bubble.io/t/using-airtable-as-a-database/338664/5 "2024-09-09T14:39:42Z")
See if still stuck, ping me i will help you @dan37 ---
**Author:** ![dan37](https://avatars.discourse-cdn.com/v4/letter/d/9de053/32.png) [@dan37](https://forum.bubble.io/u/dan37)\ **Post date:** [September 9, 2024, 2:52pm UTC](https://forum.bubble.io/t/using-airtable-as-a-database/338664/6 "2024-09-09T14:52:06Z")
thanks will take a look into it and let you know! ---
**Author:** ![dan37](https://avatars.discourse-cdn.com/v4/letter/d/9de053/32.png) [@dan37](https://forum.bubble.io/u/dan37)\ **Post date:** [September 9, 2024, 8:12pm UTC](https://forum.bubble.io/t/using-airtable-as-a-database/338664/7 "2024-09-09T20:12:43Z")
@Baloshi69 we’re still a little lost here. Any guidance would be super valuable ---
**Author:** ![ihsanzainal84](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/ihsanzainal84/32/245932_2.png) [@ihsanzainal84](https://forum.bubble.io/u/ihsanzainal84)\ **Post date:** [September 10, 2024, 1:41am UTC](https://forum.bubble.io/t/using-airtable-as-a-database/338664/8 "2024-09-10T01:41:47Z")
Can’t you do the rollups in Airtable and then bring the grouped data to Bubble? ---
**Author:** ![Baloshi69](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/baloshi69/32/136122_2.png) [@Baloshi69](https://forum.bubble.io/u/Baloshi69)\ **Post date:** [September 10, 2024, 7:10am UTC](https://forum.bubble.io/t/using-airtable-as-a-database/338664/9 "2024-09-10T07:10:17Z")
when you be online ping me on linkedin or whatsapp , see my profile will love to help.