When configuring a field to sort a grid view by, I’d really like to be able to configure where an empty field falls in the sort order. Right now, an empty field gets placed at the start, with no option to change this.
For example, I have a table of items with order numbers and am sorting by that order number. Right now, every time I fill in a number an item gets moved to the end of the list. I’d prefer that it didn’t.
For example, this is the current behavior if I’m sorting by the “Order Number” field:
| Item Name | Order Number |
|---|---|
| Red Item | |
| Blue Item | |
| Green Item | 101 |
| Purple Item | 102 |
I want to be able to change the sort configuration so I get this instead:
| Item Name | Order Number |
|---|---|
| Green Item | 101 |
| Purple Item | 102 |
| Red Item | |
| Blue Item |
Obviously there are other ways to do this, such as sorting by an additional field, but that would mean creating a field for the sold purpose of “kludging baserow behavior” and not anything relevant to me.
