[SOLVED] Sorting of list based on meaning of entry?

I know the above is probably a very confusing headline, but I need a function that can sort a list, based on a field's content, but not alphabetically.
We have a board, and there are specific functions in the board, eg. chairman, xo, boardmember etc.
I would like to show a list and always have a specific order, the chairman on top, followed by the xo, followed by boardmembers.
Currently I have a multiselect field that contains: 1. chairman, 2. xo, 3. boardmembers
That way I can sort it alphabetically, but I'm getting questions about the numbers.

Is there another way I can do the sorting. I thought about creating a field where the sorting number is present, but it has to be automatic calculation, as the member administration can't change two values for the same change (too complicated).
Then I could just sort after that field, and not show it, but how do I construct that field?

CB has no such feature. I suppose the best way to do this is a CB Auto Action to update a hidden field with a value baed off the value(s) of your multi-select then use that hidden field for sorting. For example if the multi-select contains "Chairman" then update the hidden field as "1", etc.. You'd want to use a Field action on the after registration (front and backend) and after profile update (front and backend) to cover all scenarios.

Ahh, I see, so do I need to create an autoaction for each value of the multi-select field, or can I combine them into 1 somehow?

You'll need to create an action for each sorting value. Then use conditionals to condition against your field. For example if the only value that adds sorting of "1" is "Chairman" then condition that the field contains "Chairman" (use Contains operators on multi-selects).

As the field is not a multi-select, but just a select, I opted for using equal to, but I can't make it work.
The field values for cb_bestyrelse are:



The Autoaction I've created is:



I've created 8 different depending on the value of course.

But I can't make the value appear in the Bestyrelsesort field (the sort field is NOT read-only, but it is on a published non-shown tab).

Your value on the left is not a substitution. That's just a string so it's literally matching string to string. You need to make it a valid substitution by surrounding it with brackets (e.g. [cb_fieldname]).