Hello!
I'm helping a TV Station track their various weekly productions and was looking for help on a way to automate the creation of future recurring show and segment records. The main issue I am running into is how do I populate future Date and Time fields for the various productions in an automation based upon each productions schedule/template.
For context each of the 8 productions has a base with a table called "Shows" that has a one to many relationship with a "Segments" Table with the following fields.
| Shows Table | Segments Table |
| Status (Single Select: Pitch, Production, Aired) | Placement (Single Select: A, B, C, etc) |
| Air Date & Time | Taping Date and Time |
| Segments (Linked Records) |
Two production template/schedule examples
| Shows Table | Segments Table |
| Show 1 - 12-15-22 7pm Air Date | Segment A - 12-15-22 4pm Taping Date |
| Segment B - 12-15-22 4:30pm Taping Date |
| Shows Table | Segments Table |
| Show 2 - 12-15-22 10am Air Date | Segment A - 12-15-22 7am Taping Date |
| Segment B - 12-15-22 7:30am Taping Date | |
| Segment C - 12-15-22 8:00am Taping Date | |
| Segment D - 12-15-22 8:30am Taping Date |
The trigger each automation would be IF Show Status = Aired then create a new " production template" preferably 3 months out so they can have a backlog for planning!
Thank you in advance for everyone who helps, this has been a puzzle that my brain is having trouble solving!!