🧠 Avoiding Detail View After Deleting a Record

AppSheet Tips & Tricks
1

? Tip: Avoiding Detail View After Deleting a Record

When you delete a record from a Detail View in AppSheet, the app may return you to another Detail View—often of a now-deleted or empty record. This can create a confusing user experience.

Instead of landing in an empty detail view, wouldn’t it be better to return to the list view where all records are shown?

:magnifying_glass_tilted_left: Tried and Failed?

You may have considered using a grouped action like:

  1. Go to another view

  2. Delete the record

…but:

  • If Go to view runs first → it navigates, but doesn’t delete.

  • If Delete runs first → the record is deleted, but the view doesn’t change.

:white_check_mark: Solution: Deferred Deletion via Bot

1. Add a column to your table
Name it [to_telete], type: Yes/No

  • Set Initial value = false

  • Mark it as hidden (since it’s internal-use only)

2. Create a grouped action
Set it as primary (e.g., your “Delete” button)

  • Action 1: Go to another view within this app

    • Use LINKTOFILTEREDVIEW()

    • Target your destination view and apply a filter

    • Set this action as hidden

  • Action 2: Set the value of a column in this row

    • Set [to_delete] to true

    • Also hidden

3. Create a Bot

  • Event: Triggers when [to_delete] = true

  • Process: Executes the Delete action for the row

? Result:

When the grouped “delete” action is triggered:

  • You’re navigated instantly to the view you want (e.g., the table view of all records)

  • In parallel, the record deletion happens behind the scenes via the bot

:white_check_mark: You’ll see the data syncing, and soon the deleted record vanishes from view. Seamless UX!

3 Likes
2

@sorin_mihai Here’s a solution.