Show blank fields last in table sort order

  • 1
  • Question
  • Updated 1 year ago
  • Answered
I'm configuring the "fields to order records by" field to apply a sort order on a date. However, on the field I am sorting, most of the time it is blank. When I view the table, the blank fields are sorted before the fields with a date. I'd like to sort it so the dates are at the top of the table.

I believe I read somewhere in the community that there is a way to sort NULL values to the bottom, but I can't seem to find that post using search.

Anyone know what I should enter into the "fields to order records by" field?

Thanks,
Andrew
Photo of Andrew N

Andrew N

  • 1,178 Points 1k badge 2x thumb

Posted 1 year ago

  • 1
Photo of Matt Hoffman

Matt Hoffman

  • 172 Points 100 badge 2x thumb
You can put NULLS LAST  to make them come in at the bottom.
Photo of Andrew N

Andrew N

  • 1,178 Points 1k badge 2x thumb
That's it! Thanks so much!