# High-level overview of how this would work?

**URL:** <https://forum.bubble.io/t/high-level-overview-of-how-this-would-work/92179>\
**Category:** App Organization\
**Created:** [May 17, 2020, 1:36am UTC](https://forum.bubble.io/t/high-level-overview-of-how-this-would-work/92179 "2020-05-17T01:36:30Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![jackwabbit](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jackwabbit/32/61288_2.png) [@jackwabbit](https://forum.bubble.io/u/jackwabbit)\
**Post date:** [May 17, 2020, 1:36am UTC](https://forum.bubble.io/t/high-level-overview-of-how-this-would-work/92179/1 "2020-05-17T01:36:30Z")

</div>

Hey Bubble community, as a brand-new bubble user, i’m having a very hard time conceptualizing how the app I want to build would work.

I will and want to do the research into how to get everything set up and working but i’m lost on where to start.

* * *

What I want to do is pull data from Airtable (Name, Phone Number, Sign up date) with an API call I created (working)

Then some how set up a system to make scheduled Twilio API calls to send scheduled texts to each phone number pulled from Airtable.

For example: Do Twilio API Call #1, 1 day after the “Sign up date” for each number in the list

Twilio API Call #2, 3 days after the “Sign up date”

etc…

The whole goal of this app is to nurture free-trial sign ups through their 5 day trial with our service.

I got my Twilio and Airtable API calls set up in Bubble and they’re working, I am just completely lost on how I would continue this project.

Any high level overview of how you think this might work, nudges in the right direction, or links to similar tutorials/docs would be really appreciated

---

<div class="post-metadata">

**Author:** ![SerPounce](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/serpounce/32/62068_2.png) [@SerPounce](https://forum.bubble.io/u/SerPounce)\
**Post date:** [May 17, 2020, 6:15pm UTC](https://forum.bubble.io/t/high-level-overview-of-how-this-would-work/92179/2 "2020-05-17T18:15:53Z")

</div>

From my POV, this sure is an interesting post. It’s as if you got the hard stuff figured out and need help with some Bubble basics.

Here is a link to the announcement on recursive workflows.

> [@\[New Feature\] Scheduling API workflows can now be done recursively](http://forum.bubble.io/t/new-feature-scheduling-api-workflows-can-now-be-done-recursively/37372/48):
>
> where is the “while” condition located? Won’t the “only when” condition make it run a single time?

The summary of that post for your situation is to set up a backend workflow that triggers itself each day. Here is my set up for a similar scenario:

 ![Screen Shot 2020-05-17 at 2.14.06 PM](https://us1.discourse-cdn.com/bubble/original/3X/1/5/1550a4895843daf43e2d206df2ef2f54fedb9a83.png)

The zroutine\_triggerdailyemail looks for users that have had activity in the last day and sends them the email from within zroutine\_dailyemailfirst. I imagine your scenario would look for users that have signed up 1 day ago, 2 days ago etc. You’ll just need to set up an admin page with a button that fires the trigger workflow step manually for the first time.

Try playing around in this direction and bounce back with any questions.

---

<div class="post-metadata">

**Author:** ![jackwabbit](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jackwabbit/32/61288_2.png) [@jackwabbit](https://forum.bubble.io/u/jackwabbit)\
**Post date:** [May 17, 2020, 6:44pm UTC](https://forum.bubble.io/t/high-level-overview-of-how-this-would-work/92179/3 "2020-05-17T18:44:16Z")

</div>

Thanks a bunch @SerPounce very helpful! I’m going to play with that today and see what I can get working 😁 👍

---

<div class="post-metadata">

**Author:** ![jackwabbit](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jackwabbit/32/61288_2.png) [@jackwabbit](https://forum.bubble.io/u/jackwabbit)\
**Post date:** [May 18, 2020, 12:59am UTC](https://forum.bubble.io/t/high-level-overview-of-how-this-would-work/92179/4 "2020-05-18T00:59:28Z")

</div>

Hey @SerPounce making good progress over here. Do you know if this works? Intended outcome: Today’s date minus 3 days. So if today’s date was the 17th, the Sign Up Date would need to be the 14th correct?

It says \*\*+\*\*Days though so not sure if me adding “-3” breaks it:

 ![Screen Shot 2020-05-17 at 5.57.30 PM](https://us1.discourse-cdn.com/bubble/original/3X/7/4/742186dbd39252db33461429a24c81a5b93e2739.png)

---

<div class="post-metadata">

**Author:** ![SerPounce](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/serpounce/32/62068_2.png) [@SerPounce](https://forum.bubble.io/u/SerPounce)\
**Post date:** [May 18, 2020, 1:28am UTC](https://forum.bubble.io/t/high-level-overview-of-how-this-would-work/92179/5 "2020-05-18T01:28:06Z")

</div>

That’s exactly right. The -3 is the correct entry.

---

<div class="post-metadata">

**Author:** ![jackwabbit](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jackwabbit/32/61288_2.png) [@jackwabbit](https://forum.bubble.io/u/jackwabbit)\
**Post date:** [May 18, 2020, 1:29am UTC](https://forum.bubble.io/t/high-level-overview-of-how-this-would-work/92179/6 "2020-05-18T01:29:07Z")

</div>

Perfect, thanks a bunch. I think i’m close to getting the whole flow working now, i’ll let you know how it goes in case you’re curious 🙂

---

<div class="post-metadata">

**Author:** ![dfduqu01](https://avatars.discourse-cdn.com/v4/letter/d/34f0e0/32.png) [@dfduqu01](https://forum.bubble.io/u/dfduqu01)\
**Post date:** [September 19, 2020, 5:31pm UTC](https://forum.bubble.io/t/high-level-overview-of-how-this-would-work/92179/7 "2020-09-19T17:31:32Z")

</div>

Hey there, I have similar case where I’m using an Airtable to update 3k + rows of data of my appdata. So I Scheduled an API Workflow on a list where it gets data from an external API (Airtable) and it works just fine. However, since it has to update 3k+ rows of data (and will continue to increase), I am running into capacity issues and the workflow times out must of the times.

Therefore, I run into the recursive API Workflows and have been trying to set it up but haven’t been successful.

> [@\[New Feature\] Scheduling API workflows can now be done recursively](http://forum.bubble.io/t/new-feature-scheduling-api-workflows-can-now-be-done-recursively/37372/20):
>
> This is great – thanks!

Here you have the way I set it up:

 ![Screenshot 2020-09-19 at 11.33.25 AM](https://us1.discourse-cdn.com/bubble/original/3X/9/f/9f1e9cda09f2542b06e4fe27c899dc43dceb92f4.png)  
step 1) Schedule an API workflow when a button is clicked. Make changes to a thing. I created a date field to record the date and time it was updated, and to be able to constraint those things that have been updated already.

 ![Screenshot 2020-09-19 at 12.19.05 PM](https://us1.discourse-cdn.com/bubble/original/3X/e/6/e61138cf6f8bc450c82ee4dbb0d6066a8879ace8.png)  
step 2) Schedule the same API Workflow (LOOP). With condition. Only when Things last\_process \< current date/time +(days): -3

Whenever I ran test and check on server logs it says action condition failed.

If anyone could shed some lights on what I’m doing wrong I’ll greatly appreciate it.

---

<div class="post-metadata">

**Author:** ![jackwabbit](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jackwabbit/32/61288_2.png) [@jackwabbit](https://forum.bubble.io/u/jackwabbit)\
**Post date:** [September 19, 2020, 5:49pm UTC](https://forum.bubble.io/t/high-level-overview-of-how-this-would-work/92179/8 "2020-09-19T17:49:21Z")

</div>

Check out my other thread here. I asked a similar question about how to efficiently update Bubble w/ Airtable when the Airtable database gets huge.

Some people left some answers, I don’t understand their answers very much but maybe it will help you out 🙂 Thread: [Is this efficient?](http://forum.bubble.io/t/is-this-efficient/99205)

---

<div class="post-metadata">

**Author:** ![dfduqu01](https://avatars.discourse-cdn.com/v4/letter/d/34f0e0/32.png) [@dfduqu01](https://forum.bubble.io/u/dfduqu01)\
**Post date:** [September 19, 2020, 6:32pm UTC](https://forum.bubble.io/t/high-level-overview-of-how-this-would-work/92179/9 "2020-09-19T18:32:09Z")

</div>

> [@jackwabbit](#):
>
> Is this efficient?

Hey @jackwabbit, thanks. I’ll check out the thread.
