Ask AI

Add Record

Letting users add new records to your data.

This Action Button is available under Topbar Buttons and lets users add new records/rows to your data source.

๐Ÿ’ก
By default, youโ€™ll have one Add record button added to your block, which you can remove if needed.

So, letโ€™s see how you can set this action up and what features are available. 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 an โ€œAdd new taskโ€ button to allow development team members add new tasks to the list.

List of tasks
List of tasks

First, we are going to configure the button label.

Button label
Button label

Then, we are going to customize other texts for the button. As you can see in the following gif, itโ€™s also possible to preview the Add record pop-up, through which users are going to add new record details.

Setting up button texts and previewing the modal
Setting up button texts and previewing the modal

Next, we need to specify the field from our data source that are going to be available when adding a new record. To do that, we need to hit the Add field at the top of the button settings and add the necessary fields. To add a new task, we need to specify its Name, Assignee, and Status. Therefore, we are going to add a Text field and map it to the Name field on Airtable as well as add two dropdown fields and map them to Assignee and Status, as these two are single-select fields in our Airtable data source.

Adding fields for the add new task functionality
Adding fields for the add new task functionality
โ„น๏ธ
Among other fields, you can also add a Signature field to capture eSignatures when adding records.
โ—
Note that computed fields will not appear in the list of mappable fields for the form.

Button visibility

Now, we need to define who can see and use the button (see button visibility).

๐Ÿ’ก
Button visibility options depend on the subscription plan: โ†’ On Free and Starter plans you can decide who can see the button (All Users, Logged-in Users, or Non Logged-in Users) โ†’ On Professional plan you can also configure conditional visibility but canโ€™t set custom user groups. โ†’ On Business plan you have access to all the features in Button Visibility. See plan comparison.

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.

We are also going to create a user group that includes project managers only.

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

Next, we are going to set up button visibility so that only the Project Managers user group is able to access the button.

Setting button visibility
Setting button visibility

Now, letโ€™s test the setup and see how it works from the userโ€™s perspective.

Testing adding new tasks

To test our setup, we are going to log into our application with one of the project manager users and add a new task to the list. The following gif illustrates that.

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

Last updated on September 1, 2023