Hi there, 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. [image] Thanks. Marloes

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 inst…

Hi Marloes! I have tried, but it doesn’t seem to be possible :thinking: What is the purpose of numbering them by order in the view? Perhaps there is another approach to get a similar result.

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.

Thanks for your reply! 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 i…

I’m not sure I understand what’s happening. Is the list view you showed supposed to represent the various lead statuses, manually sorted via drag and drop to be a meaningful order? How does adding a number help? What is the number to be used for?

Hi @ChrisG Below is an image of the lead statuses in the database in logical order. They are in this order because I put them in manually. [image] 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 wa…

Yes, no bug! I changed the order by dragging and it works as you said. I was not aware that this would be automatic. So I wanted to build a solution that doesn’t require a fix. :smiley: Thanks!

Yep, @Sergey_Truhtanov rolled out a fix yesterday :slight_smile:

Formula for number in list view

Get Help

Matt_Blais April 16, 2023, 5:42pm 5

Topic		Replies	Views
Can we translate the ranking number to a normal number? Get Help	3	242	July 14, 2023
Calculating a unique row int (not unique ID) Get Help	5	512	August 29, 2023
How to access entities' "natural sort order" in Rules/Buttons/scripts? Get Help	11	624	February 8, 2022
Allow sorting by Rank in Table views Ideas & Features table-view	3	401	June 9, 2023
Configuring entity Get Help	2	589	January 2, 2019

Formula for number in list view

Related topics