Parse selected calendar days into individual records

Question

How do I parse a block of calendar days selected in a calendar report into individual records. Example: If a user selects 14 days in a calendar a new record is created for each of those days totaling 14 days?

------------------------------
Michael MM
------------------------------

markshnier__you · Answer

There are a few ways to do this. What is the maximum # days this needs to work for? That will affect which choice would be best.

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

michaelm1138 · Answer

Not more than 10 business days or 14 calendar days------------------------------Michael Mahon------------------------------

markshnier__you · Answer

OK, np,We get to do this stupid simple brute force. &nbsp;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. &nbsp;Then make an automation to fire when a calendar record is added, changed or deleted and either the start or end date range changed.&nbsp;Step 1. &nbsp;Delete all children of the parent calendar RecordStep 2 through 16 is to create the &nbsp;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.&nbsp;------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

michaelm1138 · Answer

My apologies for the delayed response and follow up.&nbsp;We get to do this stupid simple brute force. &nbsp;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 (IN THE PARENT? ) to calculate (WOULD THIS BE A DURATION FORMULA?? see below) the 14 dates dates from 0 days to 13 days ahead. &nbsp;Todays([Field 13]-[Field 0])&nbsp;Todays([Field 13]-[Field 1])&nbsp;Todays([Field 13]-[Field 2])&nbsp;Todays([Field 13]-[Field 3])&nbsp;Then make an automation to fire when a calendar record is added, changed or deleted and either the start or end date range changed.&nbsp;Step 1. &nbsp;Delete all children of the parent calendar RecordStep 2 through 16 is to create the &nbsp;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.&nbsp;------------------------------Michael Mahon------------------------------

markshnier__you · Answer

These will be formula date fields.an example of one would be[Start Date] + Days(0)Then next one would be[Start Date]+ Days(1)------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Parse selected calendar days into individual records

5 Replies

Related Content

Calendar Reports not Loading

Multi-Select Fields with Commas in Pipelines

How to Calculate Completion Percentage Using Multi-Select Boxes

If Then Else formula with a multi select field.

Ongoing Schedual Calendar