# Order log in the same Cell (Order History)

**URL:** https://community.glideapps.com/t/order-log-in-the-same-cell-order-history/56724
**Category:** Ask for Help
**Created:** [January 15, 2023, 9:26am UTC](https://community.glideapps.com/t/order-log-in-the-same-cell-order-history/56724 "2023-01-15T09:26:31Z")
**Posts on this page:** 4
**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: [January 15, 2023, 9:26am UTC](https://community.glideapps.com/t/order-log-in-the-same-cell-order-history/56724/1 "2023-01-15T09:26:31Z")

</div>

Hello!

I’m trying to create an action that saves an order status in the same cell in a Google Sheets.

This is needed in order to show the different order statuses (order history) as a log.

Something like:

01/14/2023 10:07 - Order created  
01/15/2023 10:07 - Order delivered

I know that I can do that creating a new sheet and adding a new row each time there’s a change in status where I include the timestamp, order ID and status, but, I will like to have everything in the same sheet, adding the additional data in a column for the same order ID row.

Does anyone know how to do it?

Thanks in advance!!

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [January 15, 2023, 9:56am UTC](https://community.glideapps.com/t/order-log-in-the-same-cell-order-history/56724/2 "2023-01-15T09:56:57Z")

</div>

It’s possible.

The simplest approach would be to use a joined list, and append a new item to the list each time there is a status change. You could use a CRLF as a list separator, so the end result would be as per your example.

A more complex approach would be to create a JSON structure and append to that. I would probably only suggest this approach if you had several attributes to be saved with each status change, and needed to be able to display it as a list and/or edit individual entries. This approach requires some advanced techniques including the use of JavaScript.

---

<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: [January 15, 2023, 10:49am UTC](https://community.glideapps.com/t/order-log-in-the-same-cell-order-history/56724/3 "2023-01-15T10:49:38Z")

</div>

Thanks Derren!  
Do you have any tutorial or additional information about how to build it using this way:

> “The simplest approach would be to use a joined list, and append a new item to the list each time there is a status change. You could use a CRLF as a list separator, so the end result would be as per your example.”

Thanks!

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [January 15, 2023, 10:53am UTC](https://community.glideapps.com/t/order-log-in-the-same-cell-order-history/56724/4 "2023-01-15T10:53:56Z")

</div>

Have a look at the below tutorial:

> [@dizzy The Trebuchet Method](https://community.glideapps.com/t/the-trebuchet-method/48325):
>
> In certain situations, a single column has the potential to replace an entire table of data. The Trebuchet Method allows you to create an inline array that allows you to create a SIMPLE one-to-many relationship between two sets of data without the need of a log or submissions table. Examples: Who owns which item Who has registered for an event Who has completed which task Pros: no app bloat no additional rows of data fairly easy to set up Cons: Can only track one data point (eg. who has w…

For your use case, you won’t need to be creating relations to the data. But you should pay careful attention to how items are added to and removed from the list.
