Update table booking set booking_user = "joe@joe.com"

Need help Database
1

I want to update every booking_user column/field with “joe@joe.com” for the entire booking table

How do I do that. Not necessarily as a workflow in the app, but just as a one off.

2

If not in a workflow, then just do it in the database for one-offs?

1 Like
3

Well, I’m would normally use SQL even if I have to update 10 rows, but I’m just too lazy for that. There are only 10 or 20 rows.

For 500 I will NOT do that.

How would you do this in a workflow for 500 records?

4

Most likely you’ll want to look into the data API: https://manual.bubble.io/core-resources/api/data-api#modify-a-thing-by-id You can automate with an admin page / one-off workflow, or you could write. a script in a separate tool to get the objects, loop over them and update them.

5

I need loops and control structures ??