# How to refresh the record list after a "soft delete"?

**URL:** https://www.five.org/t/how-to-refresh-the-record-list-after-a-soft-delete/640
**Category:** How do I?
**Created:** [May 3, 2026, 10:54pm UTC](https://www.five.org/t/how-to-refresh-the-record-list-after-a-soft-delete/640 "2026-05-03T22:54:37Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![JeanXXIV](https://yyz2.discourse-cdn.com/flex030/user_avatar/www.five.org/jeanxxiv/32/548_2.png) [@JeanXXIV](https://www.five.org/u/JeanXXIV)
#### Post date: [May 3, 2026, 10:54pm UTC](https://www.five.org/t/how-to-refresh-the-record-list-after-a-soft-delete/640/1 "2026-05-03T22:54:37Z")

</div>

Hello,

I have implemented a “soft delete” functionality by adding a IsDeleted field to my table. In y form, I added a condition to the Data Filter to only show records where ‘IsDeleted = 0’.

I created a custom button to perform the soft delete. However, I’m having trouble refreshing the interface:  
When I trigger the soft delete, the form closes correctly using five.selectAction(“MyForm”) in the ‘On Finish’ event but the record list still shows the deleted item.

Is there a way that the record disappears from the list as soon as the soft delete function is executed ?

Note: The “undelete” function works fine when using a live query with the data view.

See the following gif. I also included the fdf application sample.

![soft-delete](https://canada1.discourse-cdn.com/flex030/uploads/five/original/2X/d/d03783e123ff1655469bff1064bd458400c85663.gif)

Thank you!

Jean

[TestSoftDelete-20260503-224657605906961.fdf](https://www.five.org/uploads/short-url/kD4ZMSRGtnIRP9ZVfX93U1970Io.fdf) (3.4 MB)

---

<div class="post-metadata">

### Author: ![eltonsantos](https://avatars.discourse-cdn.com/v4/letter/e/b19c9b/32.png) [@eltonsantos](https://www.five.org/u/eltonsantos)
#### Post date: [May 4, 2026, 10:57pm UTC](https://www.five.org/t/how-to-refresh-the-record-list-after-a-soft-delete/640/2 "2026-05-04T22:57:44Z")

</div>

Hi Jean,

Thank you for bringing up this question and for the details.

The issue you are facing is that the delete is not signalling to the form that a change has been made.

I will provide a workaround. Please let me know if that works.

```auto
function RefreshCurrentForm(five, context, result) {

five.selectMenu('Recyclebin')

five.selectAction("Fruits");

return five.success(result);

}

```

This will mimic the user leaving the form and returning, and that should give you the refreshed form after you update the table.

Observation:  
Just to let you know, in the next version, which we are working on at this moment, you will only need to add the method ‘**five.refreshTable(“Fruits”);**’ in the function SoftDeleteFruit after you perform the Update, this will force the form and any live query that uses this table to update.

Regards,

Elton S

---

<div class="post-metadata">

### Author: ![JeanXXIV](https://yyz2.discourse-cdn.com/flex030/user_avatar/www.five.org/jeanxxiv/32/548_2.png) [@JeanXXIV](https://www.five.org/u/JeanXXIV)
#### Post date: [May 5, 2026, 12:55am UTC](https://www.five.org/t/how-to-refresh-the-record-list-after-a-soft-delete/640/3 "2026-05-05T00:55:29Z")

</div>

Hi Elton,

Great! works fine on the sample and on my application, thank you!

Regards,

Jean

---

<div class="post-metadata">

### Author: ![eltonsantos](https://avatars.discourse-cdn.com/v4/letter/e/b19c9b/32.png) [@eltonsantos](https://www.five.org/u/eltonsantos)
#### Post date: [August 24, 2026, 3:14am UTC](https://www.five.org/t/how-to-refresh-the-record-list-after-a-soft-delete/640/4 "2026-08-24T03:14:19Z")

</div>

Hi Jean,

Your latest account upgrade should have the fixes for this issue.

Can you please try again using the method ‘**five.refreshTable(“Fruits”);**’ and let me know how that goes?

Thank you.  
Elton S

---

<div class="post-metadata">

### Author: ![JeanXXIV](https://yyz2.discourse-cdn.com/flex030/user_avatar/www.five.org/jeanxxiv/32/548_2.png) [@JeanXXIV](https://www.five.org/u/JeanXXIV)
#### Post date: [August 26, 2026, 2:28pm UTC](https://www.five.org/t/how-to-refresh-the-record-list-after-a-soft-delete/640/5 "2026-08-26T14:28:08Z")

</div>

Good! I removed the workaround in the sample and the record disappears from the list as soon as the soft delete button is pressed. Thank you!
