Page Designer - Ability to Sort Related Records in Tables


#1

Hi,

I am wondering if there is a way to sort related records within a table that I am bringing to Page Designer Block. For example, I would like to bring in the schedule (run of show) for an event. Each activity + time is a record in a related table. When I bring in the table to my Page Designer Block, the activity times are not in the right order. Is there a workaround so that I can display the records in the correct time order?


#2

The order is the manual order in which you added the records. You can reorder them with drag and drop.


#3

Elias, could you explain this a little more? As far as I can tell, the records actually appear in the reverse order they were added to the base, and there is no way to rearrange them, even with drag and drop. Where are you doing this drag and drop to rearrange them? And is there no way to set a sort order?

Edit: see the screen shot below. I know for a fact the records were added in the reverse order they are being displayed.

(I submitted a feature request for this last fall. This is still one of the biggest reasons I don’t move more to Airtable, and if you have a way around it, I want to know!)


#4

Paul -

I must admit it doesn’t work the way I thought it did, either. based on the Block description, I thought one drag-and-dropped related records directly in the Page Designer edit window to change their order. Instead, from the Page Designer window, one selects ‘Expand record’ to open the traditional expanded record screen and reorders the sequence of linked records there. (Presumably this means the sequence has to be set manually for each record in the base; unfortunately, the table in my ‘scratch’ base I used to check this has only a single record with a many-to-one link.)

And, yes, you are right: Airtable treats related records as a LIFO (last in, first out) stack, so items are returned in reverse order from how they were added. This means, with sufficient omniscience, one can simply add related records bassackwardly have them presented in proper order. :wink:


#5

Well, reversed. I forgot to mention that.

About the drag & drop:


#6

Thanks to you both, that’s useful. Doing it manually isn’t great when one will be needing to do it all the time. Filemaker has the “sort portal records by” function - that’s what I would like here. Until then, it’s good to know there is a method that I can use.


#7

Thanks for taking the time to show this!


#8

As a new user, this is something I would VERY MUCH like to see. It would be extraordinarily helpful if we could have some basic functions (grouping, sorting, filtering) in the page designer table. This is the exclusive reason that I have paid for pro