# Is there a way to show ALL users to have previously modified a row/value?

**URL:** <https://connect.superhuman.com/t/is-there-a-way-to-show-all-users-to-have-previously-modified-a-row-value/36773>\
**Category:** Ask the Community\
**Created:** [January 17, 2023, 6:25pm UTC](https://connect.superhuman.com/t/is-there-a-way-to-show-all-users-to-have-previously-modified-a-row-value/36773 "2023-01-17T18:25:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Billy\_Jackson](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/billy_jackson/32/31366_2.png) [@Billy\_Jackson](https://connect.superhuman.com/u/Billy_Jackson)\
**Post date:** [January 17, 2023, 6:25pm UTC](https://connect.superhuman.com/t/is-there-a-way-to-show-all-users-to-have-previously-modified-a-row-value/36773/1 "2023-01-17T18:25:30Z")

</div>

Currently, the Modifiedby formula returns the last modifier. I’ve been trying to think of a programmatic way to recursively append this user to a list to show ALL users who have modified a certain row, but have come up blank.

Anyone more clever than me found a way to do this?

Thanks!

---

<div class="post-metadata">

**Author:** ![Scott\_Collier-Weir](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/scott_collier-weir/32/29677_2.png) [@Scott\_Collier-Weir](https://connect.superhuman.com/u/Scott_Collier-Weir)\
**Post date:** [January 17, 2023, 6:46pm UTC](https://connect.superhuman.com/t/is-there-a-way-to-show-all-users-to-have-previously-modified-a-row-value/36773/2 "2023-01-17T18:46:29Z")

</div>

> [@Billy\_Jackson](#):
>
> a returns the last modifier. I’ve been trying to think of a programmatic way to recursively append this user t

Sure!

Just run an automation upon row change that logs whoever modified a column into a long-text or Canvas style column in CSV format. You would go ahead and use the ModifyRow() action, and modify the row to be a concatenation of:

- The current cells value (so you don’t lose historical data)
- A line break (so you can keep each new log on its own line)
- Format({1},{2} , user().email, now()) – This logs the current person who just modified and the time they modified

Let me know if you need a little more help! This video breaks down some of the key concepts but with a slightly different workflow and a button as opposed to an automation. but all the same principles apply!

[![](https://global.discourse-cdn.com/coda1/original/3X/4/b/4b344c0c2842f43ebf1707bdb3e3c727833616a5.jpeg "WARNING: Advanced Coda technique - Allows you to store way more data") ](https://www.youtube.com/watch?v=-jdFMv5qcvo&t=418s)

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [April 17, 2023, 6:46pm UTC](https://connect.superhuman.com/t/is-there-a-way-to-show-all-users-to-have-previously-modified-a-row-value/36773/3 "2023-04-17T18:46:59Z")

</div>

Closed on April 17, 2023, 6:46pm UTC

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.