September 18, 2022, 12:20pm
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?
September 18, 2022, 6:55pm
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.
September 19, 2022, 5:18am
Import the table to a local table and sort it while importing the data.
Hi, which block do I use to do this?
September 20, 2022, 9:37am
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.
Grid View ordering in Airtable which is easier and faster.
September 21, 2022, 2:23pm
Within the Airtable Grid View, the only way to sort is Alphabetically.
Would this method be feasible for a table with many (30+) rows?
September 21, 2022, 3:18pm
I would suggest checking out Airtable’s filterByFormula. You can Google it but here is a good starting point:
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.
September 21, 2022, 4:42pm
This is correct. It will sort them
Ascending or Descending and this is how Airtable shows it.
Yes, even 30 or 300 rows.
September 23, 2022, 4:40am
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?
September 23, 2022, 8:21am
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
September 23, 2022, 12:24pm
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.
September 23, 2022, 1:34pm
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.
September 24, 2022, 2:39pm
Hi, thanks for the options. I figured it out using this video, by using two separate spreadsheets:
December 23, 2022, 2:39pm
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.