Is there a formula available that add’s a number (look right), based on the order of entities in a list view? So that when the order of the entities changed, the one on top should always be updated to number 1, the second one to number 2 etc.
If they are not explicitly sorted, then the ordering is considered to be ‘manual’ (which uses a ranking number in the background) and @bear is right that it’s not possible to extract the order as a number.
Well, we havelead statusses in a seperate database. Those lead statusses represent a sort of logical order in a salesfunnel.
Since they’re linked to a contact, and since we have the sorting order in the relational database it would be great is we could sort those statusses in the same logical order.
Offcourse I can manually add a number to create an order (and I will, cause there’s no other option). But because we (@YvetteLans and I) are building workspaces for our cliënts it would have been awesome if our cliënts can re-arrange the order (or add new statusses), without manually having to change the order.
There is a relationship between Lead Status and Contact. In Contact you see the entities in alphabetical order, but fortunately we can now sort! I want to show them in the order of the sales funnel as specified by our customer.
I can add a fixed number on which we can sort. But when our client adds a status or wants to change the order, they have to manually change the numbers. When there’s no other solution is available then that is the way it has to be. But if we can automate this based on a sequence in a specific place (not in the database), that would be great.
Hope you understand what I’m trying to accomplish.
In general, if you remove the alphabetic sorting on the relation field, you should see the entities sorted by ‘rank’ (which is the order that they get from any manual drag’n’dropping in a list view for those entities).
However, it seems there may be a bug which is applying a creation date sort instead.