0

Sort day field alphabetically, I want Monday, Tuesday, Wednesday...

8replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Mr. K.
    • Mr_K
    • 8 mths ago
    • Reported - view

    Oh my, how I wish I could edit a post here. So sad how bad this interface is. I keep asking for an update, and keep getting told it is coming, yet nothing.

    Like
    • Mr. K.
    • Mr_K
    • 8 mths ago
    • Reported - view

    This is my question: How do I sort a Kanban view (or for that matter any view) by my day field? It's sorting alphabetically, I want Monday, Tuesday, Wednesday...

    Like
  • In form design mode - on the choice field you can rearrange the field order ie drag them up or down to whever you want - this changes the order on the Kanban

    Like
    • Mr. K.
    • Mr_K
    • 7 mths ago
    • Reported - view

    My field that shows the Day is a formula based on a Date/Time field. It can only be sorted by name either ascending or descending.

    Like
    • John Halls
    • John_Halls
    • 7 mths ago
    • Reported - view

    Hi Mr K

     

    I encountered the same problem. I ended up prefixing my days with a number: 1-Monday, 2-Tuesday, etc

     

    Regards John

    Like
  • To be fair - I have done similar but prefixed them with A-Sunday, B-Monday and so on

    Like
    • Mr. K.
    • Mr_K
    • 7 mths ago
    • Reported - view

    I did the "1-Monday, 2-Tuesday, etc" too. I think Ninox needs to add more sort options. Weekday and Month come to mind.

    Like
  • It is interesting that from a weekday point of view that Ninox internally indexes Monday as 1 - Tuesday as 2 etc. So one would have though that you could call the day by this index. So maybe there might be a way to manipulate weekday function? in the kanban - not tried  (Yet!) but will have a look at when I get 5 mins

    Like
Like Follow
  • 7 mths agoLast active
  • 8Replies
  • 252Views