# Reverse all Data in Airtable **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [September 18, 2022, 12:20pm UTC](https://community.thunkable.com/t/reverse-all-data-in-airtable/2047194 "2022-09-18T12:20:24Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![sai1910](https://avatars.discourse-cdn.com/v4/letter/s/a3d4f5/32.png) [@sai1910](https://community.thunkable.com/u/sai1910)\ **Post date:** [September 18, 2022, 12:20pm UTC](https://community.thunkable.com/t/reverse-all-data-in-airtable/2047194/1 "2022-09-18T12:20:24Z")
Hi, I have an Airtable Database with some data that is uploaded and shown within the app (in a Data Viewer List) . Whenever a new entry is added, it shows at the bottom of the Data Viewer list. I need it to show at the top. Is there any way to reverse all data in airtable? Alternatively, since all the entries are uploaded with Date, is it possible to sort it chronologically, with newest first? ---
**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:** [September 18, 2022, 2:33pm UTC](https://community.thunkable.com/t/reverse-all-data-in-airtable/2047194/2 "2022-09-18T14:33:22Z")
You have two options: - Use Airtable view with your type of sorting or sort the initial `Grid View`. - Import the table to a local table and sort it while importing the data. ---
**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:** [September 18, 2022, 6:55pm UTC](https://community.thunkable.com/t/reverse-all-data-in-airtable/2047194/3 "2022-09-18T18:55:59Z")
The third option is to filterByFormula using the Airtable API. It’s more advanced to do this so you might try @muneer’s suggestions first. ---
**Author:** ![sai1910](https://avatars.discourse-cdn.com/v4/letter/s/a3d4f5/32.png) [@sai1910](https://community.thunkable.com/u/sai1910)\ **Post date:** [September 19, 2022, 5:18am UTC](https://community.thunkable.com/t/reverse-all-data-in-airtable/2047194/4 "2022-09-19T05:18:06Z")
> [@muneer](#): > > - Import the table to a local table and sort it while importing the data. Hi, which block do I use to do this? ---
**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:** [September 20, 2022, 9:37am UTC](https://community.thunkable.com/t/reverse-all-data-in-airtable/2047194/5 "2022-09-20T09:37:34Z")
> [@sai1910](#): > > block do I use No specific blocks. You need to get all rows from Airtable then go through the rows to check with row has earliest date to save it in an empty local table. You need to create the blocks. Check the `Grid View` ordering in Airtable which is easier and faster. ---
**Author:** ![sai1910](https://avatars.discourse-cdn.com/v4/letter/s/a3d4f5/32.png) [@sai1910](https://community.thunkable.com/u/sai1910)\ **Post date:** [September 21, 2022, 2:23pm UTC](https://community.thunkable.com/t/reverse-all-data-in-airtable/2047194/6 "2022-09-21T14:23:19Z")
Within the Airtable Grid View, the only way to sort is Alphabetically. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/b/9bce6b7affe0c0444a06e427e37ecba6a4a1dce1.png) > [@muneer](#): > > You need to get all rows from Airtable then go through the rows to check with row has earliest date to save it in an empty local table. Would this method be feasible for a table with many (30+) rows? ---
**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:** [September 21, 2022, 3:18pm UTC](https://community.thunkable.com/t/reverse-all-data-in-airtable/2047194/7 "2022-09-21T15:18:15Z")
I would suggest checking out Airtable’s filterByFormula. You can Google it but here is a good starting point: > [@Filter data spreadsheet/ local table](https://community.thunkable.com/t/filter-data-spreadsheet-local-table/1883156): > > Hello team I hope you are good! I´m working in a services app with a spreadsheet and local table. I would like to make a filter for the information because the list in spreadsheet is to large. I saw many videos like a make a two spreadsheets to reload the information in viewer list. So I have a filters into the spreadsheets but i think for the tarjet app don´t works for many users because if they will search in the same time, the information in the second spreadsheet (reload) send a diferent… It’s a bit of work to set up but it gives you full control over sorting and filtering the data. ---
**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:** [September 21, 2022, 4:42pm UTC](https://community.thunkable.com/t/reverse-all-data-in-airtable/2047194/8 "2022-09-21T16:42:38Z")
> [@sai1910](#): > > the only way to sort is Alphabetically. This is correct. It will sort them **Ascending** or **Descending** and this is how Airtable shows it. > [@sai1910](#): > > a table with many (30+) rows? Yes, even 30 or 300 rows. ---
**Author:** ![sai1910](https://avatars.discourse-cdn.com/v4/letter/s/a3d4f5/32.png) [@sai1910](https://community.thunkable.com/u/sai1910)\ **Post date:** [September 23, 2022, 4:40am UTC](https://community.thunkable.com/t/reverse-all-data-in-airtable/2047194/9 "2022-09-23T04:40:05Z")
> [@muneer](#): > > go through the rows to check with row has earliest date Hi, I’m not quite understanding what to use to achieve this. Like how to compare dates, since i’m using the Mth, Day, Year Format. Isn’t there any easier way to just Flip all the data in the table? ---
**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:** [September 23, 2022, 8:21am UTC](https://community.thunkable.com/t/reverse-all-data-in-airtable/2047194/10 "2022-09-23T08:21:57Z")
If your `date` column is not of **type date** then it will not work. This will not work because the `Entry Date` column is of type **single line text** ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/2/128c7cd37f4a060dcb30c6aa3534722c1ecf49a1.png) ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [September 23, 2022, 12:24pm UTC](https://community.thunkable.com/t/reverse-all-data-in-airtable/2047194/11 "2022-09-23T12:24:24Z")
I can understand why you would store data in this method especially considering we don’t have date transformation blocks. However, to do what you’re trying to do you’re going to need to store a date object. You need to set one of the fields on your table to be of type date. Then, when you use the airtable API you’ll be able to request your data sorted in a descending fashion or ascending fashion based on the date field. ---
**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:** [September 23, 2022, 1:34pm UTC](https://community.thunkable.com/t/reverse-all-data-in-airtable/2047194/12 "2022-09-23T13:34:11Z")
Once you create a data of type **date** then you can sort it in the view like this and the DVL will use the `Grid View` to show it with whatever sort you make it. ![Date sort](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/6/36af4a727e9ac4c45b208d48c1671cd4381e96ca.gif) ---
**Author:** ![sai1910](https://avatars.discourse-cdn.com/v4/letter/s/a3d4f5/32.png) [@sai1910](https://community.thunkable.com/u/sai1910)\ **Post date:** [September 24, 2022, 2:39pm UTC](https://community.thunkable.com/t/reverse-all-data-in-airtable/2047194/13 "2022-09-24T14:39:29Z")
Hi, thanks for the options. I figured it out using this video, by using two separate spreadsheets: [![](https://img.youtube.com/vi/BE7cqsvCYH4/maxresdefault.jpg "4. Show Recent Items (spreadsheet bottom) First in Thunkable") ](https://www.youtube.com/watch?v=BE7cqsvCYH4) ---
**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:** [December 23, 2022, 2:39pm UTC](https://community.thunkable.com/t/reverse-all-data-in-airtable/2047194/14 "2022-12-23T14:39:55Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.