AppAlloy Documentation
Home
  • Glossary
  • 🚀Getting Started
    • Introduce AppAlloy Documentation
    • Build your first AppAlloy app
    • From sheet to app
  • 🗃️Data management
    • Learn data structure
    • Set up data source
      • Integrate with Google Sheets
      • Integrate with Microsoft Excel
      • Build Alloy table
      • Upload local file
    • Manage data type
    • Ultimate guide for data sheet
  • ⚒️Manage table views
    • Design Record View
    • Design Actions
      • Update current record
      • Delete current record
      • Delete many records
      • Create record
      • Open external URL
      • HTTP Request
      • Open phone call popup
      • Open SMS Popup
      • Open email popup
      • Send notification
    • Design Record Components
      • Plain Text
      • Phone number
      • Email
      • URL
      • Map
      • Barcode
      • Checkbox
      • Number
      • Currency
      • Rating
      • Voting
      • Date time
      • Relative date
      • Count Down / Count Up
      • Single Photo
      • Photo Gallery
      • Carousel
      • Audio Player
      • Video Player
      • Youtube Player
      • Vimeo Player
    • Design Form View
    • Design Form fields (synced tables)
      • Text (for synced tables)
      • Number (for synced tables)
      • Date time (for synced tables)
      • Checkbox (for synced table)
      • Options (for synced table)
      • Photos (for synced table)
      • Files (for synced table)
      • Table lookup (for synced table)
      • Signature (for synced table)
    • Design Form fields (Alloy tables)
      • Single line Text (for Alloy table)
      • Long Text (for Alloy table)
      • Phone number (for Alloy table)
      • Email (for Alloy table)
      • Barcode (for Alloy table)
      • Number (for Alloy table)
      • Currency (for Alloy table)
      • Checkbox (for Alloy table)
      • Date (for Alloy table)
      • Photos (for Alloy table)
      • Files (for Alloy table)
      • Single select (for Alloy table)
      • Multiple select (for Alloy table)
      • Address (for Alloy table)
      • Table lookup (for Alloy table)
  • 🎨Manage pages
    • Manage page types
    • Design 'View From' Page
    • Page Layouts
      • List Layout
      • Grid Layout
      • Card Layout
      • Map Layout
      • Checklist Layout
      • Calendar Layout
      • Kanban Layout
    • Design Canvas View Page
    • Canvas Charts
      • Line chart
      • Area Chart
      • Pie Chart
      • Donut Chart
      • Column chart vs. Stacked Column chart
      • Bar chart vs. Stacked bar chart
      • Table
    • Design Form of... Page
  • ⚙️Manage workflow
    • Introduce Workflow
    • Design a workflow
  • 🔌Manage Integration
    • Manage AppAlloy Integration
    • Manage Slack Integration
    • Manage Gmail Integration
    • Manage Google Drive Integration
    • Manage Google Calendar integration
  • 📱Manage App Settings
    • Manage app appearance
  • 🌎App distribution
    • Publish your app
    • Use app as Mobile Web app
    • Use app on AppAlloy Air
  • 🚹Account, team, and plan
    • Manage Account
    • Manage Apps
    • Manage Users
    • Manage Plans
    • Manage Teams
  • #️⃣Learn Power FX
    • Introduce Power FX
    • Operators & Identifiers
    • Formula References
      • Average
      • Concatenate
      • Date
      • DateAdd
      • DateDiff
      • DateValue
      • DateTimeValue
      • Day
      • If
      • Month
      • Now
      • Rand
      • RandBetween
      • Round
      • RoundDown
      • RoundUp
      • Sum
      • Text
      • Today
      • Weeknum
      • Weekday
      • Year
Powered by GitBook
On this page
  • What is it?
  • How it works
  • Add the action
  • Configure the action
  • Require confirmation
  • Completion

Was this helpful?

  1. Manage table views
  2. Design Actions

Delete many records

The "Delete Many Records" allows users to remove several records from a specified table by one tap on the action button.

Last updated 8 months ago

Was this helpful?

What is it?

The "Delete Many Records" action is a powerful feature that allows your app to delete multiple records from a specified table in one go.

This action is useful when you need to clear out data based on specific criteria, such as removing outdated entries, cleaning up test data, or managing records in bulk.

How it works

When you enable the action to the Record View, there is a menu of action buttons added to the bottom bar of the record view.

You will configure the table whose records will be deleted and set the condition to filter which records will be removed as the result of the action.

The action first evaluates the records in the table against the conditions you’ve set. Only those records that match the specified conditions or condition groups are deleted.

Add the action

  • From the Design tab, in the Tables section of the left sidebar, click on the Record view of any table.

  • Go to the Action section on the right sidebar, and click the + button.

  • Enter the name and icon for the action button, then click Configure...

  • Click + Then... and choose Delete many records.

Configure the action

In Table, choose the table from which you want to delete records as the result of the action. Ensure you select the correct table, as the deletion process cannot be undone.

In Delete all records that match, you define the conditions to filter the records that will be deleted.

To add a new condition, choose + Add condition or + Add condition group

What is condition and condition group?

  • Condition: A single criterion that defines a filter. It consists of a column, a condition type, and a condition value.

  • Condition Group: A set of conditions grouped together. You can link multiple condition groups using logical operators (OR or AND) to refine your filter further.

To add a condition

  • Click + Add condition

  • Choose a column as the filtering criteria

  • Choose the condition type that best suits your needs such as equals, contains, greater than, less than, etc.

  • Input the specific value or range of values that will be used for filtering.

If you need to apply multiple filters:

  • Click the “Add Condition” button and modify the same steps as the previous one

  • Configure the relation between conditions using :

    • "and" to require all conditions must be true, or

    • "or" to require any condition must be true.

To add a group filer

  • Click + Add condition group

  • Within the group field, click the + button on the right end to add a new condition to the group

  • Configure the condition of the group with the same steps as the single condition configuration.

  • Configure the relation between a single condition-group, group-group, and condition-condition inside a group using the:

    • "and" to require all conditions must be true, or

    • "or" to require any condition must be true.

the relation is configured by once to be applied for all the following

Require confirmation

Requiring a confirmation on the execution of the action can give users the chance to reconsider and avoid accidental taps.

You can also customize the confirmation message or use the default one.

Completion

In the settings of completion, you will configure

  • The message on succession to your users can be a way to communicate as well as engage with your users, elevating the user experience with your app.

  • Checkbox to enable the Confetti interaction like a celebration for the succession, making the experience more fun and rewarding.

⚒️
Add the action Delete many records to the Record view
Set condition or/and condition group to filter the records that will be deleted
Configure the confirmation message on action excecution