Client Survey
| Id | Name (Link) | Surname | Gender | Marital Status | Have Kids | Mobile | Age | Last Updated On | Remove |
|---|
1
2
3
...
Requirement: Form and DB Operation 7 - Delete Feature (Soft Delete)
This exercise finalizes the CRUD operations by implementing **Soft Deletion** and adding necessary UI feedback for destructive actions.
List Screen Updates:
- Add a new column, Remove, at the end of the table.
- Each row in the Remove column must contain a **Trash icon** (🗑️) that triggers the delete process.
Delete Functionality:
- Clicking the **Trash icon** must open a **Confirmation Popup** (Modal).
- The popup should display the message: "This action will remove the record from the database, would you like to proceed?".
- The popup must have two buttons: Yes and Cancel.
- If the user clicks Cancel, the popup closes, and no action is taken.
- If the user clicks Yes:
- The delete operation must perform a **Soft Delete** (set the record's **IsActive** attribute to False). Do not physically delete the record.
- A **Spinner** must be shown on the screen, simulating the execution of the database operation.
- After the simulated operation (e.g., 1 second delay), the list data is refreshed (which hides the now inactive record).
Hint (OutSystems): For soft delete, use an **Update Server Action** to set the `IsActive` field to `False`. Filtering the table data is then done by adding a condition: `Filter = RecordList.IsActive = True`.
Practice with Ankit | Form and DB Operations