Create an entry for each specified day between two dates (ie for each Monday next month)

Nathan
New Member

Hey y’all,

I’m racking my brain trying to figure out how I’d do this with Appsheet. I sell a recurring service where we stop by the customer’s house at specific frequencies. I’d like to use Appsheet to make my service schedule. To do this, I would need to take a list of each active subscription on a route (day of the week), and have the system create an entry for each service day in the next time period.

So I’d like to take a list of each Monday subscription, then set a date range and have the system create an entry (schedule) for every upcoming Monday in the specified date range, creating scheduled jobs for each recurring subscription.

Hopefully my post makes sense, I’d love to hear any ideas. Thanks!

Solved Solved
1 7 1,781
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

Your post inspired me! I spent the last day and a half putting together this sample app to demonstrate how to do what I think you want entirely in-app.

https://www.appsheet.com/samples/community25013?appGuidString=eab9aab8-f1ad-4fd1-9fa4-d22e0f961067

I went a little overboard, so there’s more than you expressed an interest in (as I said, I was inspired!), but the basics are in there. If you need help teasing out only what you need, just speak up!

Email and related notifications are implemented with workflows, so will require you make your own copy of he app to test.

View solution in original post

7 REPLIES 7
Top Labels in this Space