Sort Table by Editable "Order" Column


I have a table that's auto-populated with data and an editable "Order" column. Is there a way to, for example, sort the table so when I change the Order # for the first row to the number 8, rows 1 and 8 will auto-switch places on the table?

Unfortunately it seems like the only ways to trigger the table to re-sort is to either physically click the header twice (to flip and un-flip the sort), or to change the table data.

I came up with a bit of a hack using event handlers (attached export below) that might do what you are looking for, but presumes that there is some other unique column, and also results in the recordUpdates being lost. Perhaps you will be bale to expand from this example though to fit your needs.
Table_Re-sort.json (5.5 KB)