I am trying to automate the creation of intermediate dates (by month) given a date range .

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
For example for range 1/1/2017 - 12/31/2017 , I would like to create records for each of the intermediate months (Jan through Dec) . How can I acheive this in QB ?  The ability to execute a do loop with the number of executions passed as a parameter in an APIAdd record call would achieve this , but not sure how to do that .
Photo of Anu

Anu

  • 0 Points

Posted 2 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,532 Points 20k badge 2x thumb
See this forum question, answer and demo:

https://quickbase-community.intuit.com/questions/1383163


https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=511


https://haversineconsulting.quickbase.com/db/bkw2ff3e3?a=td


In regards to the demo, bear in mind that the prior user has probably created records before you pushed on one of the buttons to create a new set of records. The application has been set up to allow you can create your own parent records and push the buttons to create new child records according to the parameters entered on the parent record..