# How to split up large amounts of data that are being concentrated into a label **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** help\ **Created:** [February 7, 2024, 3:03am UTC](https://community.thunkable.com/t/how-to-split-up-large-amounts-of-data-that-are-being-concentrated-into-a-label/2823627 "2024-02-07T03:03:49Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![nascentaa0obfo](https://avatars.discourse-cdn.com/v4/letter/n/f08c70/32.png) [@nascentaa0obfo](https://community.thunkable.com/u/nascentaa0obfo)\ **Post date:** [February 7, 2024, 3:03am UTC](https://community.thunkable.com/t/how-to-split-up-large-amounts-of-data-that-are-being-concentrated-into-a-label/2823627/1 "2024-02-07T03:03:49Z")
I am trying to get a large amount of data from my sheet and show it in my app. This is nearly 200 datapoints that are all being concentrated into a label, thus the label “disappears” when all the data points are concentrated at once into it. Is there a way to get that data to come and collect in that label without making it disappear? This is a video of the label disappearing [![](https://i.vimeocdn.com/video/1787292196-7aaec3ed7eb4ec85dffd9c587747a63a05e2af67222e77a4a5ab41379a921bcd-d?f=webp "Thunkable") ](https://vimeo.com/905827928) This is the sheet (The first row is the filter, every row after that is being input into the label) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/5/757dbe51ed1a41f2b4572273151112cd45833f9a.png) ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [February 7, 2024, 7:24am UTC](https://community.thunkable.com/t/how-to-split-up-large-amounts-of-data-that-are-being-concentrated-into-a-label/2823627/2 "2024-02-07T07:24:14Z")
I’m not sure what you mean by “concentrated into a label.” A label usually stores a single value, not multiple values. Do you mean a Simple List? What is the purpose of storing your entire database in a label? Can you say more about what you are trying to do? This doesn’t really provide enough details: > [@nascentaa0obfo](#): > > I am trying to get a large amount of data from my sheet and show it in my app. You can post a link to your project or screenshots of your blocks… that would help connect some of the dots that are missing here… ---
**Author:** ![nascentaa0obfo](https://avatars.discourse-cdn.com/v4/letter/n/f08c70/32.png) [@nascentaa0obfo](https://community.thunkable.com/u/nascentaa0obfo)\ **Post date:** [February 9, 2024, 1:53am UTC](https://community.thunkable.com/t/how-to-split-up-large-amounts-of-data-that-are-being-concentrated-into-a-label/2823627/3 "2024-02-09T01:53:34Z")
I am trying to filter the data from a spreadsheet based on one criteria. That is the number in the first column. (I changed all the numbers to the same one for testing purposes.) For example, I was trying to just take all the data in the rows that show 101 in this photo. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/e/5e5d2d3bc67fb96d0ab44ab996dc847e01bed157.png) That is the reason why multiple datapoints are being input into one label. ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [February 9, 2024, 5:05pm UTC](https://community.thunkable.com/t/how-to-split-up-large-amounts-of-data-that-are-being-concentrated-into-a-label/2823627/4 "2024-02-09T17:05:59Z")
I recommend that you store the data in Airtable and use the Airtable API’s _filterByFormula_ command to filter only the records you need. Here’s an example of that: [The AirTable API (a more efficient way to integrate AirTable with Thunkable) - #22 by jared](https://community.thunkable.com/t/the-airtable-api-a-more-efficient-way-to-integrate-airtable-with-thunkable/1021167/22). You can then display the filtered data in a Data Viewer List or Simple List depending on what you need, or you can clone labels but that’s a bit more complicated. ---
**Author:** ![nascentaa0obfo](https://avatars.discourse-cdn.com/v4/letter/n/f08c70/32.png) [@nascentaa0obfo](https://community.thunkable.com/u/nascentaa0obfo)\ **Post date:** [February 27, 2024, 2:48am UTC](https://community.thunkable.com/t/how-to-split-up-large-amounts-of-data-that-are-being-concentrated-into-a-label/2823627/5 "2024-02-27T02:48:13Z")
Hello @tatiang Quick Question and sorry for the late reply. Does this same code apply even after Airtable removed API keys and used personal authorization tokens? ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [February 27, 2024, 3:01am UTC](https://community.thunkable.com/t/how-to-split-up-large-amounts-of-data-that-are-being-concentrated-into-a-label/2823627/6 "2024-02-27T03:01:40Z")
That’s a good question but I’m sorry, I don’t know the answer to it. I haven’t used Airtable since then. **Edit:** I asked Microsoft Copilot your question and this is what it responded: > Yes, the solution I provided still applies even after Airtable removed API keys and switched to using **personal authorization tokens**. The `filterByFormula` parameter remains the same, and you can continue to use it to filter records based on specific criteria. > > Remember to include your **personal access token** in the request headers for authentication when making API calls. If you haven’t already, obtain your personal access token from Airtable and include it in your API requests. ---
**Author:** ![nascentaa0obfo](https://avatars.discourse-cdn.com/v4/letter/n/f08c70/32.png) [@nascentaa0obfo](https://community.thunkable.com/u/nascentaa0obfo)\ **Post date:** [February 27, 2024, 3:12am UTC](https://community.thunkable.com/t/how-to-split-up-large-amounts-of-data-that-are-being-concentrated-into-a-label/2823627/7 "2024-02-27T03:12:23Z")
> [@tatiang](#): > > Yes, the solution I provided still applies even after Airtable removed API keys and switched to using **personal authorization tokens**. The `filterByFormula` parameter remains the same, and you can continue to use it to filter records based on specific criteria. Thank you very much for that prompt answer. ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [May 27, 2024, 3:12am UTC](https://community.thunkable.com/t/how-to-split-up-large-amounts-of-data-that-are-being-concentrated-into-a-label/2823627/8 "2024-05-27T03:12:54Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.