# Get rid of deleted rows in relation columns

**URL:** <https://connect.superhuman.com/t/get-rid-of-deleted-rows-in-relation-columns/56525>\
**Category:** Ask the Community\
**Created:** [July 11, 2025, 7:14pm UTC](https://connect.superhuman.com/t/get-rid-of-deleted-rows-in-relation-columns/56525 "2025-07-11T19:14:50Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Samuel\_Langford](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/samuel_langford/32/47844_2.png) [@Samuel\_Langford](https://connect.superhuman.com/u/Samuel_Langford)\
**Post date:** [July 11, 2025, 7:14pm UTC](https://connect.superhuman.com/t/get-rid-of-deleted-rows-in-relation-columns/56525/1 "2025-07-11T19:14:50Z")

</div>

Hello!

If I delete a row, its “ghost” still appears in any relation column that it was in:

 ![image](https://global.discourse-cdn.com/coda1/original/3X/d/e/de6ec234122dbcc51f7a106d58b1b2234528c307.png)

Is there a way to prevent this from happening or remove them completely?

---

<div class="post-metadata">

**Author:** ![johnnyrsm](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/johnnyrsm/32/47030_2.png) [@johnnyrsm](https://connect.superhuman.com/u/johnnyrsm)\
**Post date:** [July 17, 2025, 8:08pm UTC](https://connect.superhuman.com/t/get-rid-of-deleted-rows-in-relation-columns/56525/2 "2025-07-17T20:08:06Z")

</div>

You can remove them by clearing the value on the relation column for each of the affected rows.

You can get all rows with “ghost” values by filtering your affected table with: `Source_Relation_Table.Contains(thisRow.Relation)`

Then you can set them all to blank or to a different value using ModifyRows.

---

<div class="post-metadata">

**Author:** ![ronald\_javet](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ronald_javet/32/45812_2.png) [@ronald\_javet](https://connect.superhuman.com/u/ronald_javet)\
**Post date:** [September 1, 2025, 2:34am UTC](https://connect.superhuman.com/t/get-rid-of-deleted-rows-in-relation-columns/56525/3 "2025-09-01T02:34:52Z")

</div>

Hi, im running into this problem but i dont get your solution. I already have several linked records and deleteds in between, cant erase everything!

appreciate your help 🙂

 ![Captura de pantalla 2025-08-31 a la(s) 10.32.11 p.m.](https://global.discourse-cdn.com/coda1/original/3X/9/d/9d1e7137f513344b4244f2b9424da28f221f59cb.png)

---

<div class="post-metadata">

**Author:** ![ronald\_javet](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ronald_javet/32/45812_2.png) [@ronald\_javet](https://connect.superhuman.com/u/ronald_javet)\
**Post date:** [September 1, 2025, 2:45am UTC](https://connect.superhuman.com/t/get-rid-of-deleted-rows-in-relation-columns/56525/4 "2025-09-01T02:45:59Z")

</div>

so i switched the linked column view from open button to value and then i can see the deleted ones and then went one by one 🙄

---

<div class="post-metadata">

**Author:** ![Rickard\_Abraham](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/rickard_abraham/32/35007_2.png) [@Rickard\_Abraham](https://connect.superhuman.com/u/Rickard_Abraham)\
**Post date:** [September 5, 2025, 7:41pm UTC](https://connect.superhuman.com/t/get-rid-of-deleted-rows-in-relation-columns/56525/5 "2025-09-05T19:41:48Z")

</div>

A better way to remove “deleted” rows is using the `IsFromTable` formula, something like this

```javascript
thisRow.ModifyRows(
    Relations,
    thisRow.Relations.Filter(CurrentValue.IsFromTable(RelationsTable))
)

```

---

<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:** [December 4, 2025, 7:42pm UTC](https://connect.superhuman.com/t/get-rid-of-deleted-rows-in-relation-columns/56525/6 "2025-12-04T19:42:12Z")

</div>

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