Hi,
I’ve been going at it for hours trying to figure this out, so I figured someone might know a solution here. For background, I am creating a site with products that are pulled from an Airtable database. These are shown in a repeating group, and a type of user can click a button to add the product’s specific ID to their “cart” list of products in Bubble User database. Then, users go to a checkout page with another repeating group of the Airtable database, but with a condition that only shows the product ID’s that are in the User’s cart.
Now, I need the user to click a button, and then it will modify all records in the Airtable database that match the list of product ID’s in the user’s cart. This will change a Status column in all records from “No” to “Yes”.
Would anyone have any thoughts on how to accomplish this? Any help is appreciated.
Edit - Another way to pose the question that might make more sense: In Bubble User database, users have a list of unique product identifiers. The products are listed in an Airtable database. I want a button to take the user’s unique identifiers, match them with the records in Airtable database, and switch a text value in a column for all the matched records.