# Changing order in a related list of rows

**URL:** <https://community.glideapps.com/t/changing-order-in-a-related-list-of-rows/26202>\
**Category:** Ask for Help\
**Created:** [April 30, 2021, 3:36am UTC](https://community.glideapps.com/t/changing-order-in-a-related-list-of-rows/26202 "2021-04-30T03:36:51Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jaime](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaime/32/72726_2.png) [@Jaime](https://community.glideapps.com/u/Jaime)\
**Post date:** [April 30, 2021, 3:36am UTC](https://community.glideapps.com/t/changing-order-in-a-related-list-of-rows/26202/1 "2021-04-30T03:36:51Z")

</div>

I recently built an app where users created projects, and then created ordered milestones within each of those projects.

The milestones in a project often needed to be reordered, and users needed to slot in additional milestones at various points (ie. adding a milestone between the existing milestones 3 and 4).

I played around with assigning a position number to each milestone and allowing users to increment/decrement that number depending on whether they wanted to push a milestone up the order, but this didn’t really solve the issue because often this would just place a bunch of different milestones on the same position number.

Allowing users to set the position number directly could also work, but when there are dozens of milestones, they would have to reassign a number to every milestone to get the proper order.

Any elegant solution to this that I am missing? There’s probably something really obvious I am overlooking 😃

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [April 30, 2021, 3:42am UTC](https://community.glideapps.com/t/changing-order-in-a-related-list-of-rows/26202/2 "2021-04-30T03:42:34Z")

</div>

I am currently on the subject, I think I can give you a demo in a while.

---

<div class="post-metadata">

**Author:** ![Jaime](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaime/32/72726_2.png) [@Jaime](https://community.glideapps.com/u/Jaime)\
**Post date:** [April 30, 2021, 3:46am UTC](https://community.glideapps.com/t/changing-order-in-a-related-list-of-rows/26202/3 "2021-04-30T03:46:33Z")

</div>

That’d be great!

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [April 30, 2021, 4:03am UTC](https://community.glideapps.com/t/changing-order-in-a-related-list-of-rows/26202/4 "2021-04-30T04:03:14Z")

</div>

Here is a demo.  
If this is what you are looking for ??  
Otherwise, I’m off topic 😉

[Video](https://streamable.com/1icdqz)

---

<div class="post-metadata">

**Author:** ![Jaime](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaime/32/72726_2.png) [@Jaime](https://community.glideapps.com/u/Jaime)\
**Post date:** [April 30, 2021, 4:06am UTC](https://community.glideapps.com/t/changing-order-in-a-related-list-of-rows/26202/5 "2021-04-30T04:06:24Z")

</div>

Yeah! Looks about right

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [April 30, 2021, 4:22am UTC](https://community.glideapps.com/t/changing-order-in-a-related-list-of-rows/26202/6 "2021-04-30T04:22:54Z")

</div>

Okay  
The application is still under development.

Here is a demo application.  
There are 2 examples

- “Simple order” (no modification by the user, only up/down)
- “User order” (addition, modification, delete and up/down)

For “Order User” you can use several different lists, you just have to adjust the “Master” field

For the moment I haven’t done it by user yet. So if 2 users are using at the same time, there is a problem.  
I plan to do so in the next few days.

In the meantime this gives you an idea of ​​my solution (it may not be the best, but for the moment it works :-))

> **[Demo Order Public](https://freezing-rose-1190.glideapp.io/)**

---

<div class="post-metadata">

**Author:** ![Jaime](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaime/32/72726_2.png) [@Jaime](https://community.glideapps.com/u/Jaime)\
**Post date:** [April 30, 2021, 5:00am UTC](https://community.glideapps.com/t/changing-order-in-a-related-list-of-rows/26202/7 "2021-04-30T05:00:51Z")

</div>

Nice. That is a really interesting solution. Thanks for sharing.

I think this would be quite tricky to implement when there are multiple lists of items with their own individual orders.

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [April 30, 2021, 5:06am UTC](https://community.glideapps.com/t/changing-order-in-a-related-list-of-rows/26202/8 "2021-04-30T05:06:34Z")

</div>

I am currently working on the subject.  
Because I have an application with several users who do not necessarily use the same lists, so several lists with different choices per list.

In the small demo, there is a start of the solution with the “Master” field which represents an ID of a list.

It would be easier if we had this option natively in the lists, but that’s another story.

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [April 30, 2021, 5:30am UTC](https://community.glideapps.com/t/changing-order-in-a-related-list-of-rows/26202/9 "2021-04-30T05:30:11Z")

</div>

Without thinking too much, for multi-user use, it is probably necessary to change some fields to “Column is user-specific”

- Order
- Select a date  
and maybe “Safe Value”

---

<div class="post-metadata">

**Author:** ![Jaime](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaime/32/72726_2.png) [@Jaime](https://community.glideapps.com/u/Jaime)\
**Post date:** [April 30, 2021, 5:44am UTC](https://community.glideapps.com/t/changing-order-in-a-related-list-of-rows/26202/10 "2021-04-30T05:44:12Z")

</div>

Yeah, a ‘shift row up/down/to the top/to the bottom’ action would solve this problem I think

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [April 30, 2021, 5:46am UTC](https://community.glideapps.com/t/changing-order-in-a-related-list-of-rows/26202/11 "2021-04-30T05:46:27Z")

</div>

I’m afraid this action will not be available before, before, before the “Saint Glin Glin” 🤣

---

<div class="post-metadata">

**Author:** ![Jaime](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaime/32/72726_2.png) [@Jaime](https://community.glideapps.com/u/Jaime)\
**Post date:** [April 30, 2021, 8:20am UTC](https://community.glideapps.com/t/changing-order-in-a-related-list-of-rows/26202/12 "2021-04-30T08:20:04Z")

</div>

Haha what is saint glin glin

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [April 30, 2021, 8:22am UTC](https://community.glideapps.com/t/changing-order-in-a-related-list-of-rows/26202/13 "2021-04-30T08:22:44Z")

</div>

The “Saint Glin Glin” is the feast day for the “Glin Glin” in short it does not exist !!! 🤣
