Hi Zapier Community,
I’m trying to set up a Zap that automates recurring weekly bookings in Airtable when a client books a "Weekly Session." Here's what I need to happen:
Trigger: When a record in Airtable is updated (Booking Status changes to "Booked" and Session Type = "Weekly Session").
Looping by Zapier: The Zap calculates the number of weeks between Start Date Session and End Date Session and loops that many times.
Create Record in Airtable: For each loop iteration, Zapier should create a new booking, adding 1 week per iteration to the original Start Date Session.
Issue I’m Facing:
- I tried setting the Start Date Session in the "Create Record" step using:
javascript
Copy
But it’s not working correctly—either the date isn't incrementing, or the Zap runs into errors.{{1. Start Date Session}} + {{Loop Iteration}} weeks
- I'm also getting a "Possible Zap loop detected" warning, even though I ensured that my Zap is not triggering itself.
What I Need Help With:
How should I properly set up the date calculation in Zapier to add 7 days per loop iteration?
How can I prevent a loop warning while still creating new records in Airtable?
I’d appreciate any help! Thanks in advance.