



Help Creating Multiple Swim Sessions in Airtable Based on Date Range
What I'm Trying to Do
I'm building a Zap to create multiple swim lesson sessions in my Airtable base. I need to generate recurring swim sessions on specific days of the week (like Sundays) within a date range.
Here's my workflow:
- Trigger: New record in my "session openings" table in Airtable
- JavaScript step: Generate sessions for each Sunday between start date and end date
- Loop step: Create individual records for each session in my "SUMMER SCHEDULE" table
Current Setup
- Trigger: When a new record is created in my "session openings" table with:
- Instructor (linked record)
- Location (text)
- Start Date (date/time)
- End Date (date/time)
- Repeating (single select - "Sunday")
- Code by Zapier: JavaScript to generate all sessions between dates
- This successfully generates 4 sessions (one for each Sunday)
- Output includes: Session dates, day of week, instructor, location, etc.
- Create Loop From Text: Trying to loop through my sessions
- This is where I'm stuck - I can only get it to create one session
Problem I'm Having
My JavaScript generates multiple sessions correctly (I can see all 4 Sundays in the output), but I can't figure out how to properly set up the "Create Loop From Text" step to iterate through each session and create separate records in Airtable.
The JavaScript output looks like this:
Sessions Count: 4
Sessions Text: [JSON data for all 4 sessions]
firstSession: [Details of first session]
Questions
- How do I correctly set up "Values to Loop" in the Create Loop From Text step to process all 4 sessions?
- Should I modify my JavaScript to output data differently to work better with Zapier's looping functionality?
- Is there a simpler approach to creating multiple recurring sessions based on a date range and day of week?
I appreciate any guidance on getting this automation working correctly. Thanks!