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
------------------------------

michaelmahon · 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------------------------------

michaelmahon · 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

Same reference field, different selections within the form

Bulk create child records from selection list

Repeating calendar events

Using multi select field in pipelines

Unique Individuals

Recent Discussions

Question about relationships

Summary Table Question

Google Search is back

Can I use quickbase actions within the same table?

Looking for Consultant: Add time tracking to existing task management app.