Sort day field alphabetically, I want Monday, Tuesday, Wednesday...
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.
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...
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
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.
Hi Mr K
I encountered the same problem. I ended up prefixing my days with a number: 1-Monday, 2-Tuesday, etc
To be fair - I have done similar but prefixed them with A-Sunday, B-Monday and so on
I did the "1-Monday, 2-Tuesday, etc" too. I think Ninox needs to add more sort options. Weekday and Month come to mind.
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
- 1 yr agoLast active