OK, np,
We get to do this stupid simple brute force. I assume that these records will be children if the parent Calendar Record. Look up the value of the [Last date of the range] down to the children.
Make 14 new formula date fields to calculate the 14 dates dates from 0 days to 13 days ahead.
Then make an automation to fire when a calendar record is added, changed or deleted and either the start or end date range changed.
Step 1. Delete all children of the parent calendar Record
Step 2 through 16 is to create the 14 children.
Step 17 is to delete all children which are older than the [
Last date of the range]
The reason for the first step to delete all its children is to handle if the date range is changed.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
