Jan 13, 2021 07:34 AM
I am a Learning Design Coach for a virtual school and we use forms in AT to schedule our live lessons. Is there any way to have forms duplicate so for teachers who host live lessons every Wednesday (for example) can enter one form and have it repeat every Wednesday? Thank you very much!
Jan 13, 2021 07:46 AM
This is only possible with MiniExtensions:
Jan 13, 2021 07:57 AM
I have a couple questions about your use case but id like to try to help.
What is the purpose of the form/why do the teachers submit a form in the first place?
What type of data is in the table the form falls into when submitted?
What exactly is it you need to happen on a regular interval by submitting this form the first time?
You don’t have to be specific about your data just a general idea of what you need repeated every Wednesday.
Jan 13, 2021 08:25 AM
Thanks for the response!
So we are a virtual school and one of the many uses of Airtable for us is our Live Lesson Calendars. Our teachers fill out a form with the date and time of the lesson as well as any pertinent details about the lesson. We then have the playing card view (I forget what AT actually calls it) embedding into our students Canvas courses so they can see the available live lessons. Our elementary teachers tend to have regular lesson days and times and I was wondering if it would be possible for a teacher to fill out one of our forms and then it is repeated. For example Ms. Duffy wants to have a music live lesson every Wednesday at noon until school is out. Can she just fill out one lesson and then it duplicates for each week, almost like a reoccurring calendar event. Does this make sense? Thank you so much for any help you can provide! :slightly_smiling_face:
Jan 13, 2021 08:51 AM
Jan 13, 2021 09:30 AM
yes thats exactly what i needed. i wanna test this before i just start talking so ill come back in a couple hours with an answer. cant say itll be the one you want but itll be an answer haha
Jan 13, 2021 09:41 AM
Jan 13, 2021 11:30 AM
Are the lessons the same lesson repeated every week to different kids or different lessons each week to the same kids that add up to a course?
Jan 13, 2021 11:48 AM
So for example a third grade math teach hosts a weekly live lesson that works with that weeks unit. There is no real description of content in the form. We would just be changing the dates.
Jan 14, 2021 05:51 PM
Ok the problem im running into is that February is short and i dont know how to write the formula to conditionally change the number of days based on the number of days in that month specifically rather than a static value of 31 days. will anyone be teaching monthly classes? if not i can stop working on that
Jan 14, 2021 07:07 PM
@Daniel_Rushton in figuring out the answer i pretty much ended up just building it. would you rather i take the time to write out the entire solution on here? or would you rather i just give you what i built and let you make sense of it yourself? to give you the fish or teach you to fish?
Jan 15, 2021 05:39 AM
WHichever is easier for you would be perfect. I have a super strong team on my end that I am sure can figure things out with and example. Thank you very much!
Jan 21, 2021 07:42 AM
i cant for the life of me figure out how to give you this base lol im working on it i really am but i dont know how to pass ownership over to you without making you a collaborator on my workspace and theres a bunch of stuff in there so if someone can answer me that you can have it lol
Jan 25, 2021 02:56 PM
aaaand problem solved with the release of scheduled automations