Modify a list of things

Need help
1

I have two tables:

TABLE01-BLOGGER-NAMES
BloggerName
BloggerSocialID
BlogPostInProgress = yes/no

TABLE02-BLOGGER-BOOKINGS
BloggerName
BloggerSocialID
DateSent
TypeofBagSent
Completed=yes/no

Table 01 is a list of bloggers
Table 02 records a list of bags we have sent to bloggers.

Now I want to go through every record on Table02 that is “Completed=no” and look for that BloggerSocialID in Table 01 and change the status of “BlogPostInProgress=yes”

Is that possible to do that for all the thousands of entries I have ?
Thanks

2

Yes, but Bubble tables don’t really work best like that.

Instead of “BloogerSocialID” in TABLE02-BLOGGER-BOOKINGS you would define the field type as TABLE01-BLOGGER-NAMES which makes a direct link. And for example call it Blogger.

That means you don’t have to do a search each time. You can just set Blogger’s BlogPostInProgress = yes.

Have a look at API workflows. You can kick them off from the data tab, using a view, and do the update.

3

This topic was automatically closed after 70 days. New replies are no longer allowed.