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:
- Master Schedule
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.