Implementing a bulk edit on the Data Table
Last updated
Last updated
We've recently updated this tutorial to make it clearer and more consistent. We also added some missing information about the delimiter attribute in section 2.3.
This tutorial will show you how to add a "bulk edit" feature to your Salesforce flows using the Avonni Data Table. Users can select multiple opportunities in the table and then click a button to edit all of them at once in a separate screen flow.
This tutorial is pretty straightforward. We have two parts:
Main Screen Flow: This displays the Data Table with all the relevant information.
Bulk Edit Screen Flow: This flow shows only the selected records from the first flow in a special Avonni Data Table that lets users edit multiple records simultaneously.
We'll use the "Open Flow Dialog" action to let users switch between these two flows and do the bulk editing.
Add the Data Table: Drag and drop the Avonni Data Table component onto your screen.
Connect to your data: Choose the "Query Data Source" option to connect your Salesforce data and the Data Table directly.
Choose your columns: Click the "Add Columns" button in the "Data Mappings" section to select which fields you want to display in your table
Now that we've added the data to our Data Table, let's create a button at the top to trigger the bulk edit functionality.
Open Header Settings: Expand the "Header" section in the Data Table properties.
Add the Button: Click on the "Add Actions" button.
Name the Button: Enter a clear label, like "Bulk Edit"
Let's build the second screen flow that will open when users click the "Bulk Edit" button. This flow will let them edit multiple records simultaneously.
Here's a quick overview of how we'll structure the bulk edit flow. In the following steps, we'll explain each part in more detail.
First, we need a place to store the IDs of the records the user wants to bulk edit.
Create New Resource: Click the "New Resource" button in the Flow Builder.
Choose Variable: Select "Variable" as the resource type.
Name the Variable: Give it a descriptive name, like "selectedRecordIds".
Set the Data Type: Choose "Text" as the data type.
Allow Multiple Values: Make sure to check the "Allow Multiple Values" box, as we'll be storing multiple record IDs
The first step in our flow is to add the "Join Text Collection" Avonni Action. We need this because the record IDs we get from the main Data Table are separated only by commas. This action will let us add the delimiter ',' between each ID, which is necessary for using them in our dynamic query filter later on. Without this action, we won't be able to create the right syntax for our Data Table query filter.
Enter a label
For the Source Collection, select the collection variable we created just above.
In the Delimiter attribute, enter this ',' as we want to delimiter by the comma.
In the Show Advanced Option" section, check "Manually Assign Variables"
Next, we need to manually create a variable to store the result of the "Join Text Collection" action. We'll use this variable later in our query to filter the records.
Now, let's create a formula that will act as a dynamic filter for our bulk edit Data Table. This filter will ensure we only see the records the user selected.
The formula looks like this:
recordIds is the variable we created earlier to store the output of the Avonni Action.
This formula says, "Show me only the records whose ID is included in this list of IDs."
Let's add a new screen to your flow and put the Avonni Data Table on it. This Data Table will use a "Query Data Source" to show only the records the user wants to bulk edit.
Add the columns you need: Choose the fields you want users to be able to edit and add them as columns in the Data Table
For the Query Filter, make sure to map the filter to the formula query filter we created just above
Make sure to adjust those settings on the Data Table
All Columns Settings, check dispaly as input and Editable
Toggle the "Hide Checkbox Column" and 'Always Display Bottom Bar"
Last but not least, add "On Save" interactions on the Bulk Edit Data Table.
Add an "Update Records" interaction to make sure the information is saved
Add a Finish Flow Navigation interaction to ensure the bulk edit flow dialog box will be closed once your users save the information.
We need to connect our main flow to the bulk edit flow to make the bulk edit feature work. We'll use the "Interactions" tab to activate the "Bulk Edit" button in the header. Here's how:
Return to the first flow we created (the one with the list of opportunities and the "Bulk Edit" button).
Add the Interaction: Click the "Add Header Action" button.
Choose the Button: Select the "Bulk Edit" button we created earlier as the target.
Pick the Action Type: Select "Open Flow Dialog." Clicking the button will open another flow in a pop-up window.
Select the Flow: In the "Flow API Name" section, choose the flow you want to open when the button is clicked
Name: Enter the same name as the variable you created in the second flow (we'll explain this in Step 2).
Value: Select "Selected Record Ids". This will send the IDs of the selected opportunities to the second flow.
Type: Choose "Text".
Allow Multiple Values: Make sure this is toggled on so users can select multiple records for bulk editing.
Size: select Large
On Finish: Choose the "Refresh Query" interaction. This will automatically update the main Data Table to reflect any changes made during the bulk edit.
Having trouble with this tutorial? Contact Avonni support for help.
