0
How to create a sort order
I want to dispaly a table in order, Monday, Tuesday, Wednesday etc
I know I could sort this by renaming them 01-Monday, 02-Tuesday etc
Is there a way I can define my sort order and have them sorted accorgingly?
Mant thanks.
1 reply
-
You can try with a 'switch' function (your field is text?).
Create a formula with this code:
---
switch 'Your Field' do
case "Monday":
text(1)
case "Tuesday":
text(2)
case "Wednesday":
text(3)
case "Thursday":
text(4)
case "Friday":
text(5)
case "Saturday":
text(6)
case "Sunday":
text(7)
default:
text("")
end---
The result is text but you can sort by this formula (since the result will always be under 10)
Content aside
- 4 yrs agoLast active
- 1Replies
- 770Views