My suggestion is to make a child table called Sales Opportunity Months. One Sales Opportunity will have many Sales Opportunity Months.
When a Sales Opportunity is added or edited, you will trigger an Automation to delete all children as step 1.
Then the Next Step will be to create say 12 children, or more if you think that the longest span of the opportunity would be more than 12 months. To do that you will need to calculate 12 fields representing the first of the month for each month from the start date to the end date. Some of them will be blank as say if its a 3 month project, then months 4 through 12 will have blank dates. The dates should be in a date format set to the 1st of the month. The value per month will be calculated by taking the sales opportunity and dividing it by the number of montha to be spread.
So the Automation would have 14 steps
Step 1 . Delete Existing children
Steps 2 thru 13 - Create 12 children whether you need them or not
Step 14 delete an children with no dates.
3.
Then the last step of the automation will be to delete any children with blank dates.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
