Sep 24, 2023 02:17 PM - edited Sep 24, 2023 02:25 PM
Greetings!
I'm currently exploring how to sort data in columns while using Airtable's grid interface. I can successfully sort data on the backend, but I'm seeking a way to enable users and viewers to sort this data directly within Airtable's grid interface. Your guidance on this matter would be greatly appreciated.
Thank you!
Sep 25, 2023 09:28 AM
Hi @fcosorio,
You should be able to solve your problem by going to the right in the interface settings. In the display options, before the buttons used to make changes to the grid, there should be "sort" and "group" fields. You can select "sort" and look for the "Date" field -> it should also give you the option to sort them from the earliest to the latest date or vice versa.
I hope this helps!
Website: alessiomonino.com
Calendly: https://alessiomonino.com/contact
Email: alessio.monino@gmail.com
Sep 25, 2023 10:37 AM - edited Sep 25, 2023 10:38 AM
@Alessio_Monino - Thank you!
I believe this approach won't work because it doesn't allow the person viewing the grid table (not just me) to sort each column based on their preferences. The "sort" and "group" features appear to establish a fixed sorting order, but they don't provide the user of the grid and dashboard with the flexibility to sort each column in the grid as they see fit. Does that sound accurate to you?
Did I overlook anything in your explanation?
Sep 25, 2023 12:46 PM - edited Sep 25, 2023 12:47 PM
Hi @fcosorio,
The sorting and grouping functionality should be available also for external users who you shared the video with, for example this is the link to a view that I just created - you should be able to sort/group the different columns: https://airtable.com/appT8EQ25NDjzRHvy/shrJ5p9AXfNo1e9tx/tblGUvsgHw6lxb4Q7
Website: https://alessiomonino.com
Calendly: https://alessiomonino.com/contact
Email: alessio.monino@gmail.com