I have an item where the user chooses from a list of board IDs and then clicks a button.
The button triggers Make.com to take all of the item’s subitems and recreate them as items in the selected board.
These subitems are being retrieved in order of their item IDs but surely no one is ever going to want to order them by their IDs!
How on earth do I keep/find the order in which these subitems are displayed originally??
It took me 30 minutes to set up the whole automation and get it working. Then I spent the next 2 hours until home time trying to figure out how to fix the ordering.
I’m getting very frustrated trying to find a work around to something that should be working as a basic minimum. Am I missing something obvious? It should be obvious…
Unfortunately monday does not have a concept of “order”. Users can drag and drop columns, items and subitems in any order they like. You could try to use the newest_first field to sort the items or the created_at property which gives you an order of “oldest” to “newest”, but not the order which appears in the UI.
An items/subitems order property must be stored somewhere, at least to list the items in a custom order that’s not a simple “order by column value”.
It would be really useful if such value were available thru API.
They clearly have some way of knowing the order the user has chosen though because otherwise it would forget each time you reload the board. In my use case the order the user chooses is just as important as the items themselves.
It’s impractical to expect users to redo an “order” column every time something changes, which is the work around I’m currently having to use (and to make it worse, Make.com reads my “order” column as text and not numeric when I try to sort, so I’ve had to change it to a text column and use 01, 02, 03 etc).