# Creating an Order Timeline everytime a Status Changes in Glide

**URL:** https://community.glideapps.com/t/creating-an-order-timeline-everytime-a-status-changes-in-glide/38755
**Category:** Ask for Help
**Created:** [February 20, 2022, 9:04pm UTC](https://community.glideapps.com/t/creating-an-order-timeline-everytime-a-status-changes-in-glide/38755 "2022-02-20T21:04:39Z")
**Posts on this page:** 10
**Page:** 1

<div class="post-metadata">

### Author: ![josepm](https://avatars.discourse-cdn.com/v4/letter/j/8c91f0/32.png) [@josepm](https://community.glideapps.com/u/josepm)
#### Post date: [February 20, 2022, 9:04pm UTC](https://community.glideapps.com/t/creating-an-order-timeline-everytime-a-status-changes-in-glide/38755/1 "2022-02-20T21:04:39Z")

</div>

Hello everyone!

I’m trying to build an order timeline for a Glideapp.

I would like that, every time the order status changes (the user can change the status via a choice component), this change is saved in a column with a timestamp, and, each change appears in an order timeline similar to this image:

 ![screenshot-1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/3/d366af02b8622f3ac257cebe1c7d0fa7a4a883b4.png)

Does anyone know how to create something similar?

Thanks in advance!

---

<div class="post-metadata">

### Author: ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [February 20, 2022, 9:45pm UTC](https://community.glideapps.com/t/creating-an-order-timeline-everytime-a-status-changes-in-glide/38755/2 "2022-02-20T21:45:28Z")

</div>

To show a list like this, i think it would be easiest to add a row for each status update using an on submit action that is tied to the edit button.

You could just edit the entry over and over and create a new timestamp each time, but you would be overwriting the values each time, so you’d lose the “history”.

If you had a defined number of possibilities, you could create enough columns to store each possible status and timestamp on the same row and display it that way too. In this case, you’d just need to edit the original row each time and create placeholders for each possibility in your app.

---

<div class="post-metadata">

### Author: ![josepm](https://avatars.discourse-cdn.com/v4/letter/j/8c91f0/32.png) [@josepm](https://community.glideapps.com/u/josepm)
#### Post date: [February 20, 2022, 9:58pm UTC](https://community.glideapps.com/t/creating-an-order-timeline-everytime-a-status-changes-in-glide/38755/3 "2022-02-20T21:58:50Z")

</div>

I thought about creating 10 columns as I think it’s the maximum number of updates an order will have, and using them, but the problem is that I’ll also need an additional column for the timestamps, so it’ll be 20 columns.

Do you think the Glide app / Google Sheet performance will decrease with that many columns?

---

<div class="post-metadata">

### Author: ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [February 20, 2022, 10:06pm UTC](https://community.glideapps.com/t/creating-an-order-timeline-everytime-a-status-changes-in-glide/38755/4 "2022-02-20T22:06:57Z")

</div>

No that number of additional columns should not be an issue. I have an app with over 200 columns in a Glide Table and it’s fine!

---

<div class="post-metadata">

### Author: ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)
#### Post date: [February 21, 2022, 12:58am UTC](https://community.glideapps.com/t/creating-an-order-timeline-everytime-a-status-changes-in-glide/38755/5 "2022-02-21T00:58:14Z")

</div>

This not exactly the same design and layout but it may help you achieve what you want.

Take a look at this.

> **[Chart.js Sandbox Editor](https://quickchart.io/sandbox#%7B%0A%20%20type:%20'horizontalBar',%0A%20%20data:%20%7B%0A%20%20%20%20labels:%20%5B'Part%201',%20'Part%202',%20'Part%203',%20'Part%204',%20'Part%205',%20'Part%206'%5D,%0A%20%20%20%20datasets:%20%5B%7B%0A%20%20%20%20%20%20data:%20%5B%0A%20%20%20%20%20%20%20%20%5Bnew%20Date('2021-02-01'),%20new%20Date('2021-05-01')%5D,%0A%20%20%20%20%20%20%20%20%5Bnew%20Date('2021-05-10'),%20new%20Date('2021-07-01')%5D,%0A%20%20%20%20%20%20%20%20%5Bnew%20Date('2021-04-20'),%20new%20Date('2021-11-31')%5D,%0A%20%20%20%20%20%20%20%20%5Bnew%20Date('2021-08-01'),%20new%20Date('2021-09-01')%5D,%0A%20%20%20%20%20%20%20%20%5Bnew%20Date('2021-02-10'),%20new%20Date('2021-07-01')%5D,%0A%20%20%20%20%20%20%20%20%5Bnew%20Date('2021-07-20'),%20new%20Date('2021-11-31')%5D,%0A%20%20%20%20%20%20%5D,%0A%20%20%20%20%20%20backgroundColor:%20%5B'rgb(255,%2099,%20132,%201.0)',%20'rgba(255,%2099,%20132,%201.0)',%20'rgba(255,%20206,%2086,%201.0)',%20'rgba(255,%20206,%2086,%201.0)',%20'rgba(255,%20206,%2086,%200.2)',%20undefined%5D,%0A%20%20%20%20%7D,%20%5D,%0A%20%20%7D,%0A%20%20options:%20%7B%0A%20%20%20%20legend:%20%7B%0A%20%20%20%20%20%20display:%20false%0A%20%20%20%20%7D,%0A%20%20%20%20annotation:%20%7B%0A%20%20%20%20%20%20annotations:%20%5B%7B%0A%20%20%20%20%20%20%20%20type:%20'line',%0A%20%20%20%20%20%20%20%20mode:%20'vertical',%0A%20%20%20%20%20%20%20%20scaleID:%20'x-axis-0',%0A%20%20%20%20%20%20%20%20value:%20new%20Date('2021-10-30'),%0A%20%20%20%20%20%20%20%20borderColor:%20'red',%0A%20%20%20%20%20%20%20%20borderWidth:%201,%0A%20%20%20%20%20%20%20%20label:%20%7B%0A%20%20%20%20%20%20%20%20%20%20enabled:%20true,%0A%20%20%20%20%20%20%20%20%20%20content:%20'Deadline',%0A%20%20%20%20%20%20%20%20%20%20position:%20'top'%0A%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%7D%5D%0A%20%20%20%20%7D,%0A%20%20%20%20scales:%20%7B%0A%20%20%20%20%20%20xAxes:%20%5B%7B%0A%20%20%20%20%20%20%20%20position:%20'top',%0A%20%20%20%20%20%20%20%20type:%20'time',%0A%20%20%20%20%20%20%20%20time:%20%7B%0A%20%20%20%20%20%20%20%20%20%20unit:%20'month'%0A%20%20%20%20%20%20%20%20%7D,%0A%20%20%20%20%20%20%20%20ticks:%20%7B%0A%20%20%20%20%20%20%20%20%20%20min:%20new%20Date('2021-01-01'),%0A%20%20%20%20%20%20%20%20%20%20max:%20new%20Date('2022-01-01'),%0A%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%7D%5D,%0A%20%20%20%20%7D,%0A%20%20%7D,%0A%7D)**
>
> Online no-code chart maker. Build interactive charts with your data and create templates for custom use. Free & no login required.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 21, 2022, 1:31am UTC](https://community.glideapps.com/t/creating-an-order-timeline-everytime-a-status-changes-in-glide/38755/6 "2022-02-21T01:31:47Z")

</div>

I did have a timeline set up like this with XC & webview, but the downside is you can’t access each single row (if you ever need it).

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/d/fd168a929d0d67d6acf37a3f3849b3a6cde591e6.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/3/83570ae98dd3226b553bf0c55e4cd3eeaa3311f1.jpeg)

---

<div class="post-metadata">

### Author: ![josepm](https://avatars.discourse-cdn.com/v4/letter/j/8c91f0/32.png) [@josepm](https://community.glideapps.com/u/josepm)
#### Post date: [February 28, 2022, 2:47pm UTC](https://community.glideapps.com/t/creating-an-order-timeline-everytime-a-status-changes-in-glide/38755/7 "2022-02-28T14:47:43Z")

</div>

Hi @ThinhDinh , the timeline is dynamic?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 28, 2022, 11:42pm UTC](https://community.glideapps.com/t/creating-an-order-timeline-everytime-a-status-changes-in-glide/38755/8 "2022-02-28T23:42:31Z")

</div>

Yes, it is dynamic. Each of those are rows in a Logs sheet.

As I said, it’s purely for viewing purposes, you can’t click on each of those and access the related row, so it’s a bit limited.

---

<div class="post-metadata">

### Author: ![Jonathan\_Pierce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonathan_pierce/32/40498_2.png) [@Jonathan\_Pierce](https://community.glideapps.com/u/Jonathan_Pierce)
#### Post date: [March 21, 2023, 7:02pm UTC](https://community.glideapps.com/t/creating-an-order-timeline-everytime-a-status-changes-in-glide/38755/9 "2023-03-21T19:02:59Z")

</div>

Sorry what is XC?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 21, 2023, 11:46pm UTC](https://community.glideapps.com/t/creating-an-order-timeline-everytime-a-status-changes-in-glide/38755/10 "2023-03-21T23:46:14Z")

</div>

It’s what we abbreviate “Experimental Code” as.