Thanks for the feedback! As Emmett and Kat have mentioned, it’s on our roadmap, and we certainly appreciate the value of this feature.
There’s some technical differences in how difficult it is to perform live sorts vs live filters (for instance, because sorting is a more heavyweight operation than filtering, which can be calculated for each row independently, whereas sorts are by definition relative to all other rows in the table). This is exacerbated in situations where, for instance, multiple people may be modifying large numbers of rows at once (by copying and pasting values into a cell range that affects a sort, or just rapidly modifying many rows in quick succession in a very large table, etc).
Beyond the technicalities, there are also usability/interface questions involved. We’ve encountered many use cases where someone does want to apply a one-time sort and then manually order or insert rows in an arbitrary position. Some other examples of issues to consider:
- If you’re editing a record and you change its values in such a way that its sorted position would change in the view, we need a way to indicate to the user that the row’s sort position has changed, both while editing as well as afterwards.
- If collaborators are changing record values, there is a chance that this will cause rows to fly around to their new positions, resulting in a potentially jarring experience.
- It could be confusing to prevent users from manually reordering rows while the “live sort” mode is turned on, and it seems somewhat heavyweight (and potentially difficult to discover for novice users) to have to toggle that mode off before being able to drag rows around. Alternatively, if we allow you to drag rows immediately, but implicitly disable “live sorting” as a result, this could also be an issue (as users inadvertently cause live sorting to become disabled).
Again, it’s a valid feature request, but as with every feature, we want to thoroughly consider its design before implementation to ensure that our product remains intuitive and friendly for all.