I have a scenario where I have a table block that has multiple line items from a table pertaining to the logged in user. Imagine something like a cart in an ecommerce site, this page is similar to my-cart page.
What I intend to do is, I need to update the status of all items in the cart, and also the status of the original item when I click a button. In order to achieve this, I added a customizable form below the table block, removed all the fields that come by default, removed padding so that all that remains is a Submit button.
The only way I see to do this is through Zapier or Make webhook. I started with a Zapier webhook as the trigger step, then added a Find Records from Airtable as the second. But I’m not sure how to pass on all records from my cart. The approach I took was to add a hidden field where I pass in the logged in user’s email so that I can add a search formula in my Zap. Not sure why, I don’t see the passed email in my zap. Kind of stuck there.
When i try to use Make, I get a “Access denied CSRF user-agent check failed while requesting /trace” the moment I click on Create a Scenario. Raised a ticket with Make on the same.
Has anyone tried to update multiple records through a single click in Softr? Thanks in advance.
Hi @prettycold, have you tried using an Airtable automations or even a formula column?
I’ve used a one-click action button before to change an Airtable value to “something”. And then created an Airtable automation to do several steps based on a trigger that’s watching that initial cell change.
So when Qty = 0 for an item in your cart, run an automation to remove item (Airtable recordID) from the current cart table, etc.
Thanks for the response. Yes, I did think of one click update, since it was in a table block, the update was at a record level and not for all records. Which is why I came to the common form button. I started with Airtable automation, instead of updating a column in a table I was thinking of webhooks route and then invoking a series of steps to update multiple records.
Was just wondering whether there is any other common way of updating multiple records in a Softr + Airtable combo.
Sharing the method I used, just in case it helps someone. I ended up using Make. Here are the steps I followed: Created a custom webhook, then do a search records, followed by adding a router, one route that has an iterator to iterate each record and then update the corresponding table for each record. Another route has an aggregator to update a single row in another table followed by sending emails.