# Basics (again) - Accumulated list
**URL:** https://community.glideapps.com/t/basics-again-accumulated-list/39152
**Category:** Ask for Help
**Created:** [March 2, 2022, 5:25pm UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152 "2022-03-02T17:25:49Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@Test\_Test](https://community.glideapps.com/u/Test_Test)
#### Post date: [March 2, 2022, 5:25pm UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/1 "2022-03-02T17:25:49Z")
Hi all,
Taking you back to basics again.
We have a custom form that updates client details. For each submitted form, we’d like to have a list of what elements were changed. How would you go about this?
I couldn’t solve this, so I started with an inefficient solution that turned to a bust.
1. For each column that points to a change, I added an ITE column. ITE results in a description of the change if changed column is not empty.
2. A template is used to join all ITE columns
And…bust 😢
How do I clean up this template column?
Because we don’t always update all client details, the template will almost always contain too many white spaces. Sure, The summary can be trimmed, and any double whitespace can be replaced with nothing. This doesn’t provide a coherent summary of changes. It would be great to add commas between ITE values, at the very least.
In the template column, I also thought about replacing the whitespace with a placeholder, such as “XXX”, but I again couldn’t bring it to be clean enough.
Any ideas?
Back to my first sentence, I know it’s a very basic question and I’m sure the answer will be mind-blowingly simple 🙂
Thanks
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [March 2, 2022, 8:34pm UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/2 "2022-03-02T20:34:05Z")
> [@Test\_Test](#):
>
> This doesn’t provide a coherent summary of changes. It would be great to add commas between ITE values, at the very least.
0,1,2,3,4,5…
---
### Author:  [@Test\_Test](https://community.glideapps.com/u/Test_Test)
#### Post date: [March 2, 2022, 9:26pm UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/3 "2022-03-02T21:26:43Z")
Yeah, funny 🙂
Now change 0/1/3/5 to nothing and what are we left with?
The issue here is that we cannot expect which detail will be changed, hence the need for this summary column
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 2, 2022, 11:00pm UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/4 "2022-03-02T23:00:02Z")
I’m having trouble visualizing this.
Can you show what your IF columns look like?
How are you determining a change in value?
Does the form update an existing row, or add a new row?
Can you show an example of what the template result should look like if it worked the way you want it to?
---
### Author:  [@Test\_Test](https://community.glideapps.com/u/Test_Test)
#### Post date: [March 3, 2022, 7:19am UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/5 "2022-03-03T07:19:32Z")
> [@Jeff\_Hager](#):
>
> Can you show what your IF columns look like?
> [@Jeff\_Hager](#):
>
> Does the form update an existing row, or add a new row?
existing.
The form is sitting in a standalone Glide table, all USC. That table is bridged to the main client table. It’s basically overwriting the values in the clients table, after checking if there was indeed a change in each value.
> [@Jeff\_Hager](#):
>
> Can you show an example of what the template result should look like if it worked the way you want it to?
Assuming the users updated the following:
1. First name
2. Phone number
3. Address
The summary should be:
“First name, Phone number, Address”.
BTW - I have thougut about changing the summary template to one line per potential change, but I’m not sure if that would help. Something like this:
0
1
2
3
4
Instead of what I now have which is 0 1 2 3 4
Thanks
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 3, 2022, 8:20am UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/6 "2022-03-03T08:20:09Z")
> [@Test\_Test](#):
>
> How do I clean up this template column?
- Change the template so that it produces a comma separated (joined) list
- Then do a split text on the template (this will ignore any empty values)
- Then finally, create a joined list column from the previous split text column
---
### Author:  [@Test\_Test](https://community.glideapps.com/u/Test_Test)
#### Post date: [March 3, 2022, 8:35am UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/7 "2022-03-03T08:35:46Z")
Thanks, you rock (again) 🤘
> [@Darren\_Murphy](#):
>
> this will ignore any empty values
The secret ingredient 🪄
Is this a documented feature/behavior?
---
### Author:  [@Test\_Test](https://community.glideapps.com/u/Test_Test)
#### Post date: [March 3, 2022, 9:01am UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/8 "2022-03-03T09:01:46Z")
If it’s OK with you, I’d like to just to the next step of this same use case: how to display the “change report” to the user.
The custom form is adding a row to a table serving as a “Change log”. I’m using a “list relation” component inside the client details screen. Clicking on this will lead us to a cards view of the changes made to that client. Now, clicking on any of these cards will take us to a new screen with the details of such a change. The issue I have now is how to show changes side-by-side, and show only the changes. i.e. - no need to show values that haven’t changed. This log table has both the updated values and the previous values. What I did now is have two “action text” for each value: previous and updated. These are visible only if the “updated” is not empty.
Needless to say, this looks bad.
I would love to have this with an inline list, but how do I refer the inline list to a single row? I’ve found this great post by @Jeff_Hager , but it seems like an overkill…
> [@Show Entire Row Data in an Inline List](https://community.glideapps.com/t/show-entire-row-data-in-an-inline-list/24985/8):
>
> OK, so you do in fact want to join all the columns together into one list item. That’s what I needed clarification on. Your details view is only attached to a single row, so yes, a basic table is only going to show data from a single row. The short answer is that what you want isn’t natively possible with glide. Something like this would probably take some experimentation, but I think it may be possible with an inline list combined with a template column that joins all columns together, and …
The other component I would be happy to use is a basic but here I have two challenges: 1. Need a 3rd column (Name of change, previous, updated). 2. It will show a line even if updated value is empty.
> [@Darren\_Murphy](#):
>
> 
Based on your visual example here, here’s a quick visual example from MS-Word. This is how the user should see it.
Ideas? Magic tricks?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 3, 2022, 9:06am UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/9 "2022-03-03T09:06:31Z")
I’d probably create a HTML table with each of your 3 columns and display that in a rich text component.
If you can give me a sample app with an example of what you currently have, I can probably show you how to generate that table.
---
### Author:  [@Test\_Test](https://community.glideapps.com/u/Test_Test)
#### Post date: [March 3, 2022, 9:12am UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/10 "2022-03-03T09:12:04Z")
> [@Darren\_Murphy](#):
>
> sample app with an example of what you currently have
Sure, I’ve added a table called “ClientDetailsChangeLog” to [my dummy app](https://zealous-industry-4102.glideapp.io/).
Thanks friend!
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 3, 2022, 9:49am UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/11 "2022-03-03T09:49:55Z")
I’m a bit busy with my day job at the moment, but I’ll find some time to take a look at this later this evening.
---
### Author:  [@Test\_Test](https://community.glideapps.com/u/Test_Test)
#### Post date: [March 3, 2022, 10:32am UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/12 "2022-03-03T10:32:05Z")
> [@Darren\_Murphy](#):
>
> m a bit busy with my day job at the moment
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 3, 2022, 1:15pm UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/13 "2022-03-03T13:15:22Z")
> [@Test\_Test](#):
>
> Sure, I’ve added a table called “ClientDetailsChangeLog” to [my dummy app](https://zealous-industry-4102.glideapp.io/).
erm, that doesn’t look like it’s going to scale very well to me.
Let me think about this a bit more. Assuming that you’re okay with a HTML table, then I think the best approach would be to build the rows for that table at the time the change is made, and write them as a template to a single column.
So in effect, your Change Log table would end up with just a handful of columns:
- Change Date
- Who made the change
- Change Details
That last column would contain the HTML table definition for all columns that were changed.
---
### Author:  [@Test\_Test](https://community.glideapps.com/u/Test_Test)
#### Post date: [March 3, 2022, 1:51pm UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/14 "2022-03-03T13:51:30Z")
While I’m not sure I understand your proposal in full, it does sound as way to complicated for a simple visual aid.
If was thinking earlier about the Array options in Glide, but these seem to be complicated as well. By “complicated” I’m not referring to the setup process (although it could be easier), I’m referring to the day-to-day operations later on and the chances for something going wrong when you have to jump through so many hoops to reach such a simple view.
Another option I was thinking about is JS, but again, too much hassle.
My primitive solution of a double action item per each value is much more stable I think. But it looks like a piece of software from an era long forgotten 😆
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 3, 2022, 2:09pm UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/15 "2022-03-03T14:09:44Z")
> [@Test\_Test](#):
>
> While I’m not sure I understand your proposal in full, it does sound as way to complicated for a simple visual aid.
Be patient. I’ve started making a sample app for you. I’ll try and finish it off before I go to bed tonight.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 3, 2022, 4:29pm UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/16 "2022-03-03T16:29:06Z")
@Test_Test here you go…
> **[Change Log Demo · Glide - 4 March 2022](https://www.loom.com/share/3f43832fde50443d868eb597e6d3e203)**
Copyable Demo App
> **[Change Log Demo](https://raspy-carriage-2545.glideapp.io/)**
---
### Author:  [@Test\_Test](https://community.glideapps.com/u/Test_Test)
#### Post date: [March 3, 2022, 5:39pm UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/17 "2022-03-03T17:39:45Z")
> [@Darren\_Murphy](#):
>
> @Test_Test here you go…
>
> [Loom | Free Screen & Video Recording Software | Loom](https://www.loom.com/share/3f43832fde50443d868eb597e6d3e203)
Once again, as always, WOW times a gazillion 🤯
> [@Darren\_Murphy](#):
>
> Copyable Demo App
>
> [https://raspy-carriage-2545.glideapp.io/](https://raspy-carriage-2545.glideapp.io/)
Sorry to sound ungrateful, but it’s not copyable…
---
### Author:  [@Test\_Test](https://community.glideapps.com/u/Test_Test)
#### Post date: [March 3, 2022, 9:36pm UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/18 "2022-03-03T21:36:14Z")
Paying it forward, here’s a quick recap of the columns that are used to construct the HTML table. Hope it’ll be useful for someone down the line. Note that my text Is aligned RTL.
Table top:
```auto
| VALUE |
BEFORE |
AFTER |
```
The heart of the table, the rows:
```auto
| VALUE |
BEFORE |
AFTER |
```
The bottom:
```auto
```
We than consolidate all rows:
And last, merging the three parts:
Thanks and see you on the next topic!
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 4, 2022, 12:58am UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/19 "2022-03-04T00:58:00Z")
> [@Test\_Test](#):
>
> Sorry to sound ungrateful, but it’s not copyable…
whoops, sorry about that.
It’s copyable now.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [March 5, 2022, 12:58am UTC](https://community.glideapps.com/t/basics-again-accumulated-list/39152/20 "2022-03-05T00:58:19Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.