Forum Academy Marketplace Showcase Pricing Features

What is the best practice for scheduling a workflow to trigger regularly, to iterate through a list?

Hi All,

A quick forum search for ‘scheduling’ reveals a number of approaches, from using Zapier/EC2 to scheduling API workflows and custom events. It is not clear to me if Bubble’s scheduling tools make it unnecessary to use Zapier now.

For context, here is what I’m trying to do. Once a week I want to iterate on a list of students and assign them to groups.

What is the best way to achieve this scheduling and iteration please, given that I’m on the personal Bubble plan and also a paid Zapier plan? Any advice would be appreciated. Thanks.

Regards,
Louis

You can use the “Schedule by Zapier” Trigger and the “Webhooks” Action to make a weekly POST call to your Bubble app to run an API Workflow.

Thaks for the comment and link @natedogg. I note from one of your earlier posts that you experienced some problems with your Zapier hooks, where they suddenly stopped working. Did you get that resolved eventually?

Also, this takes care of the recurrent scheduling part, do you have any suggestions on how to iterate through a list of users, please? I think if I were simply trying to execute a workflow on all or a subset of users in one go I could probably figure that out, but in this case, I need to create a group and assign 10 users to it, then another group of 10 until all users are assigned.

Note that I have data types for Group (id, active?) and GroupMember (group, user, active?, etc) and of course User (email, grouped?, etc) . So my workflow would start by initialising - set all existing Groups and GroupMembers to inactive and all users to grouped = no. Then I would create a new group record in Group with active = yes, and then 10 GroupMember records in turn, each for a user and the group just created. Each new group member is marked as active and each newly grouped user as grouped = yes. The issue is how to repeat this step for the next 10 users and the next 10 after that and so on.

I think I just need a nudge in the right direction. Any help would be greatly appreciated.

Never mind, I figured it out. I used a combination of Zapier and Schedule an API Workflow on a list. It’s a bit long-winded need, but my groups are getting created.

1 Like