I took a crack at solving this without a script in the latest episode of the BuiltOnAir podcast: S15, E01. In short, you'll need one automation and two "helper" formula fields
https://www.youtube.com/live/G2zGaPN98zU?feature=share&t=2586
The formulas for the two helper fields discussed in my implementation:
⚙️Clamped End Date
The following formula will get the Friday of whatever week "Start Date" is in.
IF(
{Start Date},
DATEADD({Start Date}, 5-WEEKDAY({Start Date}), "days")
)
⚙️ Next Start Date
Te=he following formula will simply add one week to the "Start Date" if the "Clamped End Date" is before the "End Date". Essentially, if the time span is longer than a week, this field tells the automation that a new record needs to be created, and this date will be its "Start Date".
IF(
{⚙️ Clamped End Date} < {End Date},
DATEADD({Start Date}, 1, "week")
)
I took a crack at solving this without a script in the latest episode of the BuiltOnAir podcast: S15, E01. In short, you'll need one automation and two "helper" formula fields
https://www.youtube.com/live/G2zGaPN98zU?feature=share&t=2586
The formulas for the two helper fields discussed in my implementation:
⚙️Clamped End Date
The following formula will get the Friday of whatever week "Start Date" is in.
IF(
{Start Date},
DATEADD({Start Date}, 5-WEEKDAY({Start Date}), "days")
)
⚙️ Next Start Date
Te=he following formula will simply add one week to the "Start Date" if the "Clamped End Date" is before the "End Date". Essentially, if the time span is longer than a week, this field tells the automation that a new record needs to be created, and this date will be its "Start Date".
IF(
{⚙️ Clamped End Date} < {End Date},
DATEADD({Start Date}, 1, "week")
)
Wow, @Kamille_Parks11 !! I'm honored that you used my question on your podcast, THANK YOU! this solution is brilliant - exactly what I was looking for. I'll work on testing it and will let you know if I have nay questions. THANK YOU SO MUCH!