I'm new to Retool, and I'm currently experiencing an issue with updating multiple documents in Retool using Firestore.
Here's a brief overview of the issue I'm facing: I have created a Retool table that displays data from a Firestore collection, and I have enabled multi-row selection to allow users to select multiple rows.
My goal is to update multiple documents in Firestore by clicking a button in Retool, but I'm having trouble figuring out how to do this.
Here are the steps I've taken so far:
Created a Retool table that displays data from a Firestore collection
Enabled multi-row selection in the Retool table
Created a button in Retool that triggers a query to update a single document in Firestore
Tested the query to update a single document, and it works correctly
Attempted to modify the script called when clicking on the button to first, retrieve the ids of the selectedRows in the Retool table and then call the query for each id in order to update multiple documents.
I have a table that displays all the exercises in my collection. However, since it may contain thousands of rows, I would like to allow users to select the lines they want to update.
To achieve this, I have implemented a functionality where users can select the rows they want to update and then click on a button called "Edit Multiple Exercises". This opens a modal containing a new table with only the selected rows, which the user can then edit. Once the user saves the changes made in this new table, it updates the original table.