Allow reordering of rows in "detail view" table

In detail view, I’d like to be able to reorder the rows for a lookup column being displayed as a table.

If the corresponding column is set to sort on “table order” I’d assume that it would reorder the rows in the source table (in the same way that rows would be reordered in a filtered view). It’s worth noting that even when the column sort is set to “custom sort” I’m not able to re-order the rows.

Shared with CloudApp

Hi @MrChrisRodriguez :slight_smile:
So basically that table is a cell that contain a formula like “table1” and it is showed as a table in a detail view
I have many setup like that and if i need a specific order i just use “table1.sort(desired sorting)” and it work, can you share a dummy doc? So i can look at it :slight_smile:

Hey Mario – thanks for the reply. I understand that, but it’s effectively a derived filtered view of an existing table. I wouldn’t be surprised if that’s how it was represented under the hood (i.e. a lookup column displayed in detail view is just a table view filtered with a formula).

In the same way that I can have a filtered view table at the top level and reorder the items (instead of applying a sort), I’d like to be able to manually define a sort in the table view created created for a lookup column in table view.

Maybe i have an idea of why this strange behaviour happens
I think that the original table, when “recalled” with a formula is loaded as “complete table”, let me give you an example
If i have my original table (let’s call it table1) in page1 and in that page i filter it to show just some part of the table(some rows), when i create a view of that table in page2 what i get is a table identical to the original table unfiltered, so for example filter doesn’t apply in views, maybe the same behaviour take place with Sort()

To be honest i’m super curious to dig into this but i need a “dummy copy” of your doc, one that does not contain sensitive data that i can experiment with :slight_smile:

Could you share one? :slight_smile:

P.s. i’m not 100% sure i’ve got your situation right, maybe you was looking for a way to manually reorder the original table (table1) and find the same order in every lookup/view, in this case i would not use a “manual sorting” like moving row up and down but i would prefer to create another column with values like “1”,“2”,“3” ecc and sort that table based on this new column, but a sample doc will resolve all the dubts :slight_smile:

Hi @MrChrisRodriguez,

You right that this is not available currently. Part of the reason is that this is essentially a formula column displayed as a table, so it’s not 100% a view in how it works. It’s also a little caught in the middle of some layout work being done to make forms possible, so some options look to be showing that aren’t actually usable at the moment, like sort and filter.

This is a great suggestion though!

1 Like