Mass create records automation

Here is now i would do it natively.

I can't explain every single click to set this up, but here is the gist of the solution and we may have to work together to set it up.  There is also a choice between using formula URL buttons and trying to use Automations.

I would ask you what the highest # of span of days it would need to handle it.​  Say the answer is 260 business days.   52 weeks @ 5 days per week.

I would load a New table called Week Days with 260 records and block any user from adding or deleting records.  The Record ID#s will be numbered from 1 to 260.

I would create another table with single record in it [Record ID#] = 1 and call this table Focus Date Range.  It will have three fields - the start and end dates and the [Record ID# of the Focus Daily Report].

I would create a relationship where 1 Date Range has many Week Days based on a formula reference field that calculates to 1, and then lookup the start date and the end date and the Record ID# of the Focus Daily 

I would then make a formula date field on Week Days to calculate the weekday to be created with a formula of
WeekDayAdd ([StartDate], {Record ID#]-1)

I would then make a saved table to copy the records in the Week Days table to the daily reports table subject to the filter that the calculated week day is between the start and end dates and being sure to populate the field to [Related Parent Table]

Then just setup tor Automation to trigger when those dates are filled in and your "parent table" has no Daily Reports Children yet. 


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------