Duplicating Form Entries

This is only possible with MiniExtensions:

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.

Hi Rebecca,

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!

Thanks!

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

Awesome! Thanks!

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?

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.

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

@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?

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!

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

aaaand problem solved with the release of scheduled automations