Hi again @Jean_Pierre_Traets!
@Rahul_Jaisheel and @Daniel_Stieber are correct. I didn’t realize that FormulaMap had access to the direct column names since it’s context was only on a single row.
Formula: [Monthly Re-Occurring].FormulaMap(AddRow(Tasks,Task,TaskName,Date,RelativeDate(Date(Today().Year(),Today().Month(),DayOfMonth),1)))
You have to make a choice about what the “Day of the Month” means, within the context of “now”. I decided that when the script runs, it simple adds a task to next month, with the given date. This means the function above should only be run once a month,
If you want to have it run weekly, you’ll have to get fancier with your function to check the day of the current month, and whether the “Day of the Month” has passed or not. If done incorrectly, you will begin to get duplicate entries.
Lloyd