Ask AI

Delete Record

Letting users delete records in your data.

This Action Button lets you delete records in your data source. To demonstrate how the Delete Record button works, weโ€™re going to use a List block connected to an Airtable data source, which shows a list of tasks for a hypothetical product development team and has three fields: Name (the name of the task), Assignee (who it is assigned to), and Status (the current progress status of the task). We want to enable a โ€œDelete task statusโ€ button to allow project managers to delete tasks.

List of tasks
List of tasks

First, we are going to configure the button label and that texts that are going to be shown in the pop-up (or modal) opened by the delete button.

Configuring button and modal labels and other texts
Configuring button and modal labels and other texts

Button Visibility

Now, letโ€™s configure the button visibility to specify who the button is going to be visible to. The users of our task list are the same people who are working on those tasks, so we are going to connect the same Airtable base with tasks and assignees to Softr as a user database.

Airtable table with the list of tasks and assignees.
Airtable table with the list of tasks and assignees.
๐Ÿ’ก
The users sync between Softr and data source is one-way (from Softr to data source), so, if you connect a data source with users without having them in Softr first, youโ€™ll need to create the same users in Softr as well to establish the connection.

Now, letโ€™s configure the actual button visibility settings. We need to allow only Project Managers to delete tasks, so, first of all, we need to create a User Group that includes only the users whose Position is Project Manager.

Creating a user group for project managers
Creating a user group for project managers

Next, we need to navigate to our delete buttonโ€™s visibility settings and select the user group that is going to be able to view the button.

Setting button visibility
Setting button visibility

Thatโ€™s it. The next and last step is to make sure everythingโ€™s working as expected.

๐Ÿ’ก
In Button Visibility settings, apart from selecting user groups under WHO CAN SEE, you can also set conditional visibility under ON WHICH RECORDS. This works similar to list conditional filters.

Testing task deletion

To test our setup, we are going to log into our application with a user whose position is Project Manager and attempt to delete one of the tasks. The following gif illustrates that.

Deleting a task
Deleting a task
Did this answer your question?
๐Ÿ˜ž
๐Ÿ˜
๐Ÿคฉ

Last updated on April 18, 2023