Mar 30, 2021 09:41 AM
Thanks in advance for your help with this! I’ve searched through forums, watched YouTube videos and tried a number of example bases but still haven’t found the answer. I’ve set up an Airtable for my friend’s equestrian facility. It has the following tables:
We use the Master Schedule most often. Currently every new record concatenates rider name (pulled in from Riders) and date/time and then pulls in Horse, Trainer and Wrangler. This is fine entering each rider lesson manually, as it beats what my friend used to do, which is write down 60 items on a white board every day and then keep notes in pencil and paper in a massive binder to track lessons.
But since there are about 60 lessons a day (each record is rider + date/time + horse + trainer + wrangler and most are in group lessons), we were wondering if we could set it up so that riders automatically appeared in the Master Schedule weekly, since most riders do the same lesson the same day of the week, at the same time.
My friend would just go in and remove a record if the rider canceled that week.
Also - I’m on the Pro plan, if that helps.
Mar 30, 2021 10:39 AM
Welcome to the community, @Christine_Benton!
It sounds like you’ve done a great job so far in setting up Airtable for your friend’s equestrian facility! :cowboy_hat_face: :horse_racing:
There is no built-in support in Airtable for recurring events, so you’d need to figure out a way to create the recurring events on your own.
There are probably other scripts in these forums that handle recurring events, too — I would search for “recurring event”.
There are probably many other ways to handle recurring events as well (depending on what your specific needs are), but for now, all of these different options would require you diving into custom-crafting your own way of making this happen.
(Note that I am a professional Airtable consultant and a Registered Integromat Partner, and the Integromat link contains my personal referral code. If you have a budget for your project and you’d like to hire a consultant to help you with any of this, please feel free to contact me through my website at ScottWorld.com.)
Mar 30, 2021 11:00 AM
Thanks so much, Scott! I really appreciate your support. I was just watching the scripting tutorial–it’s so cool what you can do with Airtable and integrations! I will try the scripts and/or Integromat and will report back. -Christine
Apr 12, 2021 10:47 AM
Update - I’m still working on learning scripting. I’ll share the script when I figure this out.