Editing multiple rows at once during an event

Need help Database
1

Hi there,

I am trying to update multiple rows (specifically, their date column) in one of my DB’s as a result of a user requesting to change the date of a single row.

That is, the user has a subscription date, and requesting to change that date should update all other dates so that their subscriptions align.

I came across this old topic (How to create and update multiple rows), which looked to be asking a similar question, but looks to have gone unanswered? I’ve looked into Backend Workflows, but they don’t seem to offer any functionality for multi-row updates either. The update would be easy to do in SQL:

UPDATE subscriptions_table
SET sub_date = YYYY-MM-DD
WHERE user = user;

How come this feels nearly impossible in Bubble; or am I missing something?

2

Make changes to a list of things.,

3

Hmm, not sure what I was doing before that was blocking me - you are totally right. Thank you!

1 Like