I am trying to add a Revenue section in my Opportunity Module. After entering the revenue amount, we want to be able divide the amount by intervals and have it list in fielded based on a date that is calculated from the revenue start date and intervals entered. I am having issue writing a syntax for this.
| Field Name | ||
| Revenue_Amount_c | Amount | $30,000 |
| Expected Close Date | 13-Sep-24 | |
| Monthly, Yearly | Monthly | |
| intervals_c | Intervals | 3 |
| revenue_start_date_c | Revenue Start Date | 8-Jan-25 |
| I need it to populate like this section | Revenue Schedule | |
| Jan 8 2025 | $10,000 | |
| Feb 8 2025 | $10,000 | |
| Mar 8 2025 | $10,000 | |
| This section would be for manual enteries | Manual Entry | |
| Revenue Schedule | ||
| Jan 8 2025 | $20,000 | |
| 15-Mar-25 | $5,000 | |
| April 6 2025 | $5,000 |