0

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

8 replies

null
    • Mr_K
    • 2 yrs 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.

    • Mr_K
    • 2 yrs 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...

    • Mel_Charles
    • 2 yrs ago
    • Reported - view

    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

    • Mr_K
    • 2 yrs 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.

    • John_Halls
    • 2 yrs 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

    • Inspector_99
    • 2 yrs ago
    • Reported - view

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

    • Mr_K
    • 2 yrs 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.

    • Mel_Charles
    • 2 yrs ago
    • Reported - view

    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

Content aside

  • 2 yrs agoLast active
  • 8Replies
  • 274Views