Sorting a list using the Kanban component

General
1

Sharing here in case it is helpful to anyone - I couldn’t find anything to help me with this exact problem, so here’s how I solved it.

In my app I use a Kanban component as a sorting “tool”. I have a limited number of items (5) and as you can see in the video, when I move them in the Kanban I want to sort them in the list.

That part’s not so hard, but I wanted to keep the ABCDE in order in the list, so that if I move the D BLOCK up to the B position, it becomes the B BLOCK, etc.

Maybe there was an easier way, but I couldn’t find one!

So… table goes like this:

  1. Kanban component saves to KANBAN ORDER column
  2. JOINED LIST of the Kanban order
  3. SPLIT TEXT of the Joined List
  4. SORTED ARRAY of the Split Text List (experimental)
  5. FIND ELEMENT INDEX to find KANBAN ORDER in SORTED ARRAY (experimental) (outputs: 0,1,2,3,4)
  6. IF/THEN IMAGES Column I use to match the ABCDE images with the index order so 0=A, 1=B, etc

Then in the Layout Editor, I just sort the list by the INDEX ORDER!

Screenshot 2024-11-26 at 3.19.46 PM
Screenshot 2024-11-26 at 3.19.46 PM1399×249 79.2 KB

2 Likes
2

You can actually just sort the List collection by the KANBAN order column in Alphabetical order and avoid all the computed columns.

I’m looking for a way to do this when the KanBan Order column values might also be empty for new rows.

3

Yes, that part is straightforward, but my use case is that when I move the items, I needed to change the assignments of the ABCDE images to the new item taking its place. So assigning an image to a different row anytime the order changes.

This is more complicated. If Kanban used numbers or a fixed group of alphanumeric strings to sort, then this would be easy - but there is no way to if/then with random strings.

The only way I was able to change the sorting to something I could create rules for was this Rube Goldberg set of computed columns that takes the Kanban alphanumeric strings and converts them into fixed numbers 0-4.

4

As for your dilemma- maybe in the creation of the new row it could set a column value for Kanban order like AAAA or ZZZZ that would place it at the top or bottom?