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:
- Kanban component saves to KANBAN ORDER column
- JOINED LIST of the Kanban order
- SPLIT TEXT of the Joined List
- SORTED ARRAY of the Split Text List (experimental)
- FIND ELEMENT INDEX to find KANBAN ORDER in SORTED ARRAY (experimental) (outputs: 0,1,2,3,4)
- 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!