Deleting Records

You can delete records using the following three methods: 

Using Batch Deletes

You can delete many records at once using Batch Deletes within the Data Builder as well as on the live app if enabled. 

In the Data Builder

To delete many records at once within the Data Builder, click on the Batch Operations button within your selected data table and select the Delete option.

A new window will pop up prompting you to create a condition that if met, those records will be deleted. For instance, you can create a condition that if the Expense Name field contains the value of "ad", delete that record. You can create multiple conditions. Once you are finished defining your condition(s), click Next. 

You will have the opportunity to confirm your batch delete before records are deleted. As you can see in the image below, one record was found matching this condition and you have the opportunity to confirm going ahead with this delete by clicking on the Delete button.

As you can see in the image below, one record matching the condition of "Expense Name contains 'ad'" was found and this record was deleted. 

On the live app

You can empower your users to delete many records at once from the live app using batch deletes.

At this time, batch deletes from the live app is only available in the table component. You can choose whether or not to enable frontend batch delete functionality within the settings of each table component, and you can enable frontend batch deletes for some table components on your app and not others.

When you enable frontend batch delete for a table component, users will be able to delete many records at once based on whether their custom-defined conditions are met, similar to batch deletes in the Data Builder. To make a batch delete, users can click on the Delete button within the table component.

A new window will pop up prompting users to create a condition that if met, those records will be deleted. For instance, users can create a condition that if the Expense field value is lower than "1000", delete those records. Users can create multiple conditions. Once they finish defining their condition(s), users can click Next to continue. 

Users will have the opportunity to confirm their batch delete before records are deleted. As you can see in the image below, one record was found matching this condition and users have the opportunity to confirm going ahead with this delete by clicking on the Delete button.

As you can see in the image below, one record matching the condition of "Expense is lower than '100'" was found and this record was deleted. 

Using single delete

To delete a single record at a time within the Data Builder, click on the trash icon to the left of each record within the selected data table to delete that record.

Using a Delete Link

Adding a Delete Link to a data component will add a link to each record within that component for users to click on and delete each record. 

For instance, within a Companies table component, you can click on Links > Delete Link from the component's left-side menu to add a new column to the table component with the Delete Link.

Once added, you can click on the pencil edit icon on top of the Delete Link column to customize the link's text as well as the delete confirmation message that will display when users click on a record's Delete Link. 

On the live app, when users click on a record's Delete Link, they will see the default delete confirmation message (or your customized delete confirmation message if you have changed the default version).

Please Note: You can not add a Delete Link within Detail Components.